Filtering Custom report by Release

Monday, December 7, 2020
Avatar

So there is a note underneath the SQL section of the Custom Section form that says:

"For report sections that can be filtered by release, use tokens ${ReleaseId} to filter by the specified release, or ${ReleaseAndChildIds} to filter by a comma-separated list of the release and child sprints/phases."

When I add an additional filter into my SQL:

"AND RQ.RELEASE_ID=${ReleaseId}"

Then it works correctly for the times when Release is selected. But when I select Release "---ALL---" value it doesn't work and no results are displayed.

What is passed to the query when Release='ALL' is selected and how should I account for the selection in my SQL?

Thank you!

2 Replies
Tuesday, December 8, 2020
Avatar
re: shurix Monday, December 7, 2020

The problem is that if you have no release selected, it returns back "-1" which won't match any release.

It is usually better to use:

AND RQ.RELEASE_ID IN {${ReleaseAndChildIds}}

that way it will return a comma-separated list of releases (and child sprints) if a release is selected, or all the releases, if '--all releases--' is selected.

Tuesday, December 8, 2020
Avatar
re: inflectra.david Monday, December 7, 2020

Thank you David!

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

 

Statistics
  • Started: Monday, December 7, 2020
  • Last Reply: Tuesday, December 8, 2020
  • Replies: 2
  • Views: 2536