Problem of ACL

[aymane]

Hello,

Please could you help me with this problem, on the table sc_req_item

I have this query filter : company.nameLIKElafa^sys_created_onBETWEENjavascript:gs.dateGenerate('2025-12-01','00:00:00')@javascript:gs.dateGenerate('2026-01-13','23:59:59')^cat_item.price>javascript:global.getCurrencyFilter('sc_cat_item','price', 'EUR;0'). 

However, i have a error message : Part of the query on sc_req_item has been ignored because of insufficient access for 'query_range' operation on sc_req_item.cat_item.price

I have verified my ACLs but I didn't figure out how to fixe it. Could you help me please ?

[Najmuddin Mohd]

Hello @aymane ,

ServiceNow has introduced ACL of type query_range. 
To resolve this, you can create an ACL of type of query_range on sc_req_item with field price and provide the role that should have access to it.

Some information from Community:

https://www.servicenow.com/community/developer-blog/query-acls/ba-p/3273676

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin

[aymane]

I already have the ACL sc_cat_item.price with the requires role of the user. 

So the user still facing the problem

[Najmuddin Mohd]

Hello @aymane ,

There are two things: Allow If and Deny Unless

Can you check is there any other ACL with Decision type: Deny Unless, which is stopping on the record.

Regards,
Najmuddin

[aymane]

I have clicked on accept the solution but its not the case.

As you can see the acl has the decision Allow if