Problem of ACL

[aymane]

Hello,

Please could you help me with this problem, on the table sc_req_item

I have this query filter : company.nameLIKElafa^sys_created_onBETWEENjavascript:gs.dateGenerate('2025-12-01','00:00:00')@javascript:gs.dateGenerate('2026-01-13','23:59:59')^cat_item.price>javascript:global.getCurrencyFilter('sc_cat_item','price', 'EUR;0'). 

However, i have a error message : Part of the query on sc_req_item has been ignored because of insufficient access for 'query_range' operation on sc_req_item.cat_item.price

I have verified my ACLs but I didn't figure out how to fixe it. Could you help me please ?

[aymane]

When I check the role : sc_cat_item.price 

I found that on requires role, it contains the role of the user that face the problem

[aymane]

I already have the ACLs : sc_cat_item.price (query_range) and i have already created : sc_req_item.cat_item.price (query_range)

But ... its not working