Select all incidents if custom property "Tool ID" (Integer) is filled

Friday, August 23, 2013
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.

1 Replies
Monday, August 26, 2013
re: oliver.dahms Friday, August 23, 2013

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



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: Friday, August 23, 2013
  • Last Reply: Monday, August 26, 2013
  • Replies: 1
  • Views: 3407