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!

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