About Number of rows removed from this list by Security constraints: 20

[Chang Shuang]

I want to create a read ACL with script.

The script is like this (as an example).

answer =true;

if(current.opened_by != gs.getUserID()){

    answer = false;

}

But when I impersonate other user. 

the message is displayed :Number of rows removed from this list by Security constraints: 20

How can I solve  this issue?
Thank you very much.

[Anil Lande · Accepted solution]

Hi,

If you use ALC then you will get this error.

The alternative is to use Before Query Business rule on your table, you can find similar BR on incident table that restrict accees to non-itil users

https://docs.servicenow.com/bundle/vancouver-platform-security/page/administer/company-and-domain-se...

https://www.servicenow.com/community/developer-blog/query-business-rules-a-definitive-guide/ba-p/227...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0523826

[PhilOptDigiSol]

I don't think this is a good solution. Query business rules are one of the top ten causes of functionality not working and cases reports to ServiceNow.

[Anubhav24]

If you are using ACL , this will always be shown as "Rows removed by security constraints" , instead you should try and use Query Business Rules to avoid this message.

Please mark helpful/correct if my response helped you