Thread

Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Best Practices > Select all incidents if c...

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

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.

THANKS
OLIVER
1 Replies
Adam SAdam S
re: Oliver Dahms on Friday, August 23, 2013
Sunday, August 25, 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

Regards

Adam

Tagged
Statistics
  • Started: 8/23/2013
  • Last Reply: 8/25/2013
  • Replies: 1
  • Views: 1054
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.