Gridlist Report - Report Filtering does not work when Search Conditions contain "OR"

ID:    D27737
Published:    07 January 2021
Updated:    21 January 2021

Defect Id


Originally Reported Against

SBM 11.8


If you create a gridlist report with search conditions containing an "or", the filtering does not work when you run the report. 

The reason is that if the filter is not inside parentheses, the final statement submitted is incorrect.
What happens is that the Search filter is simply appended as a string to the report filter. Thus, in the presence of "OR" in latter, the priority of the operations is unexpected.

As a workaround, we could recommend adding parentheses manually around the entire filter when creating a report.


Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs