User unable to see the Closed completed RITM

[Daemon1]

For one of the user, the closed completed ritm are not visible.
He can see the closed incomplete one but somehow not the closed completed one.

If we try to impersonate I see the message 'Record not found'

Anybody has faced this issue before? Were you able to find any solution?

[J Siva]

Hi @Daemon1 
Are you able to see the record with admin access?
If yes, then please check the read ACL on the sc_req_item table.
Regards,
Siva

[Daemon1]

Hi @J Siva 
Yes I checked the ACL but that is not the issue as all the roles are available to the user.(He is itil user).
Nevertheless if there was ACL issue it should have shown no of rows hide due to security constraint message if I am not wrong.

[J Siva · Accepted solution]

@Daemon1 Verify whether a query business rule has been created and is preventing users from accessing the record.

[Daemon1]

An addActiveQuery in the query BR was causing the issue.