SQL Integration

This type of integration makes it very easy to extend NavXp when there is a reasonable SQL Query that can be executed to return the list of menu items. It's easy because you only have to create an XML definition and put the SQL Query there.

Here is an example XML we deliver with NavXp to integrate with the DotNetNuke Links module:
<?xml version="1.0" encoding="utf-8"?> <datasource> <id>dnnlinks</id> <title>Module</title> <type>sql</type> <cache>30</cache> <query-channels> SELECT DISTINCT M.ModuleID as Id, M.ModuleTitle + ' (id: '+ cast(M.ModuleID as nvarchar(10)) +')' as Caption FROM {databaseOwner}[{objectQualifier}Links] L LEFT JOIN {databaseOwner}[{objectQualifier}Modules] M ON M.ModuleId = L.ModuleId </query-channels> <query> SELECT 'dnnlink-'+cast(ItemId as nvarchar(10)) as Id, Title as Caption, '[NavigateUrl:'+ Url +']' as URL FROM {databaseOwner}[{objectQualifier}Links] where ModuleId={channelId} </query> </datasource>
Comments