Querying History of Test Case Automation Engine

Thursday, February 11, 2021


I'm 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 I'd like to generate a count of cases that have had their AUTOMATION_ENGINE_NAME set, per day.

0 Replies

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Thursday, February 11, 2021
  • Last Reply: Thursday, February 11, 2021
  • Replies: 0
  • Views: 800