Inflectra Customer Forums: Custom report biased on variable (Thread) Hi I would like to create a new custom report (not based on the standard reports) per release. How can I pass the release number as a variable to the query? This is my query: select R.TEST_CASE_ID, R.RELEASE_VERSION_NUMBER, R.TEST_SET_NAME, R.NAME, C.TEST_CASE_PRIORITY_NAME, R.EXECUTION_STATUS_NAME from SpiraTestEntities.R_TestRuns as R inner join (select max (TR.TEST_RUN_ID) as LAST_TEST_RUN_ID from ( SpiraTestEntities.R_TestRuns) as TR where TR.PROJECT_ID = ${ProjectId} and TR.RELEASE_VERSION_NUMBER = "5.0-PR2" GROUP BY TR.TEST_SET_TEST_CASE_ID) as T on R.TEST_RUN_ID = T.LAST_TEST_RUN_ID inner join SpiraTestEntities.R_TestCases as C on R.TEST_CASE_ID = C.TEST_CASE_ID ORDER BY C.TEST_CASE_PRIORITY_NAME, R.EXECUTION_STATUS_NAME, R.TEST_SET_NAME And I want to replace the release version number "5.0-PR2" by a variable, so the user can create the report by the relevant release. Thanks, Taha Massalha. 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/spiratest/issues-questions/1010.aspxthreadId=1010taha massalha (taha@annapurnalabs.com)Custom report biased on variable Hi I would like to create a new custom report (not based on the standard reports) per release. How can I pass the release number as a variable to the query? This is my query: select R.TEST_CASE_ID, R.RELEASE_VERSION_NUMBER, R.TEST_SET_NAME, R.NAME, C.TEST_CASE_PRIORITY_NAME, R.EXECUTION_STATUS_NAME from SpiraTestEntities.R_TestRuns as R inner join (select max (TR.TEST_RUN_ID) as LAST_TEST_RUN_ID from ( SpiraTestEntities.R_TestRuns) as TR where TR.PROJECT_ID = ${ProjectId} and TR.RELEASE_VERSION_NUMBER = "5.0-PR2" GROUP BY TR.TEST_SET_TEST_CASE_ID) as T on R.TEST_RUN_ID = T.LAST_TEST_RUN_ID inner join SpiraTestEntities.R_TestCases as C on R.TEST_CASE_ID = C.TEST_CASE_ID ORDER BY C.TEST_CASE_PRIORITY_NAME, R.EXECUTION_STATUS_NAME, R.TEST_SET_NAME And I want to replace the release version number "5.0-PR2" by a variable, so the user can create the report by the relevant release. Thanks, Taha Massalha. Sat, 20 Sep 2014 17:39:15 -04002014-09-22T15:57:16-04:00/Support/Forum/spiratest/issues-questions/1010.aspxmessageId=1842Jim R (donotreply5@kronodesk.net) Hi Taha Currently only ProjectId and ProjectGroupId are available as variables. We have an open e Hi Taha Currently only ProjectId and ProjectGroupId are available as variables. We have an open enhancement to pass through additional variables to a custom report, but for now you'd need to hard-code the release in the report definition. Regards Jim Mon, 22 Sep 2014 15:57:16 -04002014-09-22T15:57:16-04:00/Support/Forum/spiratest/issues-questions/1010.aspx#reply1842