An advanced filter is ignored due to the spacing of parentheses in a custom filter condition.

Document ID : KB000007764
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When using Advanced Filtering, one or more of the filters is being ignored. There are no error messages, but unexpected values are included in the data set returned.

 

Below is an example of Advanced Filtering from a Custom List Application:

Custom _List.png

 

 

Resolution:

This issue can occur if you are using a custom filter condition along with advanced filtering, and have grouping parentheses. To fix this issue, make sure there are no spaces between the parentheses and the numbers.

For example, the following Custom Filter Condition is incorrect:

(3 OR 4 OR 5 )  AND  6

The space between the 5 and the right parentheses will cause the 6th filter to be ignored. The above example should look like this:

(3 OR 4 OR 5)  AND  6