Missing records while grouping by fields

[sairamsouja]

Number of groups removed from this list by security constraints

when grouping by fields some records are missing and showing "Number of groups removed from this list by security constraints" when giving specific conditions the records are missing I tried checking ACL's and business rules 

[Ankur Bawiskar]

@sairamsouja 

seems some field level READ ACL on that field on which you are grouping is blocking the READ access.

Did you check that?

💡 If my response helped, please mark it as correct ✔️ and close the thread 🔒 — this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@sairamsouja 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✔️ and close the thread 🔒 — this helps future readers find the solution faster! 🙏

[nityabans27]

Hi @sairamsouja,

The message “Number of groups removed from this list by security constraints” appears when ServiceNow hides grouped results due to record-level ACLs or domain separation.

Main causes:

1. Read ACLs blocking access to some records.

2. Domain separation hiding data from other domains.

3. Before Query business rules modifying what records are returned.

4. Table.None ACLs with restrictive logic.

How to check:

• Enable Security Debug (/sys_security_acl_debug.do) to see which ACLs deny access.

• Try running the same list as admin — if results appear, it’s a security issue.

• Review Access Controls, Domain settings, and Business Rules for filters.

Fix: Adjust ACLs or domain visibility so users can access the missing records.