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

book

Article ID: 7764

calendar_today

Updated On:

Products

CA OPS/MVS Event Management & Automation CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction

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:

<Please see attached file for image>

Custom _List.png

 

 

Environment

Release:
Component: ACSAAS

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

Attachments

1558700065637000007764_sktwi1f5rjvs16oxe.png get_app