User not able to see records with a specific filter in cmdb_ci_table

sd2097 · ‎01-09-2025

Hi all,

I am facing an issue where a user is able to view records in the cmdb_ci_service table, but not able to view records with a specific filter.

Example - We have a field called as Min_serv and I am putting a filter Min_serv is not empty, and the user is NOT able to see those records. When I open any record with that filter as Admin, impersonate with that user, refresh the page again, it says 'Record Not Found'.

According to me it is not an ACL issue. Can someone please help in identifying the root cause?

Thanks

sd2097 · ‎01-20-2025

Hi all,

So it was later found that the Users were part of certain groups in Production which they were not members of in UAT and Dev. And a query BR was restricting access to members of those groups.

I modified the query BR accordingly and now it is working as expected.

Thanks everyone for your responses. I am marking this as the solution so it helps other folks as well.

Thanks,

Sudhangshu

View solution in original post

Ankur Bawiskar · ‎01-09-2025

@sd2097

did you check any Query BR is running on that table or it's parent table which is blocking?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

sd2097 · ‎01-09-2025

Hi @Ankur Bawiskar ,

Thanks for your response. Yes I did check it. There are two query BRs. But, the same query BRs are running on UAT and Dev env, and there the user is able to view the records. Also, I tried deactivating one of them, but the user is still not able to view it. Look forward to your response.

Thanks

Ankur Bawiskar · ‎01-09-2025

@sd2097

seems issue with query BR.

Try checking field level READ ACL on that field

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

PritamG · ‎01-09-2025

The issue is likely related to data ownership, access restrictions, or a query condition that limits visibility. Check if Row-level security (security constraints) or Domain separation is affecting the user's access to specific records. Ensure that the user has the appropriate roles and access to the fields used in the filter. If not ACL-related, verify table-level permissions and condition-based filters.