Inflectra Customer Forums: How to add previous row to the next row (Thread) Hi everyone, Im working on a project in SpiraTest and need some help with ESQL. Specifically, I want to: Include the previous data in the next row to be added. Actual Result: Execution Date for Test Set Passed Test Case 15/04/2025 3 16/04/2025 1 Preffered Result: Execution Date for Test Set Passed Test Case 15/04/2025 3 16/04/2025 4 2. Add a new column that is based on the Planned_date field, incremented by 5 days for a specified number of times. Has anyone done something similar or can provide guidance on how to achieve this? Any examples or tips would be greatly appreciated! Thanks in advance! 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/3032.aspxthreadId=3032LANCE JEWEL JAVIER (lance.javier@metrobank.com.ph)SQL How to add previous row to the next row Hi everyone, Im working on a project in SpiraTest and need some help with ESQL. Specifically, I want to: Include the previous data in the next row to be added. Actual Result: Execution Date for Test Set Passed Test Case 15/04/2025 3 16/04/2025 1 Preffered Result: Execution Date for Test Set Passed Test Case 15/04/2025 3 16/04/2025 4 2. Add a new column that is based on the Planned_date field, incremented by 5 days for a specified number of times. Has anyone done something similar or can provide guidance on how to achieve this? Any examples or tips would be greatly appreciated! Thanks in advance! Wed, 30 Apr 2025 00:58:54 -04002025-08-06T16:00:36-04:00/Support/Forum/spirateam/issues-questions/3032.aspxmessageId=7213Victoria D (nino.diasamidze@inflectra.com) Hello, Can you please share the actual query that calculates the number of passed tests? Regar Hello, Can you please share the actual query that calculates the number of passed tests? Regards, Victoria - Wed, 30 Apr 2025 07:08:54 -04002025-04-30T07:08:54-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7213messageId=7214LANCE JEWEL JAVIER (lance.javier@metrobank.com.ph) Hi this is my created SQL with the Total Passed and Total Executed TCs SELECT Combined_Date, Hi this is my created SQL with the Total Passed and Total Executed TCs SELECT Combined_Date, SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = Passed THEN 1 ELSE 0 END) AS Total_Passed, SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = Passed THEN 1 ELSE 0 END) + SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = Failed THEN 1 ELSE 0 END) AS Total_Executed FROM SpiraTestEntities.R_TestRuns AS TR INNER JOIN SpiraTestEntities.R_TestCases AS TC ON TR.END_DATE = TC.EXECUTION_DATE WHERE TR.PROJECT_ID = ${ProjectId} GROUP BY TruncateTime(TR.END_DATE) AS Combined_Date Wed, 30 Apr 2025 07:56:39 -04002025-04-30T07:56:39-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7214messageId=7249Sophia Smith (sophiaclairesm@gmail.com) Hi, To add the value of the previous row to the current row (cumulative total), you can use the fu Hi, To add the value of the previous row to the current row (cumulative total), you can use the function to calculate the total running in order of execution date. As for creating an additional date column increasing by Planned_date every 5 days, you just need to repeat the operation of adding 5 days for each record. Thu, 15 May 2025 02:30:16 -04002025-05-30T07:26:54-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7249messageId=7250Johnnie Shaw (marshcalvin139@gmail.com) You can use the function to determine the total running in order of execution date by adding the va You can use the function to determine the total running in order of execution date by adding the value of the previous row to the current row (cumulative total). Fri, 16 May 2025 04:25:29 -04002025-05-30T07:27:02-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7250messageId=7334Victoria D (nino.diasamidze@inflectra.com) Hello, I think that you should use XSLT functionality for this, something like this: I woul Hello, I think that you should use XSLT functionality for this, something like this: I would recommend logging a support ticket if you need more assistance. Regards, Victoria - Thu, 24 Jul 2025 07:16:28 -04002025-07-24T07:16:28-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7334messageId=7351jae aer (james918001@gmail.com) To achieve a running total of passed test cases, you can use a window function like SUM(...) OVER ( To achieve a running total of passed test cases, you can use a window function like SUM(...) OVER (...) if your ESQL version supports it. Wed, 06 Aug 2025 16:00:36 -04002025-08-07T10:09:36-04:00/Support/Forum/spirateam/issues-questions/3032.aspx#reply7351