Custom report biased on variable

Saturday, September 20, 2014
Avatar
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
Avatar
inflectra.jimx
re: taha Saturday, September 20, 2014
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

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: Saturday, September 20, 2014
  • Last Reply: Monday, September 22, 2014
  • Replies: 1
  • Views: 2563