Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Create filter if field va...
I'm trying to display a list of requirements filtered on a custom property I created. The filter correctly lists the possible values, but now I would like to filter the items for which the value in this column is either not set either a specific value. So for example if possible values of myCustomType are "Option1", "Option2" and "Option3" (and obviously, empty string or null, not sure how this is implemented), I would like to display a list of requirements having the value "Option3" or no value, filtering out the ones with value Option1 or Option2. How can this be achieved ?
Note: I'm using SpiraTeam 220.127.116.11
In the SpiraTeam UI you can only filter by (None) or set of values, but not both at the same time.
You could use the custom reporting query language (ESQL) to create a custom report to find the items - https://www.inflectra.com/Ideas/Entry/317.aspx