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-(1)') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Resources/FAQ-(1)') AND ([DocumentCulture] = N'en-US')))
SimpleHandler`2.StartEvent 0.016
 
2
(cms.tree.selectblankpageinfo)
SELECT * FROM View_PageInfo_Blank WHERE ((NodeSiteID = 1)) AND (NodeAliasPath = N'/Resources/FAQ-(1)')
SimpleHandler`2.StartEvent 0.000
 
3
(cms.tree.selectbywildcardrule)
SELECT NodeAliasPath, DocumentCulture, DocumentURLPath, DocumentExtensions, DocumentCampaign FROM View_CMS_Tree_Joined WHERE @WildcardRule LIKE [DocumentWildcardRule] AND ((NodeSiteID = 1)) ORDER BY DocumentPriority DESC
@WildcardRule ("/Resources/FAQ-(1)")
238 B
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.documentalias.selectbywildcardrule)
SELECT * FROM CMS_DocumentAlias INNER JOIN CMS_Tree ON CMS_DocumentAlias.AliasNodeID = CMS_Tree.NodeID WHERE (@UrlPath=AliasURLPath OR @WildcardRule LIKE CMS_DocumentAlias.AliasWildcardRule) AND CMS_Tree.NodeSiteID = @SiteID ORDER BY AliasPriority
@WildcardRule ("/Resources/FAQ-(1)")
@SiteID (1)
@UrlPath ("/Resources/FAQ-(1)")
287 B
 
Table (1 [45], 252 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.tree.selectpageinfo)
SELECT * 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.000
 
6
(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
 
7
(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
 
8
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (1177)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:34:39 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
9
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
10
(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:34:39 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
11
(cms.tree.selectpageinfo)
SELECT * FROM View_PageInfo WHERE (NodeID = 745) AND ([DocumentCulture] = N'en-US')
Table (1 [67], 7.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
  11 queries, 2.8 kB write, 40 kB read   0.031