Querying History of Test Case Automation Engine

Thursday, February 11, 2021
Avatar

Hi,

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
Statistics
  • Started: Thursday, February 11, 2021
  • Last Reply: Thursday, February 11, 2021
  • Replies: 0
  • Views: 175