Why addQuery() method in Business Rule constructs incorrect query? - Support and Troubleshooting

Why addQuery() method in Business Rule constructs incorrect query? Description  Symptoms "Before query Business Rule" on a "task" record suppose to filter the data based on the AddQuery() method and parameters supplied in "script" section of the business rule.

However, the AddQuery() method was constructing an incorrect query and hence expected results were not returned while viewing the task record / list.

Below screenshot shows this incorrect query constructed by the before query business rule,

Another symptoms is, at times, the query also can be reversed, for example, when you expect query to have "LIKE", it might have "NOT LIKE" operator.

Release Any supported release.

Cause In the script section of before query business rule, an additional space was suffixed with the operator on the addQuery() method as shown in the below screenshot.

Resolution Remove any space prefixed/suffixed from the operators in addQuery() method.

Additional Information Business rules

GlideRecord query

Available operators