Hello, My company would like me to create a sum of the test steps that have passed, failed, blocked, etc. instead of test cases. I tried to do my own SQL query - and it works when I access the database by the SQLCMD utility, but not in the Spira query under the custom reports. Here it is - maybe someone will know what's going on? SELECT SUM(CASE WHEN execution_status_id=2 then 1 else 0 end) as Pass FROM TST_TEST_STEP (<----From SQLCMD Utility - when I do it from the query I replace TST_TEST_STEP with SpiraEntities.R_TestSteps) It is creating a sum correctly in the back door, but when I try and execute this in Spira I get ther error: execution_status_id could not be resolved in current scope or context. Any help would be appreciated. Thanks, Erin en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/952.aspxthreadId=952Erin Welch (erin.welch@siemens.com)database Hello, My company would like me to create a sum of the test steps that have passed, failed, blocked, etc. instead of test cases. I tried to do my own SQL query - and it works when I access the database by the SQLCMD utility, but not in the Spira query under the custom reports. Here it is - maybe someone will know what's going on? SELECT SUM(CASE WHEN execution_status_id=2 then 1 else 0 end) as Pass FROM TST_TEST_STEP (<----From SQLCMD Utility - when I do it from the query I replace TST_TEST_STEP with SpiraEntities.R_TestSteps) It is creating a sum correctly in the back door, but when I try and execute this in Spira I get ther error: execution_status_id could not be resolved in current scope or context. Any help would be appreciated. Thanks, Erin Fri, 11 Jul 2014 16:13:03 -04002014-07-11T16:27:22-04:00/Support/Forum/spirateam/issues-questions/952.aspxmessageId=1732Erin Welch (erin.welch@siemens.com) Seems to work when I make the table as R. This finally generated correctly: SELECT SUM(CASE WHEN R.EXECUTION_STATUS_ID=2 THEN 1 ELSE 0 END) AS PASSED, SUM(CASE WHEN R.EXECUTION_STATUS_ID=1 THEN 1 ELSE 0 END) as FAILED, SUM(CASE WHEN R.EXECUTION_STATUS_ID=6 THEN 1 ELSE 0 END) as CAUTION, SUM(CASE WHEN R.EXECUTION_STATUS_ID=5 THEN 1 ELSE 0 END) as BLOCKED, SUM(CASE WHEN R.EXECUTION_STATUS_ID=3 THEN 1 ELSE 0 END) as NOTRUN from SpiraTestEntities.R_TestSteps as R where R.PROJECT_ID = ${ProjectId} Thank you! Erin Fri, 11 Jul 2014 16:27:22 -04002014-07-11T16:27:22-04:00/Support/Forum/spirateam/issues-questions/952.aspx#reply1732