Query Range ACL error

[VullankiL]

Hi All,

In my custom application, there is a table like "custom_requested_item".  And there is also another table like "custom_requested_item_aux".  There both tables have reference to each other.

So, In "custom_requested_item" table list view, If I try to filter the records based on the field which is present in "custom_requested_item_aux" table by dot-walking, then for all dot-walking fields it is throwing error like below: 

"Part of the query on custom_requested_item has been ignored because of insufficient access for 'query_range' operation on custom_requested_item.req_item_aux.field_name"

Currently, In "custom_requested_item" table, there are 2 query_range ACL for table.none, and table.* for role "public"
I have gone through some community links, where they have mentioned to create new ACL for that field. But in my case the issue is occurring for all dot-walked fields. what should I do now?
Where Do I need to create/update the query_range ACL.. Please suggest the solution..

Thank you

[RaghavSh · Accepted solution]

Yes , you can try doing that, I believe that should fix the issue.

[Ankur Bawiskar]

@VullankiL 

please try to create query_range ACL on every dot walked field which you have added

ACL error on list filter - "Part of the query on incident has been ignored because of read security ... 

Understanding ServiceNow’s May 2025 Query Range ACL Update: What You Need to Know 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏