Part of the query on sc_req_item has been ignored because of insufficient access for 'query_match' o

[Elvis7]

Hi,

 user can't access the record of Request Item. I got below error message. I dont find any acl with sys_scope. How can I solve it? thank

Part of the query on sc_req_item has been ignored because of insufficient access for 'query_match' operation on sc_cat_item.sys_scope

[Brian Lancaster]

Do you have a custom ACL on the sys_scope field on the sc_cat_item table? If so you need a query_match ACL on the same field.

[Elvis7]

I don't have custom ACL for that. Also I don't see sys_scope field when I tried to create a new query_match acl

[Brian Lancaster · Accepted solution]

If you only of out of the box ACLs on the sc_cat_item table I would put in a case with now support. I'm not sure why it would be doing a query_match error on sys_scope or why it is not selectable for you since i tis a field on the sc_cat_item table.

[Elvis7]

I found out previous developer use cat_item application as filter. I removed the filter and used different field as filter. user can read the data now. I don't see custom ACL. I think it has ACL for the application field for some reason, but when I tried to create a new ACL to replace it, I dont find this field in selection. Anyway the issue has been fixed.