Unable to see incidents in list view and Number of rows removed from this list by Security

[thirumala goud]

Hello Experts,

I impersonated one user but he hasn't seen access to the incidents list view and he is getting this error "Number of rows removed from this list by Security constraints: 20.

And I have written the Query Business Rule but it's not working.

Please help me out

@Ankur 

Thanks

Thiru

[Uncle Rob]

The number of rows removed by security constraints tells me the impersonated user doesn't have the rights in the first place.  Therefore its an ACL issue before its a Before Query business rule.

https://youtu.be/PRl4HxRu120

[thirumala goud]

Hi Robert.
I can find only errors only, What should be the next steps, Could you please explain briefly and share any scripts?

Thanks

Thiru

[Shreya Wani]

Hi @thirumala goud,

- The error "Number of rows removed from this list by Security constraints: 20" is coming because there should be a Read ACL written on the 'incident' table. That ACL is hiding the visibility of the incident records for the user you have impersonated with. The user should definitely be having some role which has been added to the Read ACL.

- Generally, whenever Query Business rules are applied, they do not show any error message and hide the records on which the rule is applied. The lack of such a message, when records are removed by "security" (using query business rules, which provide no such message) is what anyone trying to troubleshoot missing records could find confusing. 

- So, I would suggest you to check out the ACL first and the role for which it is applied to by configuring the table.

For more information, you can check out the below ServiceNow product documentation.

https://docs.servicenow.com/en-US/bundle/vancouver-platform-security/page/administer/company-and-dom...

If you feel that I have assisted you in any manner, please mark my comment as helpful/correct.

Thanks,

Shreya Wani

[thirumala goud]

Hi Shreya,
i can try many ways but not working, Please explain briefly. Could you please share  any script, I can past it here 

Thanks

Thiru