Inflectra Customer Forums: Select all incidents if custom property "Tool ID" (Integer) is filled (Thread) Dear all, my last question... I defined an own custom property so called "Tool ID". For some incidents we might have duplicates in an "other world", so we would like to enter a reference number there. Now I would like to get an overview for all incidents which have field "Tool ID" filled with any value - but not one specific value. A report would be fine, any other ideas as well. THANKS OLIVER 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/spiratest/best-practices/691.aspxthreadId=691Oliver Dahms (oliver.dahms@clearstream.com)Select all incidents if custom property "Tool ID" (Integer) is filled Dear all, my last question... I defined an own custom property so called "Tool ID". For some incidents we might have duplicates in an "other world", so we would like to enter a reference number there. Now I would like to get an overview for all incidents which have field "Tool ID" filled with any value - but not one specific value. A report would be fine, any other ideas as well. THANKS OLIVER Fri, 23 Aug 2013 11:57:21 -04002013-08-26T03:28:11-04:00/Support/Forum/spiratest/best-practices/691.aspxmessageId=1256David J (adam.sandman+support@inflectra.com) Hi Olivier There's not a filter that would cover this, however you could use a custom report Hi Olivier There's not a filter that would cover this, however you could use a custom report using a custom section and use Entity SQL that locates all values where that custom field is not null. Something like: select value R from SpiraTestEntities.R_Incidents where R.Custom_XX is not null Regards Adam Mon, 26 Aug 2013 03:28:11 -04002013-08-26T03:28:11-04:00/Support/Forum/spiratest/best-practices/691.aspx#reply1256