Lookup using list

[Yajna Yadla]

Hi Team,

I am facing the issue with Lookup using list. When I click on reference field's search ICON.

We got one error (Part of the query on sys_user has been ignored because of insufficient access for 'query_match' operation on sys_user.u_hr_user) like below.

We faced this in everywhere. could you please let us know why this is happening and what was the solution.

This very urgent. Please respond on this ASAP.

Kind regards,

Yajna Yadla

[Mark Manders]

What is the reference qualifier on this field? Does it contain any condition looking for those u_hr_user fields? If so, you will need to update the ACL's so the user using this field is able to read the fields. The conditions need to be evaluated as user. If the user isn't allowed to see the data, it will return nothing.

You can use the security debugger to see which ACL's are blocking.