Why don't people use [ObjectQualifier,System] when referring to DNN tables?
Is there a problem using this, or any reason it shouldn't be used?
I've tried modifying the query with this - maybe missed something or not done it right but the Sitemap one isn't showing anything for me.
Modified:
declare @UserID int,@bIsSuper bit
set @userID = [UserID,System]
SELECT @bIsSuper = IsSuperUser FROM [ObjectQualifier,System]Users WHERE UserID = @UserID
SELECT TabOrder, TabName, TabID, [Level], dbo.ReWriteURL(url,tabid) as NewURL
FROM [ObjectQualifier,System]Tabs AS t where tabid IN
(
SELECT DISTINCT x.tabid from [ObjectQualifier,System]tabs x INNER JOIN TabPermission TP ON x.TabID = TP.TabID
INNER JOIN [ObjectQualifier,System]Permission P ON TP.PermissionID = P.PermissionID
LEFT JOIN (SELECT @UserID AS UserID, -1 AS RoleID UNION SELECT @UserID, RoleID FROM [ObjectQualifier,System]UserRoles WHERE UserID = @UserID) UR ON TP.RoleID = UR.RoleID
WHERE x.IsVisible = 1 AND x.IsDeleted = 0 and x.portalid=[portalid,system] and x.taborder<10001
AND P.PermissionCode = 'SYSTEM_TAB' AND P.PermissionKey = 'VIEW'
AND ( UR.UserID = @UserID OR @bIsSuper = 1 )
)
ORDER BY TabOrder