Thread

Skip Navigation LinksForums > SpiraTest Forums > SpiraTest Issues & Questi... > Custom report biased on v...

Custom report biased on variable RSS Feed

Saturday, September 20, 2014
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
Jim R.Jim R.
re: taha massalha on Saturday, September 20, 2014
Monday, September 22, 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
Tagged
Statistics
  • Started: 9/20/2014
  • Last Reply: 9/22/2014
  • Replies: 1
  • Views: 277
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.