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

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

 

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