Accessing TST_HISTORY_DETAIL table for a task

Friday, June 28, 2019
Avatar

We are using SpiraTeam v4.2.0.1 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.

1 Replies
Monday, July 1, 2019
Avatar
re: TescoCanda Friday, June 28, 2019

Hi,

The TST_HISTORY_DETAIL table joins to the TST_HISTORY_CHANGESET table

The TST_HISTORY_CHANGESET table has:

  • ARTIFACT_ID => Maps to TST_TASK.TASK_ID
  • ARTIFACT_TYPE_ID => Maps to 6 for tasks

Then join the TST_HISTORY_DETAIL to TST_HISTORY_CHANGESET on:

  • CHANGESET_ID

Regards

David

Statistics
  • Started: Friday, June 28, 2019
  • Last Reply: Monday, July 1, 2019
  • Replies: 1
  • Views: 277