"Number of rows removed from this list by Security constraints: 1" is displayed.

[chanken]

Hi everyone,

When grouping incidents by "assigned to", the message "Number of rows removed from this list by Security constraints: 1" is displayed.

This message is displayed after 20 records are included in the corresponding group.

The number of records included in the group is about 30000.

What is the reason of this message?

Maybe the specification that that does not list a large number of records when grouping that?

thanks.

[Karthik Reddy T]

Hello Kenji,

Can you please check is there any Read ACL has been written?

It might be issue with the ACL.

[Aakash Shah4 · Accepted solution]

Hi Kenji,

This issue occurs to because there might be some ACL running on that field or table level.

Please visit this link to which will help you to debug ACL

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/contextual-security/c...

[chanken]

Thanks everyone,

Thank you for your reply.

I was able to pinpoint the cause.

There was an ACL that was assigned a role that was automatically created when the table was expanded.

I do not use this role, so I will delete the role from the ACL or delete the ACL itself.

Is this all right with this solution?

[Aakash Shah4]

Hello Kenji,

Remove the role form the ACL.

Deleting the ACL from ServiceNow is not a good practise.