Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Accessing TST_HISTORY_DET...
We are using SpiraTeam v18.104.22.168 and need to export the Actual Effort data from TST_HISTORY_DETAL in order to populate another application we are using for time tracking. Although we can see this data displayed in the History tab of a task’s detail, we are unable to see how that data is connected between the TST_TASK and TST_HISTORY_DETAL tables. We have tried to trace Project ID, Requirement, Task_ID, Artifact_History_ID ad Artifact_ID. Please help us to understand how we can extract this data.
The TST_HISTORY_DETAIL table joins to the TST_HISTORY_CHANGESET table
The TST_HISTORY_CHANGESET table has:
Then join the TST_HISTORY_DETAIL to TST_HISTORY_CHANGESET on: