list of records not visible after filter

[SIVAMANIKR]

Hi Tea,

User 1 with admin role : logged in and opened Demand list view i can able to see all the demands 
user 2 with  out admin role : logged in and opened Demand list view i can able to see all the demands.

after i provided filter i m getting no records for that user(non admin user) . same filter admin can able to see the demands.

Admin View:

Non Admin View: 

List view for admin and non admin : all list display good 

[VaishnaviK3009]

Hi @SIVAMANIKR !!

This behavior occurs due to ACL enforcement on filtered fields.
Admin users can see records because they bypass ACLs, but non-admin users must have read access on the Demand table and the fields used in the filter (e.g., Planned Production Date).

When the list loads initially, records may appear due to default list behavior. However, once a filter is applied, ACLs are strictly evaluated, resulting in no records for non-admin users.

What to check:

• Read ACLs on the demand table

• Field-level ACLs for filtered fields

• Any Before Query Business Rules or domain restrictions

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for.

Thank You

[SIVAMANIKR]

Hi @VaishnaviK3009 ,

i have check all the ACL in the demand table no acl present in that filed. and this field is custom field.

[VaishnaviK3009]

Thanks for checking. Even if there is no explicit ACL on the custom field, this behavior can still occur due to table-level ACLs, inherited ACLs, or Before Query Business Rules on the Demand table.
Admins bypass these checks, while non-admin users do not. Please also verify:

• Read ACL on the Demand table (record ACL)

• Any Before Query or Query Business Rules filtering records for non-admin users

• Domain separation / data policies (if enabled)

• Roles or conditions applied indirectly via related tables

This is expected behavior when filters force ACL evaluation for non-admin users.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for.

Thank You

[GlideFather]

Hi @SIVAMANIKR,

it seems that the two screenshots you provided differ in conditions.. the first one misses "Task type = Demand", if you apply that condition, does it display any records?

1st screenshot: PPD on 12.12.2025

2nd screenshot: PPD on 12.12.2025 + Task Type = Demand

Try to unify the filter conditions - both have the PPD just and only or both to have PPD + TT..

Let me know if that helped..