Notifications

282 views

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

Article Information

Last Updated:2018-08-03 02:04:21
Published:2018-07-18