User can see count in report but not the underlying records (has all roles)

[SivaprasadV]

I want to post in the community that even though the user has all the required roles, they are still unable to view the records. I created a count report, and when I impersonate the user, I can see the count. However, when the user clicks on it, they cannot see the actual records. I’ve also attached the screenshot for reference. When I remove the filter condition. I can able to see the record.

Filter condition : State - Review and Reviewer is dynamic Me.

[AndersBGS]

Hi @SivaprasadV ,

You need to look at the query_range acl for that specific table - this is the reason that the user doesn't see aby underlaying data.

[Tanushree Maiti]

If You are getting, this kind of error on specific table,

On that table ,create a query range ACL ( refer below given screen shot) , it will fix the issue.

[Ankur Bawiskar]

@SivaprasadV 

try creating separate query_range ACLs for those fields (ART Reviewer & State) for your table and add snc_internal role

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