What is best method to get GetItemsWithUniquePermissions count from SharePoint 2013 using client context (CSOM)?

Question

I’m converting Event receiver codes into Remote event receiver using SharePoint 2013 Client context. I need to get list items with unique permissions count to validate while creating new document in certain site collections

It is possible using SharePoint object model

SP.List.GetItemsWithUniquePermissions().Count()

I written the below logic to get list items with unique permissions count in CSOM but it is throwing timeout exception

var items = list.GetItems(CamlQuery.CreateAllItemsQuery());
            ctx.Load(items, icol => icol.Include(i => i.RoleAssignments.Include(ra => ra.Member), i => i.DisplayName));
            ctx.ExecuteQuery();
            List<string> uniqitem = new List<string>();
            foreach (var item in items)
            {
                foreach (var assignment in item.RoleAssignments)
                {
                    uniqitem.Add(assignment.Member.Title);
                }
            }
            int itemCount = uniqitem.Distinct().Count();

Could you please suggest me the right method in CSOM ? Thanks in advance

score 0 · Answer 1 · answered Nov 15 '16 at 22:55

0

Try this

var items = list.GetItems(CamlQuery.CreateAllItemsQuery());
ctx.Load(items, icol => icol.Where(i => i.HasUniqueRoleAssignments == true));
ctx.ExecuteQuery();
int itemCount = items.Count;

answered Nov 15 '16 at 22:55

Ricky Sua

16

Thank you so much, It is responding result better than my code but not resolved my issue. – kalimuthu Nov 17 '16 at 11:56

score 0 · Accepted Answer · answered Nov 21 '16 at 11:47

Thanks, it is slight faster now

var items = list.GetItems(CamlQuery.CreateAllItemsQuery());
ctx.Load(items, col => col.Include(i => i.HasUniqueRoleAssignments));
ctx.ExecuteQuery();
int itemCount = items.Where(i => i.HasUniqueRoleAssignments).Count;

What is best method to get GetItemsWithUniquePermissions count from SharePoint 2013 using client context (CSOM)?

2 Answers2