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

inflectra.adam

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: 1317

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

Edit Thread

Edit Message

Search Results