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