Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to create a query_range ACL for a complex readACL

kaka_1234
Tera Contributor

1) If readACL is allowed, is it possible to create a customized ACL that allows query_range?
2) If 1) is not possible, is it possible to write the same script as readACL in query_rangeACL and execute it?

By the way, the contents of readACL contain a script that goes through each record one by one and displays only the records that belong to that user.

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@kaka_1234 

what's your actual business requirement here?

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

kaka_1234
Tera Contributor

@Ankur Bawiskar 
Thank you for your reply

The design is such that when a button is pressed, a list of tables after a search using a certain query is displayed.
Person A does not have query_range access to a specific column.
I want the query_range search to be performed and the records to be displayed only when the button is pressed.
I want to prevent the user from freely performing query_range searches at any other time.

Furthermore, it would be even better if the number of rows removed from this list by Security constraints: {0} was not revealed when a query_range search was performed.

@kaka_1234 

you are referring to technical aspect, I would like to know business requirement

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

kaka_1234
Tera Contributor

@Ankur Bawiskar 
Sorry, what I want to do is the following

I want to provide users with search functionality in list view.
I want users to be able to search in columns they can read, but not in columns they cannot read.