Filter by a list of comma separated IDs Question

0
Hello,

is it possible to filter a Report by a list of comma separated ID's (ISSUEID)?
Righ now, I just can filter by the content of the ID, and that return only the Items that contain that string in its ID. For example, if I filter by '001015' the report would only show me the item with te ID '001015'; or I can filter by '00101*' and the report would bring all the items in the range 001010-001019. But how can I do if I want to see the items '001015', '0021340', '003451'?

It would be great if someone have worked on that kind of report.

Kind regards,
Sergio Rodriguez

Location [ View Larger Map ]

Responses (2)
  • Accepted Answer

    Wednesday, October 07 2015, 06:51 PM - #Permalink
    0
    I'm not sure exactly what your use case is, but adding multiple "Issue Id like " search criteria into your report and separate them with the OR clause (instead of AND) may meet your needs. Then when you run the report, you enter a different issue id into each one of the Query at Runtime fields and the report will show you all of the items specified. It seems to work even if you only fill in some of the Query at Runtime fields.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, October 10 2015, 10:12 PM - #Permalink
    0
    Using Advanced SQL for the search filter works for me:
    @Where ts_IssueId In ('001015', '002134', '003451')


    http://www.serenacentral.com/community/forums?controller=attachment&task=displayFile&tmpl=component&id=136
    --------------------------
    http://www.serenacentral.com/community/forums?controller=attachment&task=displayFile&tmpl=component&id=137
    The reply is currently minimized Show
Your Reply

Recent Tweets