Inflectra Customer Forums: List of latest test runs per test case (Thread) Hi folks I would like the have a table with the latest test runs for each test case. Can someone help me with a ESQL query? 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/reports/2591.aspxthreadId=2591Pierre Legér (matthias.zurbruegg@gilgends.com)List of latest test runs per test case Hi folks I would like the have a table with the latest test runs for each test case. Can someone help me with a ESQL query? Fri, 25 Mar 2022 07:20:53 -04002025-08-06T13:00:32-04:00/Support/Forum/spirateam/reports/2591.aspxmessageId=5626David J (adam.sandman+support@inflectra.com) Hi Pierre If you want all the test runs, with test case and execution date, something like: sele Hi Pierre If you want all the test runs, with test case and execution date, something like: select TR.TEST_CASE_ID, TR.NAME as TEST_CASE_NAME, TR.RELEASE_ID, TR.RELEASE_VERSION_NUMBER, TR.EXECUTION_STATUS_NAME, TR.TESTER_NAME, TR.END_DATE from SpiraTestEntities.R_TestRuns as TR where TR.PROJECT_ID = ${ProjectId} and TR.EXECUTION_STATUS_ID 3 order by TR.END_DATE desc If you want it grouped by test case, then something like: select TR.TEST_CASE_ID, TR.NAME as TEST_CASE_NAME, TR.RELEASE_ID, TR.RELEASE_VERSION_NUMBER, TR.EXECUTION_STATUS_NAME, TR.TESTER_NAME, TR.END_DATE from SpiraTestEntities.R_TestRuns as TR inner join (select TR.TEST_CASE_ID, max(TR.END_DATE) as LAST_EXECUTION from SpiraTestEntities.R_TestRuns as TR where TR.PROJECT_ID = ${ProjectId} and TR.EXECUTION_STATUS_ID 3 group by TR.TEST_CASE_ID) as GR on TR.TEST_CASE_ID = GR.TEST_CASE_ID and TR.END_DATE = GR.LAST_EXECUTION where TR.PROJECT_ID = ${ProjectId} and TR.EXECUTION_STATUS_ID 3 order by TR.END_DATE desc Regards David Sun, 27 Mar 2022 12:49:00 -04002022-03-27T12:49:00-04:00/Support/Forum/spirateam/reports/2591.aspx#reply5626messageId=5627Pierre Legér (matthias.zurbruegg@gilgends.com) Hi David Thank you for your reply. It seems that your second example does exactly what i need. Fo Hi David Thank you for your reply. It seems that your second example does exactly what i need. For my understanding: What is the meaning of TR.EXECUTION_STATUS_ID 3 Wed, 30 Mar 2022 10:49:06 -04002022-03-30T10:49:06-04:00/Support/Forum/spirateam/reports/2591.aspx#reply5627messageId=7350Victoria D (nino.diasamidze@inflectra.com) Hello, This condition filters the test runs that have a status, since TR.EXECUTION_STATUS_ID = 3 w Hello, This condition filters the test runs that have a status, since TR.EXECUTION_STATUS_ID = 3 will pull items that have status NOT RUN. Basically saying, TR.EXECUTION_STATUS_ID 3 filters all test runs that have an execution status other than NOT RUN ( means not equal to ). Regards, Victoria - Wed, 06 Aug 2025 13:00:32 -04002025-08-25T13:19:17-04:00/Support/Forum/spirateam/reports/2591.aspx#reply7350