query range acl

[Deepanshi1]

Part of the query on sn_shop_purchase_order has been ignored because of insufficient access for 'query_range' operation on sn_shop_purchase_order.supplier.legal_name

hi i am getting this error whenever i am impersonating the user and he is trying to search in header by supplier name.

pls help.

supplier name is coming from supplier table

[Anurag Tripathi]

What did you try?

[raviteja1600]

From the ServiceNow MAY Patch Upate this issue is happening to all the instances.

Please refer to the KB Articles of ServiceNow Support "KB2046494 & KB2130442" Those will be helpful to debug & fix.

[MahimaChoudhary]

Hi @Deepanshi1 ,

Assuming the user can see the supplier field on the sn_shop_purchase_order table, the issue isn't with that table but with the referenced supplier table and its legal_name field. To resolve it, create two ACLs on the supplier table: one table-level ACL with the query_range operation (name: supplier.None), and one field-level ACL for legal_name with query_range (name: supplier.legal_name). This will allow the user to query that field.

-Mahima