Inflectra Customer Forums: Filtering Custom report by Release (Thread) 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 doesnt 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! en-US(C) Copyright 2006-2024 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2263.aspxthreadId=2263Alex Soloviev (alex.soloviev@celerion.com)custom report filter releaseFiltering Custom report by Release 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 doesnt 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! Mon, 07 Dec 2020 22:40:24 -05002020-12-08T16:53:05-05:00/Support/Forum/spirateam/reports/2263.aspxmessageId=3893David J (support1@inflectra.com) The problem is that if you have no release selected, it returns back -1 which wont match any releas The problem is that if you have no release selected, it returns back -1 which wont 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. Tue, 08 Dec 2020 02:31:34 -05002020-12-08T02:31:34-05:00/Support/Forum/spirateam/reports/2263.aspx#reply3893messageId=3894Alex Soloviev (alex.soloviev@celerion.com) Thank you David! Thank you David! Tue, 08 Dec 2020 16:53:05 -05002020-12-08T16:53:05-05:00/Support/Forum/spirateam/reports/2263.aspx#reply3894