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

Friday, August 23, 2013 11:57:21 AM
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
1 Replies
Monday, August 26, 2013 3:28:11 AM
Avatar
re: oliver.dahms on Friday, August 23, 2013 11:57:21 AM

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

Statistics
  • Started: Friday, August 23, 2013 11:57:21 AM
  • Last Reply: Monday, August 26, 2013 3:28:11 AM
  • Replies: 1
  • Views: 1279