Error- Number of groups removed from this list by Security constraints: 1

[Himabindu4]

I am trying to build a report on Approval Table to pull contract approvals, when trying to build ServiceNow Report -Error: Number of groups removed from this list by Security constraints: 1  shows up instead of the list of records.
The user has all of the following roles-

contract_manger,
report_global and,

report_user.

I have checked the ACL's too but I find no problem in them.

Please help me out to solve this issue.

Thanks in Advance!

[Jaspal Singh]

Hi Himabindu,

Did you check for Read ACL on sysapproval_approver table?

[Community Alums]

Hi Himabindu,

This happens because of Read ACL based on Group or User based filters. You need to recheck the read ACL conditions. 

The reason its only showing this when you do group by is that it sorts the list and when we have restriction in place using ACL it restricts the list but shows this message in place of those records. 

Please refer to this KB article that will help you understand this & give you are alternative [before Query BR] of those read ACL.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0657577

Took from this thread.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Himabindu4]

Thanks you all for the response,

Yes I have checked the ACL's and found no issue with that.

resolved this issue by modifying the Group By field on the reports.

Closing this thread here!!!!