Views:

Behavior:
Using a search query in a tool (Platform .NET API or REST API) runs into the following error:

"Wrong condition. Not parsed string..."
 

Solution:
The query contains special characters that are not escaped correctly.

Some special characters have to be escaped when using them (as they are) in a query.  These characters are ones that can be used as control characters in a query as well: (, ), *, \, "  

Examples: 
Value in Field: "Invoice (in)" - Query: "Invoice \(in\)" 
Value in Field: "*Test" - Query: "\*Test" 

Why does this only affect certain characters? 

  • When you use unescaped open brackets, it is searching for closing brackets in the query.
  • When you use unescaped * in a query, it is used as an indicator for wildcard search. 
  • When you use unescaped \ in a query, it is used as an indicator that the next character should be escaped. If there is no valid character, the query fails.

KBA is applicable to both Cloud and On-premise Organizations.