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
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.