We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Bia dependency Table error query on workspace

abigailtaba
Tera Expert

3 weeks ago - last edited 3 weeks ago

Hi everyone,

I created a new field, u_depends_on_name, on the sn_bia_dependency table.

Some users are receiving the following error when they try to filter on this field:

Part of the query on sn_bia_dependency has been ignored because of insufficient access for 'query_range' operation on sn_bia_dependency.u_depends_on_name.

 

The field is new, and I'm wondering if there is an additional ACL or query_range permission that needs to be configured for users to filter on this field. Has anyone encountered this issue before? If so, what was the solution?

Any guidance would be appreciated. Thanks!

0 Helpfuls
  • 626 Views
1 REPLY 1

Nishant8
Tera Sage

3 weeks ago

Hello @abigailtaba , If any form or list that runs a query referencing a field they do not have query access to, this error message appears. Could you verify whether any query_match ACL exist on the table as sn_bia_dependency.* , if not then create a new ACL "sn_bia_dependency.u_depends_on_name" with operation "query_match" and assign an expected role.

Since you mentioned its a new field, I'm assuming there is no separate "query_match" ACL already written. otherwise this to be analyzed as well.

I'll suggest you to run Access Analyzer (Analyze Permissions) for the affected user, table, and field to identify which ACL is blocking access.

you can refer following article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB3115286

 

Regards,

Nishant

0 Helpfuls