ITIL guys can't perfrom Contains operation on one particular field on group table

[Dileep Kumar2]

There is some strange behavior happening. We do have field called queue managers which is a list field present in group table.
Now ITIL users can able to see this field and can do operations like this field is empty , non empty.

But they can't do contains operation. I guess it might be some ACL.

I tried creating ACL on that group table and tried with every operation. They can't do that queue manager contains some value.

This is the query "group.queue_managersLIKE34c44ab61bd2ccd8c6a3ff72cd4bcb02" which works for admin and not for ITIL users.

Need help on this.

[Ankur Bawiskar · Accepted solution]

@Dileep Kumar2 

try creating query_range ACL on that field and add snc_internal role and then see

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

[Dileep Kumar2]

I have one more doubt I have created the same ACL earlier, but only thing I did was I used ITIL role, It didn't work.
Now after adding snc_internal its working how is that possible?

[Ankur Bawiskar]

@Dileep Kumar2 

that I am not very sure, usually whenever I faced such query_range ACL issue for filter not getting applied, I have given snc_internal

You will have to debug that

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

[Dileep Kumar2]

What I have observed is there is one deny rule which only allows authentiacted roles.
We dont have explicit roles related plugin installed.

So even after I add ITIL it wont take into consideration as explicit roles only have snc_internal and snc_external role.

Just guesiing this might be the issue.