Blocking Query_range ACL for non-existing field?

kim-lindgren
Kilo Sage

I have created a list report on the cmn_notif_device table. There is a related list condition in the filter set to the following:

 

kimlindgren_1-1779207137414.png

---

 

Now when I impersonate the user who should be able to access it via a read ACL, I get the following error message: 

Part of the query on cmn_notif_device has been ignored because of insufficient access for 'query_range' operation on sys_notif_subscription.devices

 

I thought then that I should simply set up a query range ACL for the table "sys_notif_subscription" and the field "devices" - but this field does not exist on that table.

 

What am I missing here?

 

Best regards,

Kim

1 REPLY 1

Tanushree Maiti
Mega Patron

Hi @kim-lindgren 

 

Just create a query_range ACL on table field level sys_notif_subscription.devices .

ACL role- set as Public until and unless you have specific role, which you need to assign separate to user .

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: