Policy Server reports "Bad search filter" error when the operator TRANSLATE is in use in a Response

Document ID : KB000008782
Last Modified Date : 14/02/2018
Show Technical Document Details

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 ?


Policy Server R12.6

The operators are usually used in Expressions. If you use the operator outside the Expression configuration field, you will see this error.


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.