<rss version="2.0" xmlns:a10="http://www.w3.org/2005/Atom"><channel><title>Inflectra Customer Forums: Querying History of Test Case Automation Engine (Thread)</title><description> Hi,  Im attempting to produce some reports to track our progress as we go about automating our test cases.  As part of this, I would like to retrieve the history of the AUTOMATION_ENGINE_NAME field of test cases.  However, changes to this do not appear to stored in SpiraTestEntities.R_HistoryDetails.  If I change that field then run the query below then there are no results listed when AUTOMATION_ENGINE_NAME is changed:  select value H from SpiraTestEntities.R_HistoryDetails as H order by H.CHANGE_DATE desc  Is there a recommended way to query changes to the AUTOMATION_ENGINE_NAME?   Ultimately Id like to generate a count of cases that have had their AUTOMATION_ENGINE_NAME set, per day. </description><language>en-US</language><copyright>(C) Copyright 2006-2026 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><a10:id>http://www.inflectra.com/kronodesk/forums/threads</a10:id><ttl>120</ttl><link>/Support/Forum/spirateam/reports/2353.aspx</link><item><guid isPermaLink="false">threadId=2353</guid><author>Matthew Blyde (mblyde@gme.net.au)</author><title>Querying History of Test Case Automation Engine</title><description> Hi,  Im attempting to produce some reports to track our progress as we go about automating our test cases.  As part of this, I would like to retrieve the history of the AUTOMATION_ENGINE_NAME field of test cases.  However, changes to this do not appear to stored in SpiraTestEntities.R_HistoryDetails.  If I change that field then run the query below then there are no results listed when AUTOMATION_ENGINE_NAME is changed:  select value H from SpiraTestEntities.R_HistoryDetails as H order by H.CHANGE_DATE desc  Is there a recommended way to query changes to the AUTOMATION_ENGINE_NAME?   Ultimately Id like to generate a count of cases that have had their AUTOMATION_ENGINE_NAME set, per day. </description><pubDate>Thu, 11 Feb 2021 04:52:50 -0500</pubDate><a10:updated>2021-02-11T04:52:50-05:00</a10:updated><link>/Support/Forum/spirateam/reports/2353.aspx</link></item></channel></rss>