SQL to get subscribed list (GetPage - Access denied) - EPI 5
Vote:
Hi Guys,
My scenario: An user that gets an access denied error on index page. The line of error do a GetPage call. So, it's probably right access. The page is result of subscribed list.
1. I'd like to get the subscribed pages (By SQL) to confirm if my user has some stoped/unpublished page.
2. Here you are the method that returns the list, but I want to get the SQL to confirm this information.
//Clear user query from cache StandardPageEntityQuery query = new StandardPageEntityQuery(); UserCriterion userCriteria = new UserCriterion(); userCriteria.ID = new IntegerCriterion(); userCriteria.ID.Value = user.ID;query["Subscribers"] = userCriteria;StandardPageEntityCollection collection = QueryHandler.GetQueryResult(query);return collection;
If I have the page id that I'm getting an error, I can understand what's going on.
Hi Guys,
My scenario: An user that gets an access denied error on index page. The line of error do a GetPage call. So, it's probably right access. The page is result of subscribed list.
1. I'd like to get the subscribed pages (By SQL) to confirm if my user has some stoped/unpublished page.
2. Here you are the method that returns the list, but I want to get the SQL to confirm this information.
//Clear user query from cache(query);return collection;
StandardPageEntityQuery query = new StandardPageEntityQuery();
UserCriterion userCriteria = new UserCriterion();
userCriteria.ID = new IntegerCriterion();
userCriteria.ID.Value = user.ID;query["Subscribers"] = userCriteria;StandardPageEntityCollection collection = QueryHandler.GetQueryResult
If I have the page id that I'm getting an error, I can understand what's going on.