Create filter if field value is None OR a specific value

Tuesday, June 26, 2018



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 ?


Thanks ! 


Note: I'm using SpiraTeam

1 Replies
Monday, July 2, 2018
re: smoldla Tuesday, June 26, 2018


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 -



Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Tuesday, June 26, 2018
  • Last Reply: Monday, July 2, 2018
  • Replies: 1
  • Views: 1464