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

Custom report biased on variable

Saturday, September 20, 2014

reporting

taha

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

~~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: 2677

Custom report biased on variable

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results