Live Tabs is extremely flexible and can be customized in many ways by advanced users. One of the features of Live Tabs is to create tabs using a SQL Query. Simply provide the SQL Query and Live Tabs generates tabs out of data returned by SQL Query. Watch the video below to get started.
Step 1
Navigate to Manage > Administration > Mode > Select SQL Query from drop-down
Select Connection (Default DNN Database is SiteSqlServer) and provide your SQL Query
Required Alias: SQL Query must have 'Name' alias which is used for the Tab's Name.
For Example: Let's say you have following SQL Query:
SELECT Title, FirstName, LastName FROM Employees
Now if we wanted to create a tab for each employee with their last name then the query would look like:
SELECT Title, FirstName, LastName as Name FROM Employees (Notice that we gave Lastname an alias of Name which tells Live Tabs to use it as Tab's Name)
Available Aliases:
Name: Tab's Name
Content: Tab's HTML Content
Header: Tab's HTML Header. If specified, it will be used instead of Tab's Name
Link: Tab's Link. Must be an absolute URL such as http://www.google.com
Search Summary: Search summary for DNN Search. If provided, tab will automatically be included for DNN Search Index.
LoadOnDemand: This must be a bit field and requires 0 or 1 specifying whether the tab load's on demand.