Where is DotNetNuke page keywords stored in database?
Which SQL Server table can I locate keywords associated with a page in DotNetNuke?
Solution
Took me awhile to find it...
Keywords information for a single page is stored in a "Keywords" field within a table called, somewhat unintuitively named, Tabs
Keywords are updated through a sproc named AddTab.
Found it through DotNetNuke source code.
- convert Excel Date Serial Number to Regular Date
- Datetime function: semester, quarter
- Efficient way to forward-fill nulls in time-series data using T-SQL
- Get previous non-NULL value based on LAG function with dynamic offset
- Pad a string with leading zeros so it's 3 characters long in SQL Server 2008
- T-SQL Change Data Capture log cleanup
- Creating stored procedure in another database
- How to mitigate "No columns were selected" exception from GridReader
- How to escape a string for use with the LIKE operator in SQL Server?
- Get all data from the range of date including no record
- How to SUM by parent table value while ignoring child table cardinality?
- Insert into select from SQL query with both query and static values
- Is there a way to calculate correlation in TSQL using OVER Clauses instead of CTE's?
- Calculate data based on days and weeks in SQL
- Get second highest salary, return null if no second highest
- TSQL, break period by Month only for given year
- Correlate these tables dynamically (or automated)
- Round to the closest .25
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Drop group of stored procedures by name
- different deleting OUTPUT behaviour based on source table
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- SQL Server: Update table based on JSON
- Find the first occurrence of a string that's NOT within a set of delimiters in SQL Server 2016+
- ULID datatype in SQL Server database
- How to get biweekly dates per month in a year in SQL Server?