I have a little Problem. I'm trying to do the following. There is a Field on SharePoint List items called HasUniqueRoleAssignments that is hidden on a standard REST call. If I put it in the select string of the rest call I will retrieve it. So far so good. But what I apperently can't do is use it in the filter statement. So the URL


will work just fine. But if I try


the request will fail with the error message, that the column HasUniqueRoleAssignments is not available.

Does anyone have an idea, how to use the filter to get items with

HasUniqueRoleAssignments = false or true?

Would be thankful for help


Try to use this endpoint:

.../sites/site/_api/web/lists/getbytitle('Listname')/items?$select=Id,HasUniqueRoleAssignments&$filter=HasUniqueRoleAssignments eq 0&$top=1000


Filtering a boolean field with 'false' means a string.

If you want filter true use: eq 1 instead of eq 'false'.

And false use: eq 0 instead of eq 'true'.

  • sadly that doesn't work. The problem doesn't seem to be the value I'm filtering but the Column. SharePoint tells me that it doesn't exist even though it obviously does Nov 28 '17 at 20:57
  • 1
    Hasuniqueroleassignment is a property, not a column. You cannot use $filter with properties as a condition. $filter will only work with columns. Jul 24 '19 at 0:34

Its a hidden property can't be used in rest filtering, what you can do is copy the value of it in a metadata on item creation / edit (depends on your instances) and use that created metadata to filter your items.

Hope it helps! Happy SharePointing!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.