Number of groups removed from this list by Security constraints: 2

ArcRaj
Giga Contributor

‎07-09-2020 08:32 AM

Hello Team,

I created a report on a table "X" ,In the list view of the report I have 44 records ,But when I grouped by using one column "Y" it gives me  only 42 records,With a message at the below 

" Number of groups removed from this list by Security constraints: 2"

 

My question is :Why only 2 records are not showing when am using group by on column??

And if there is any "read" ACL on my table it should restrict all the records right??Else at least it should not show the records in List view of report as well .But it only happens when am using "group by"

 

Is there any possibility that column "Y" restricting the records.But I did not find any ACL on column "Y"

Note-I do have admin role.(And am running this report on database view)

I checked for all the read ACL's with admin overrides "false" .find_real_file.png

 

I checked for all the read ACL's with admin overrides "false" .

Is there any possibility to show up those 2 records while using group by??

 

Thanks in Advance.........

Have a good day.

Preview file
5 KB
0 Helpfuls
  • 4,198 Views
3 REPLIES 3

MrMuhammad
Giga Sage

‎07-09-2020 08:43 AM

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

 

Thanks & Regards,

Sharjeel

Regards,
Muhammad

ArcRaj
Giga Contributor

‎07-17-2020 01:21 AM

Hi,

I checked for all the read ACL's with admin overrides "false" .

But still ,Iam unable to find the appropriate one:(((

Is there any possibility to configure something apart from Acl's?

 

Thanks in Advance

0 Helpfuls

Sudhanshu Talw1
Tera Guru

‎07-17-2020 01:44 AM

Hi Archie,

if you have admin role & still you are getting this " Number of groups removed from this list by Security constraints: 2", that means some ACL's are preventing it to allow you to access those.

 

Even i have admin role in my Org instance but i faced the same issue, please check those two groups belong to which application scope. Then check ACL of those.You may get an idea why is it happening.

 

Thanks 

Sudhanshu

0 Helpfuls