Im trying to tell if there is a way in a custom report to determine if a Test Case has been changed since a particular point in time. The Last Modified field doesnt help me as that seems to update anytime someone as much as drops the case into a test set, Im more interested in changes to the description or test steps. The idea is to tell if R&D ran Test A on Date1, but the case was subsequently updated on Date2, has R&D run the updated case? We are using SpiraTeam (6.15.0.0) with a stupid amount of data because of historical import reasons. 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/2583.aspxthreadId=2583Brad Straka (bstraka@stayinfront.com) Im trying to tell if there is a way in a custom report to determine if a Test Case has been changed since a particular point in time. The Last Modified field doesnt help me as that seems to update anytime someone as much as drops the case into a test set, Im more interested in changes to the description or test steps. The idea is to tell if R&D ran Test A on Date1, but the case was subsequently updated on Date2, has R&D run the updated case? We are using SpiraTeam (6.15.0.0) with a stupid amount of data because of historical import reasons. Wed, 02 Mar 2022 00:54:08 -05002022-10-03T17:40:07-04:00/Support/Forum/spirateam/issues-questions/2583.aspxmessageId=4281Ilia Poliakov (ilya.polyakov@edetek.com) Have o look at this table, it might help you: Available Database Tables - SpiraDocs (inflectra.com) Wed, 02 Mar 2022 15:07:56 -05002022-03-02T15:07:56-05:00/Support/Forum/spirateam/issues-questions/2583.aspx#reply4281messageId=4282David J (adam.sandman+support@inflectra.com) Thanks Ilya, The following query will pull the list of test case change entries in date descending: select value R from SpiraTestEntities.R_HistoryChangeSets as R where R.PROJECT_ID = ${ProjectId} and R.ARTIFACT_TYPE_ID = 2 order by R.CHANGE_DATE desc Regards David Wed, 02 Mar 2022 15:39:27 -05002022-03-02T15:39:27-05:00/Support/Forum/spirateam/issues-questions/2583.aspx#reply4282messageId=5634Brad Straka (bstraka@stayinfront.com) Thanks both of you - that helped me focus my tinkering in the right area. I settled on this to extract a value i could include in my trace report. ANYELEMENT(Select value Max(R.Change_Date) from SpiraTestEntities.R_HistoryDetails as R where R.Artifact_ID=TSTC.Test_Case_ID and R.New_Value=Approved) as Last_Approval It seems to get me what Im looking for in a timely fashion - now off to figure out how to do date comparisons in XSL 1.0... Thu, 07 Apr 2022 02:29:30 -04002022-04-07T02:29:30-04:00/Support/Forum/spirateam/issues-questions/2583.aspx#reply5634messageId=5635Ilia Poliakov (ilya.polyakov@edetek.com) My advice: try to use JavaScript inside XSLT, it helps my reports a lot. As for me, XSLT is very difficult to find developers and to debug. Fri, 08 Apr 2022 06:35:39 -04002022-04-08T06:35:39-04:00/Support/Forum/spirateam/issues-questions/2583.aspx#reply5635messageId=5636Ilia Poliakov (ilya.polyakov@edetek.com) Example how to use JS inside XSLT releases=[]; releases.push({ id:xsltToNumber(' '), is_summary:xsltToBoolean(' '), name:xsltToString(' '), resource_count:xsltToNumber(' '), uihd:xsltToNumber(' '), apihd:xsltToNumber(' '), }); Fri, 08 Apr 2022 09:03:34 -04002022-04-08T09:03:34-04:00/Support/Forum/spirateam/issues-questions/2583.aspx#reply5636