"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.

[chanken]

Hi Everyone,

I check the ACL based on your advice and the solution is progressing.

However, there are things that do not understand the solution.

Debug information is as follows.

-------------------------------------

3:41:58.95: TIME = 0:00:00.000 PATH = record/u_sys_itsm_incident.assigned_to/read CONTEXT = INC0100968 RC = false RULE =

                              record/u_sys_itsm_incident/read         Global

                              record/u_sys_itsm_incident.*/read         Global

-------------------------------------

This message is displayed only for one record.

This record be displayed form and displayed in lists that are not grouped.

"Record / u_sys_itsm_incident.assigned_to / read" does not exist.

"record / u_sys_itsm_incident. * / read" does not specify any roles or conditions.

"Record / u_sys_itsm_incident. * / Read" specifies only roles.

The user have that role.

What should I look up next?

regards.

[Chandu Telu]

Hi Kenji

Please find the below link it may help you

Security Constraints :1

Please provide your feedback appropriately (Like, Helpful, Endorse AND/OR Correct) to help community.

Thanks

Chandu Telu

[Jaspal Singh]

Hi Kenji,

Message "Number of rows removed from this list by Security constraints: 1" is displayed as there is a read ACL on incident table which is restricting 1 record to be hidden because of the ACL that exits.

You need to modify or disable the read ACL on incident table accordingly. Also, the count you get is the number of records that are not showing up because of the ACL.

[Chuck Tomasi]

If you wish to remove the error messages (and the missing rows) without modifying the ACLs - for example - keep the records secured, but don't display the nasty messages about security constraints (only showing the valid rows) - you can create a before/query business rule to do the filtering.

Reference:

Business Rules - ServiceNow Wiki

Business Rules Best Practices - ServiceNow Wiki