Issue:
We are running Policy Server, this one reports an error when trying to find a user :
Error# '87' during search: 'error: Bad search filter' Search Query = 'TRANSLATE(FILTER(userRoles,'myrole*'),'myrole;','')=*'
Why do we have this error ? How can we fix this ?
Environment:
Policy Server R12.6
Cause:
The operators are usually used in Expressions. If you use the operator outside the Expression configuration field, you will see this error.
Resolution:
In the Response configuration, instead of using the "User Attribute" as Attribute Kind, use the "Expression" to apply the filter and then use the Operator.
KB : TEC1845165