Custom report biased on variable

Saturday, September 20, 2014 5:39:15 PM
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.
1 Replies
Monday, September 22, 2014 3:57:16 PM
Avatar
re: taha on Saturday, September 20, 2014 5:39:15 PM
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
Statistics
  • Started: Saturday, September 20, 2014 5:39:15 PM
  • Last Reply: Monday, September 22, 2014 3:57:16 PM
  • Replies: 1
  • Views: 509