Inflectra Customer Forums: Create filter if field value is None OR a specific value (Thread)

Inflectra Customer Forums: Create filter if field value is None OR a specific value (Thread) Hello, Im 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: Im using SpiraTeam 5.2.0.2 en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/1870.aspxthreadId=1870Laurent Smolders (laurent.smolders@generali.be)Create filter if field value is None OR a specific value Hello, Im 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: Im using SpiraTeam 5.2.0.2 Tue, 26 Jun 2018 10:08:00 -04002018-07-02T19:40:52-04:00/Support/Forum/spirateam/issues-questions/1870.aspxmessageId=3323Jim R (donotreply5@kronodesk.net) Hi In the SpiraTeam UI you can only filter by (None) or set of values, but not both at the same ti Hi 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 Regards Jim Mon, 02 Jul 2018 19:40:52 -04002018-07-02T19:40:52-04:00/Support/Forum/spirateam/issues-questions/1870.aspx#reply3323