Resources > FAQ's  

Frequently Asked Questions

Click on the topic(s) below to find the answer to your questions.

 


Do you have a question we haven't answered? Contact the CILC Helpdesk at 507-388-3672.
FOLLOW US
ADDRESS
Center for Interactive Learning and Collaboration
2075 Lookout Drive
North Mankato, MN 56003
SUPPORT MENU
© 2016 Center for Interactive Learning and Collaboration Privacy Policy
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(SELECT * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (DocumentUrlPath = N'/Resources/FAQ-s') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Resources/FAQ-s') AND ([DocumentCulture] = N'en-US')))
Table (1 [67], 19.8 kB)
 
SimpleHandler`2.StartEvent 0.031
 
2
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Resources', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
188 B
 
Table (2 [172], 12.6 kB)
 
SimpleHandler`2.StartEvent 0.016
 
3
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 1177)
Table (1 [176], 20 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.class.selectrequiredroles)
SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4609)
@PermissionName ("read")
@SiteID (1)
251 B
 
Table (1 [10], 112 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (1177)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:32:57 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (1)

@UserID (65)
@SiteID (1)
@Date (7/19/2018 12:32:57 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.document.selectdocuments)
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentMenuClassOver], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemImageOver], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemLeftImageOver], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemRightImageOver], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentMenuStyleOver], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [SiteName], [NodeACLID], [NodeSiteID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Resources/FAQ-s', N'/Resources', N'/')) AND ([Published] = @Published AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Published (True)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.2 kB
 
Table (3 [42], 451 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
  8 queries, 3.3 kB write, 53 kB read   0.048