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 tasks 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. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/2051.aspxthreadId=2051David Wimsett (david.wimsett@tescometermanager.com)databasehistorytask 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 tasks 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. Fri, 28 Jun 2019 18:43:13 -04002019-07-01T15:15:13-04:00/Support/Forum/spirateam/issues-questions/2051.aspxmessageId=3618David J (adam.sandman+support@inflectra.com) 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 Mon, 01 Jul 2019 15:15:13 -04002019-07-03T20:30:23-04:00/Support/Forum/spirateam/issues-questions/2051.aspx#reply3618