Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > Querying History of Test ...
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 Horder 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.