This is an automated email from the ASF dual-hosted git repository.

zhangliang2022 pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git


The following commit(s) were added to refs/heads/main by this push:
     new 1bf461c7 Feat tapd bug story std status done (#3349)
1bf461c7 is described below

commit 1bf461c77d2810f2759568573522495c61ab925f
Author: Warren Chen <[email protected]>
AuthorDate: Sun Oct 9 20:40:56 2022 +0800

    Feat tapd bug story std status done (#3349)
    
    * feat(tapd): modify story and bug
    
    * feat(tapd): modify std status for DONE
    
    relate to #3208
    
    * feat(tapd): rebase to main
---
 plugins/helper/api_extractor.go                    |  2 +-
 plugins/tapd/e2e/bugs_test.go                      |  3 ++
 .../e2e/raw_tables/_raw_tapd_api_bug_status.csv    | 11 +-----
 .../_raw_tapd_api_bug_status_last_steps.csv        |  2 ++
 plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv |  4 +--
 .../tapd/e2e/raw_tables/_raw_tapd_api_stories.csv  | 40 ++++++++++-----------
 .../e2e/raw_tables/_raw_tapd_api_story_status.csv  | 11 +-----
 .../_raw_tapd_api_story_status_last_steps.csv      |  2 ++
 .../snapshot_tables/_tool_tapd_bug_labels_bug.csv  |  1 +
 .../snapshot_tables/_tool_tapd_bug_statuses.csv    | 42 +++++++++++-----------
 .../tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv   | 20 -----------
 .../_tool_tapd_iteration_stories.csv               | 24 ++++++-------
 .../e2e/snapshot_tables/_tool_tapd_stories.csv     | 40 ++++++++++-----------
 .../snapshot_tables/_tool_tapd_story_statuses.csv  | 42 +++++++++++-----------
 .../_tool_tapd_workspace_stories.csv               | 40 ++++++++++-----------
 .../e2e/snapshot_tables/board_issues_story.csv     | 40 ++++++++++-----------
 plugins/tapd/e2e/snapshot_tables/issues_story.csv  | 40 ++++++++++-----------
 .../e2e/snapshot_tables/sprint_issues_story.csv    | 42 +++++++++++-----------
 plugins/tapd/e2e/stories_test.go                   |  4 ++-
 plugins/tapd/e2e/story_and_bug_status_test.go      |  2 ++
 plugins/tapd/tasks/bug_extractor.go                |  6 ++--
 plugins/tapd/tasks/shared.go                       | 11 ------
 plugins/tapd/tasks/story_extractor.go              | 15 +++++++-
 plugins/tapd/tasks/story_status_extractor.go       |  2 +-
 24 files changed, 212 insertions(+), 234 deletions(-)

diff --git a/plugins/helper/api_extractor.go b/plugins/helper/api_extractor.go
index 1ca40150..dae6ae49 100644
--- a/plugins/helper/api_extractor.go
+++ b/plugins/helper/api_extractor.go
@@ -117,7 +117,7 @@ func (extractor *ApiExtractor) Execute() errors.Error {
                        }
                        // set raw data origin field
                        origin := 
reflect.ValueOf(result).Elem().FieldByName(RAW_DATA_ORIGIN)
-                       if origin.IsValid() {
+                       if origin.IsValid() && origin.IsZero() {
                                origin.Set(reflect.ValueOf(common.RawDataOrigin{
                                        RawDataTable:  extractor.table,
                                        RawDataId:     row.ID,
diff --git a/plugins/tapd/e2e/bugs_test.go b/plugins/tapd/e2e/bugs_test.go
index 8336bc68..934e3a9e 100644
--- a/plugins/tapd/e2e/bugs_test.go
+++ b/plugins/tapd/e2e/bugs_test.go
@@ -45,10 +45,13 @@ func TestTapdBugDataFlow(t *testing.T) {
        // import raw data table
        
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_bug_status.csv",
                "_raw_tapd_api_bug_status")
+       
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_bug_status_last_steps.csv",
+               "_raw_tapd_api_bug_status_last_steps")
 
        // verify extraction
        dataflowTester.FlushTabler(&models.TapdBugStatus{})
        dataflowTester.Subtask(tasks.ExtractBugStatusMeta, taskData)
+       dataflowTester.Subtask(tasks.EnrichBugStatusLastStepMeta, taskData)
        dataflowTester.VerifyTable(
                models.TapdBugStatus{},
                "./snapshot_tables/_tool_tapd_bug_statuses.csv",
diff --git a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status.csv
index 858c9d90..ee36687c 100644
--- a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status.csv
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status.csv
@@ -1,11 +1,2 @@
 id,params,data,url,input,created_at
-11,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-12,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-13,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-14,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-15,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-16,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-17,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-18,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-19,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-20,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
+11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""开发中"",""resolved"":""已解决"",""rejected"":""已拒绝"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8"":""test111test111test111"",""status_9"":""test111test11
 [...]
diff --git 
a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status_last_steps.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status_last_steps.csv
new file mode 100644
index 00000000..24bb5acb
--- /dev/null
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bug_status_last_steps.csv
@@ -0,0 +1,2 @@
+id,params,data,url,input,created_at
+11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""status"":1,""data"":{""resolved"":""已解决"",""rejected"":""已拒绝""},""info"":""success""}",https://api.tapd.cn/workflows/status_map?system=bug&workspace_id=991,null,2022-06-21
 13:06:31.335
diff --git a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
index 5911074e..1569f1ee 100644
--- a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
@@ -1,7 +1,7 @@
 id,params,data,url,input,created_at
 
1271,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001025"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-
 [...]
-1272,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001030"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1273,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001031"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
+1272,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001030"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
+1273,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001031"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
 
1274,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001032"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
 
1275,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001417"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11-test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test
 [...]
 
1276,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001418"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11-test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-
 [...]
diff --git a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_stories.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_stories.csv
index e9f4147c..a0c48e5a 100644
--- a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_stories.csv
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_stories.csv
@@ -1,21 +1,21 @@
 id,params,data,url,input,created_at
-1,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037563"",""secret_root_id"":""0"",""sort"":""103756300000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\""
 [...]
-2,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037696"",""secret_root_id"":""0"",""sort"":""101474300000"",""workitem_type_id"":""11991001000269"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-08-31
 15:24:19"",""modified"":""2021-09-03 16:13:49"",""pare [...]
-3,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037697"",""secret_root_id"":""0"",""sort"":""103769700000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""tes [...]
-4,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038322"",""secret_root_id"":""0"",""sort"":""101474400000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-07
 16:07:25"",""modified"":""2021-10-15 
18:51:24"",""parent_id"":""0"",""children_id"":""||119910 [...]
-5,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038323"",""secret_root_id"":""0"",""sort"":""103832300000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\ 
[...]
-6,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038697"",""secret_root_id"":""0"",""sort"":""103562900000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11tes [...]
-7,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038911"",""secret_root_id"":""0"",""sort"":""101474500000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11"",""description"":null,""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-13
 18:28:23"",""modified"":""2022-03-26 
16:56:07"",""parent_id"":""0"",""children_id"":""||1199100103891 [...]
-8,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038912"",""secret_root_id"":""0"",""sort"":""103891200000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\""
 [...]
-9,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001039664"",""secret_root_id"":""0"",""sort"":""101474600000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-24
 15:46:47"",""modified"":""2021- [...]
-10,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001039673"",""secret_root_id"":""0"",""sort"":""103967300000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font [...]
-11,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001040086"",""secret_root_id"":""0"",""sort"":""101474700000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-29
 14:52:01"",""modified"":""2021-10-18 
13:46:59"",""parent_id"":""0"",""children_ [...]
-12,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001040088"",""secret_root_id"":""0"",""sort"":""104008800000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><p><\/p><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\ [...]
-13,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041163"",""secret_root_id"":""0"",""sort"":""101474800000"",""workitem_type_id"":""11991001000269"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-10-19
 15:58:33"",""modified"":""2021-10-21 09:30:53"",""parent_id"":""0"" [...]
-14,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041164"",""secret_root_id"":""0"",""sort"":""104116400000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test [...]
-15,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041165"",""secret_root_id"":""0"",""sort"":""101474900000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09"",""description"":""<div><p>testUnicode672ctestUnicode671ftestUnicode9700testUnicode8981testUnicode6539testUnicode9020testUnicode7684testUnicode9875testUnicode9762testUnicode6709<\/p><p>1test
 [...]
-16,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041166"",""secret_root_id"":""0"",""sort"":""104116600000"",""workitem_type_id"":""11991001000026"",""name"":""PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face [...]
-17,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041788"",""secret_root_id"":""0"",""sort"":""101475000000"",""workitem_type_id"":""11991001000269"",""name"":""testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""testUnicode6768testUnicode4e39"",""crea
 [...]
-18,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041789"",""secret_root_id"":""0"",""sort"":""104178900000"",""workitem_type_id"":""11991001000026"",""name"":""testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{fo [...]
-19,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041899"",""secret_root_id"":""0"",""sort"":""101475100000"",""workitem_type_id"":""11991001000269"",""name"":""2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""testUnicode5218testUnicode5b87testUnicode6615"",""created"":""2021-10-28
 10:56:01"",""modified"":""2021-12-20 09:5 [...]
-20,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041900"",""secret_root_id"":""0"",""sort"":""104190000000"",""workitem_type_id"":""11991001000026"",""name"":""testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d"",""description"":""<div><div><div><div><div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><\/div><\/div><\/div><\/div><style>@font-face{font-family:\""Times
 New Roman\" [...]
+1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037563"",""secret_root_id"":""0"",""sort"":""103756300000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\""C
 [...]
+2,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037696"",""secret_root_id"":""0"",""sort"":""101474300000"",""workitem_type_id"":""11991001000269"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-08-31
 15:24:19"",""modified"":""2021-09-03 16:13:49"",""paren [...]
+3,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037697"",""secret_root_id"":""0"",""sort"":""103769700000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test [...]
+4,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038322"",""secret_root_id"":""0"",""sort"":""101474400000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-07
 16:07:25"",""modified"":""2021-10-15 
18:51:24"",""parent_id"":""0"",""children_id"":""||1199100 [...]
+5,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038323"",""secret_root_id"":""0"",""sort"":""103832300000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\"
 [...]
+6,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038697"",""secret_root_id"":""0"",""sort"":""103562900000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test [...]
+7,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038911"",""secret_root_id"":""0"",""sort"":""101474500000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11"",""description"":null,""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-13
 18:28:23"",""modified"":""2022-03-26 
16:56:07"",""parent_id"":""0"",""children_id"":""||11991001038912 [...]
+8,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038912"",""secret_root_id"":""0"",""sort"":""103891200000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\"";}@font-face{font-family:\""C
 [...]
+9,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001039664"",""secret_root_id"":""0"",""sort"":""101474600000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-24
 15:46:47"",""modified"":""2021-1 [...]
+10,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001039673"",""secret_root_id"":""0"",""sort"":""103967300000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font- [...]
+11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001040086"",""secret_root_id"":""0"",""sort"":""101474700000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-09-29
 14:52:01"",""modified"":""2021-10-18 
13:46:59"",""parent_id"":""0"",""children_i [...]
+12,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001040088"",""secret_root_id"":""0"",""sort"":""104008800000"",""workitem_type_id"":""11991001000026"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><p><\/p><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test-11\" [...]
+13,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041163"",""secret_root_id"":""0"",""sort"":""101474800000"",""workitem_type_id"":""11991001000269"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""test-11test-11"",""created"":""2021-10-19
 15:58:33"",""modified"":""2021-10-21 09:30:53"",""parent_id"":""0"", [...]
+14,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041164"",""secret_root_id"":""0"",""sort"":""104116400000"",""workitem_type_id"":""11991001000026"",""name"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{font-family:\""Times New 
Roman\"";}@font-face{font-family:\""test-11test- [...]
+15,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041165"",""secret_root_id"":""0"",""sort"":""101474900000"",""workitem_type_id"":""11991001000269"",""name"":""PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09"",""description"":""<div><p>testUnicode672ctestUnicode671ftestUnicode9700testUnicode8981testUnicode6539testUnicode9020testUnicode7684testUnicode9875testUnicode9762testUnicode6709<\/p><p>1testU
 [...]
+16,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041166"",""secret_root_id"":""0"",""sort"":""104116600000"",""workitem_type_id"":""11991001000026"",""name"":""PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{ [...]
+17,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041788"",""secret_root_id"":""0"",""sort"":""101475000000"",""workitem_type_id"":""11991001000269"",""name"":""testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""testUnicode6768testUnicode4e39"",""creat
 [...]
+18,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041789"",""secret_root_id"":""0"",""sort"":""104178900000"",""workitem_type_id"":""11991001000026"",""name"":""testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09"",""description"":""<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><style>@font-face{fon [...]
+19,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041899"",""secret_root_id"":""0"",""sort"":""101475100000"",""workitem_type_id"":""11991001000269"",""name"":""2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c"",""description"":"""",""markdown_description"":null,""description_type"":""1"",""creator"":""testUnicode5218testUnicode5b87testUnicode6615"",""created"":""2021-10-28
 10:56:01"",""modified"":""2021-12-20 09:51 [...]
+20,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041900"",""secret_root_id"":""0"",""sort"":""104190000000"",""workitem_type_id"":""11991001000026"",""name"":""testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d"",""description"":""<div><div><div><div><div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--><\/div><\/div><\/div><\/div><\/div><\/div><style>@font-face{font-family:\""Times
 New Roman\"" [...]
diff --git a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status.csv
index 53aa288c..ee36687c 100644
--- a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status.csv
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status.csv
@@ -1,11 +1,2 @@
 id,params,data,url,input,created_at
-11,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-12,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-13,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-14,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-15,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-16,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-17,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-18,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-19,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
-20,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""test111test111test111"",""resolved"":""test111test111test111"",""rejected"":""test111test111test111"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8""
 [...]
+11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""status"":1,""data"":{""planning"":""test111test111test111"",""developing"":""开发中"",""resolved"":""已解决"",""rejected"":""已拒绝"",""status_2"":""test111test111"",""status_3"":""test111test111test111"",""status_4"":""test111test111"",""status_5"":""test111test111test111"",""status_6"":""test111test111test111test111test111"",""status_7"":""test111test111test111"",""status_8"":""test111test111test111"",""status_9"":""test111test11
 [...]
diff --git 
a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status_last_steps.csv 
b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status_last_steps.csv
new file mode 100644
index 00000000..24bb5acb
--- /dev/null
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_story_status_last_steps.csv
@@ -0,0 +1,2 @@
+id,params,data,url,input,created_at
+11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""status"":1,""data"":{""resolved"":""已解决"",""rejected"":""已拒绝""},""info"":""success""}",https://api.tapd.cn/workflows/status_map?system=bug&workspace_id=991,null,2022-06-21
 13:06:31.335
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_labels_bug.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_labels_bug.csv
new file mode 100644
index 00000000..58b317b6
--- /dev/null
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_labels_bug.csv
@@ -0,0 +1 @@
+id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,url,issue_key,title,description,epic_key,type,status,original_status,story_point,resolution_date,created_date,updated_date,lead_time_minutes,parent_issue_id,priority,original_estimate_minutes,time_spent_minutes,time_remaining_minutes,creator_id,assignee_id,assignee_name,severity,component,icon_url,creator_name
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_statuses.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_statuses.csv
index bf39da68..a5f4b13a 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_statuses.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_statuses.csv
@@ -1,22 +1,22 @@
 
connection_id,workspace_id,english_name,chinese_name,is_last_step,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,991,developing,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,planning,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,rejected,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,resolved,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_10,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_11,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_12,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_13,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_14,test111test111test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_15,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_16,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_17,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_18,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_2,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_3,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_4,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_5,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_6,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_7,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_8,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
-1,991,status_9,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_bug_status,20,
+1,991,developing,开发中,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,planning,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,rejected,已拒绝,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,resolved,已解决,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_10,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_11,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_12,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_13,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_14,test111test111test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_15,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_16,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_17,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_18,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_2,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_3,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_4,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_5,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_6,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_7,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_8,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
+1,991,status_9,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,11,
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
index 829ba8a6..7746d7bf 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
@@ -1,21 +1 @@
 
connection_id,id,epic_key,title,description,workspace_id,created,modified,status,cc,begin,due,priority,iteration_id,source,module,release_id,created_from,feature,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,severity,reporter,resolved,closed,lastmodify,auditer,de,fixer,version_test,version_report,version_close,version_fix,baseline_find,baseline_join,baseline_close,baseline_test,sourcephase,te,current_owner,resolution,originphase,confirmer,participator,closer,platform,os,
 [...]
-1,11991001001025,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<a
 href=""http://insurance.hexun.com/index-0212.html""; 
target=""_blank"">http://insurance.hexun.com/index-0212.html</a>test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  /></div><div>test-11test-11test-11test-11test-11< [...]
-1,11991001001030,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<a
 href=""http://insurance.hexun.com/insurclass/""; 
target=""_blank"">http://insurance.hexun.com/insurclass/</ [...]
-1,11991001001031,,,<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<br
  /></div><div><br  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11 [...]
-1,11991001001032,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<a
 href=""http://insurance.hexun.com/bxjgdt/index.html""; 
target=""_blank"">http://insurance.hexun.com/bxjgdt/index.html</a>test-11 [...]
-1,11991001001417,,,<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11
 [...]
-1,11991001001418,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001420,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>3test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  /></div><div>test-11test- [...]
-1,11991001001422,,,"<div><br  
/></div><div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11
 [...]
-1,11991001001423,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test
 [...]
-1,11991001001425,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001426,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001447,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001448,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001450,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001451,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-1
 [...]
-1,11991001001710,,,<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11<br
  /></div><div><br  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11
 [...]
-1,11991001001711,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11...test-11<br
  /></div><div><br  /></div><div> [...]
-1,11991001001737,,,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11</div><div>3test-11test-11test-11test-11test-11test-11test-11test-11</div><div>4test-11test-11test-11test-11test-11test-11test-11</div><div><br
  
/></div><div>test-11test-11test-11test-11test-11</div><div>test-11test-11test-11test-11test-11test-11</div><div><br
  [...]
-1,11991001001739,,,"<div>tt64cdtt4f5ctt6b65tt9aa4ttff1a</div><div>1tt3001tt8fdbtt5165tt6d3btt52a8tt62a5tt540dtt5bfctt822att9875</div><div>2tt3001tt67e5tt770btt6d3btt52a8tt8be6tt60c5tt533att57dftt5c55tt793a</div><div><br
  
/></div><div>tt9884tt671ftt7ed3tt679cttff1a</div><div>tt6d3btt52a8tt8be6tt60c5tt533att57dftt5c55tt793att6b63tt5e38</div><div><br
  
/></div><div>tt5b9ett9645tt7ed3tt679cttff1a</div><div>tt6d3btt52a8tt8be6tt60c5tt6587tt5b57tt6587tt5b57tt6bb5tt843dtt4e2dtt591att5904tt5730tt6
 [...]
-1,11991001001740,,,<div>tt64cdtt4f5ctt6b65tt9aa4ttff1a</div><div>1tt3001tt8fdbtt5165tt6d3btt52a8tt62a5tt540dtt5bfctt822att9875</div><div>2tt3001tt5728tt4e13tt5bb6tt5c55tt793att533att57dftt70b9tt51fbtt4e13tt5bb6tt5934tt50cftt6216tt540dtt5b57</div><div>3tt3001tt67e5tt770btt9875tt9762tt8df3tt8f6c</div><div><br
  
/></div><div>tt9884tt671ftt7ed3tt679cttff1a</div><div>tt9875tt9762tt8df3转正常,跳转后地址正常</div><div><br
  
/></div><div>实际结果:</div><div>页面跳转正常,跳转后地址为区块链首页,应跳转到专家介绍页</div>,991,2020-03-18T07:3
 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_iteration_stories.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_iteration_stories.csv
index d9d617ab..4983a7b9 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_iteration_stories.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_iteration_stories.csv
@@ -1,12 +1,12 @@
-connection_id,workspace_id,iteration_id,story_id,resolution_date,story_created_date,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,991,11991001000614,11991001038323,2021-10-08T06:33:36.000+00:00,2021-09-07T08:08:40.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
-1,991,11991001000614,11991001039673,2021-10-08T06:31:35.000+00:00,2021-09-24T09:31:03.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
-1,991,11991001000629,11991001040088,2021-10-18T05:46:40.000+00:00,2021-09-29T06:53:14.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
-1,991,11991001000629,11991001041166,2021-11-16T08:51:42.000+00:00,2021-10-19T08:31:56.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
-1,991,11991001000745,11991001037697,2021-09-03T08:13:35.000+00:00,2021-08-31T07:27:52.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
-1,991,11991001000745,11991001038697,2021-09-13T02:24:50.000+00:00,2021-09-10T07:15:37.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
-1,991,11991001000745,11991001041164,2021-10-21T01:30:40.000+00:00,2021-10-19T08:12:26.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
-1,991,11991001000745,11991001041789,2021-11-30T05:56:15.000+00:00,2021-10-27T09:00:55.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
-1,991,11991001000767,11991001037563,2021-09-29T09:54:01.000+00:00,2021-08-30T07:59:44.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
-1,991,11991001000812,11991001041900,2021-12-20T01:51:36.000+00:00,2021-10-28T02:58:07.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
-1,991,11991001000979,11991001038912,2022-03-17T04:04:50.000+00:00,2021-09-13T10:29:22.000+00:00,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
+connection_id,iteration_id,workspace_id,story_id,resolution_date,story_created_date,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,11991001000614,991,11991001038323,2021-10-08T06:33:36.000+00:00,2021-09-07T08:08:40.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
+1,11991001000614,991,11991001039673,2021-10-08T06:31:35.000+00:00,2021-09-24T09:31:03.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
+1,11991001000629,991,11991001040088,2021-10-18T05:46:40.000+00:00,2021-09-29T06:53:14.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
+1,11991001000629,991,11991001041166,2021-11-16T08:51:42.000+00:00,2021-10-19T08:31:56.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
+1,11991001000745,991,11991001037697,2021-09-03T08:13:35.000+00:00,2021-08-31T07:27:52.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
+1,11991001000745,991,11991001038697,2021-09-13T02:24:50.000+00:00,2021-09-10T07:15:37.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
+1,11991001000745,991,11991001041164,2021-10-21T01:30:40.000+00:00,2021-10-19T08:12:26.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
+1,11991001000745,991,11991001041789,2021-11-30T05:56:15.000+00:00,2021-10-27T09:00:55.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
+1,11991001000767,991,11991001037563,2021-09-29T09:54:01.000+00:00,2021-08-30T07:59:44.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
+1,11991001000812,991,11991001041900,2021-12-20T01:51:36.000+00:00,2021-10-28T02:58:07.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
+1,11991001000979,991,11991001038912,2022-03-17T04:04:50.000+00:00,2021-09-13T10:29:22.000+00:00,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv
index c9d60578..de18c95e 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv
@@ -1,21 +1,21 @@
 
connection_id,id,workitem_type_id,name,description,workspace_id,creator,created,modified,status,owner,cc,begin,due,size,priority,developer,iteration_id,test_focus,type,source,module,version,completed,category_id,path,parent_id,children_id,ancestor_id,business_value,effort,effort_completed,exceed,remain,release_id,confidential,templated_id,created_from,feature,std_status,std_type,url,attachment_count,has_attachment,bug_id,follower,sync_type,predecessor_count,is_archived,modifier,progress_
 [...]
-1,11991001037563,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calibri
 [...]
-1,11991001037696,11991001000269,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-08-31T07:24:19.000+00:00,2021-09-03T08:13:49.000+00:00,test111test111,test-11test-11,,2021-08-31T16:00:00.000+00:00,2021-09-01T16:00:00.000+00:00,0,,,0,,,,,,2021-09-03T08:13:49.000+00:00,11991001000175,11991001037696:,0,||11991001037697,11991001037696,,0,0,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/
 [...]
-1,11991001037697,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-j
 [...]
-1,11991001038322,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-07T08:07:25.000+00:00,2021-10-15T10:51:24.000+00:00,test111test111,test-11test-11,,2021-09-12T16:00:00.000+00:00,2021-10-07T16:00:00.000+00:00,0,3,,0,,,,,,2021-10-08T06:33:50.000+00:00,11991001000175,11991001038322:,0,||11991001038323,11991001038322,,57,57,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001038322,0,0,0,,,0
 [...]
-1,11991001038323,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calib
 [...]
-1,11991001038697,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:
 [...]
-1,11991001038911,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-13T10:28:23.000+00:00,2022-03-26T08:56:07.000+00:00,test111test111test111,test-11test-11,,2021-09-13T16:00:00.000+00:00,2022-03-18T16:00:00.000+00:00,0,,,0,,,,,,2022-03-17T04:04:39.000+00:00,11991001000175,11991001038911:,0,||11991001038912,11991001038911,,22,21.5,-0.5,0,0,N,11991001001129,,"""""",IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001038911
 [...]
-1,11991001038912,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calibri
 [...]
-1,11991001039664,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-24T07:46:47.000+00:00,2021-10-08T06:31:48.000+00:00,test111test111,test-11test-11,,2021-09-26T16:00:00.000+00:00,2021-09-29T16:00:00.000+00:00,0,,,0,,,,,,2021-10-08T06:31:48.000+00:00,11991001000175,11991001039664:,0,||11991001039673,11991001039664,,3,3,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https:/
 [...]
-1,11991001039673,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;te
 [...]
-1,11991001040086,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-29T06:52:01.000+00:00,2021-10-18T05:46:59.000+00:00,test111test111,test-11test-11,,2021-10-07T16:00:00.000+00:00,2021-10-26T16:00:00.000+00:00,0,,,0,,,,,,2021-10-18T05:46:59.000+00:00,11991001000175,11991001040086:,0,||11991001040088,11991001040086,,20,20,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001040
 [...]
-1,11991001040088,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><p></p><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-i
 [...]
-1,11991001041163,11991001000269,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-10-19T07:58:33.000+00:00,2021-10-21T01:30:53.000+00:00,test111test111,test-11test-11,,2021-10-19T16:00:00.000+00:00,2021-10-20T16:00:00.000+00:00,0,,,0,,,,,,2021-10-21T01:30:53.000+00:00,11991001000175,11991001041163:,0,||11991001041164,11991001041163,,0,0,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/1
 [...]
-1,11991001041164,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:in
 [...]
-1,11991001041165,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,"<div><p>testUnicode672ctestUnicode671ftestUnicode9700testUnicode8981testUnicode6539testUnicode9020testUnicode7684testUnicode9875testUnicode9762testUnicode6709</p><p>1testUnicode3001</p><p><a
 href=""http://news.hexun.com/economy/""; rel=""noopener"" 
target=""_blank"">http://news.hexun.com/economy/</a></p><p><a 
href=""http://news.hexun.com/international/""; rel="" [...]
-1,11991001041166,11991001000026,PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode5b8btestUnicode6587;mso-st
 [...]
-1,11991001041788,11991001000269,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,991,testUnicode6768testUnicode4e39,2021-10-27T08:55:27.000+00:00,2021-11-30T10:04:48.000+00:00,test111test111,testUnicode6768testUnicode4e39,,2021-11-02T16:00:00.000+00:00,2021-11-29T16:00:00.000+00:00,0,,,0,,,,,,2021-11-30T05:57:19.000+00:00,11991001000175,11991001041788:,0,||11991001041789,11991001041
 [...]
-1,11991001041789,11991001000026,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode6b63testUnicode6587;mso-style
 [...]
-1,11991001041899,11991001000269,2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c,,991,testUnicode5218testUnicode5b87testUnicode6615,2021-10-28T02:56:01.000+00:00,2021-12-20T01:51:46.000+00:00,test111test111,testUnicode5218testUnicode5b87testUnicode6615,,2021-11-02T16:00:00.000+00:00,2021-12-07T16:00:00.000+00:00,0,3,,0,,,,,,2021-12-20T01:51:46.000+00:00,11991001000175,11991001041899:,0,||11991001041900|11991001042964,11991001041899,,250,250,0,0,0,N,11991001
 [...]
-1,11991001041900,11991001000026,testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d,"<div><div><div><div><div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div></div></div></div></div><style>@font-face{font-family:""Times
 New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode6b63testUnicode6587;mso-style-parent:"""";margin:0.00px;margin-
 [...]
+1,11991001037563,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calibri
 [...]
+1,11991001037696,11991001000269,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-08-31T07:24:19.000+00:00,2021-09-03T08:13:49.000+00:00,test111test111,test-11test-11,,2021-08-31T16:00:00.000+00:00,2021-09-01T16:00:00.000+00:00,0,,,0,,,,,,2021-09-03T08:13:49.000+00:00,11991001000175,11991001037696:,0,||11991001037697,11991001037696,,0,0,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/
 [...]
+1,11991001037697,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-j
 [...]
+1,11991001038322,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-07T08:07:25.000+00:00,2021-10-15T10:51:24.000+00:00,test111test111,test-11test-11,,2021-09-12T16:00:00.000+00:00,2021-10-07T16:00:00.000+00:00,0,3,,0,,,,,,2021-10-08T06:33:50.000+00:00,11991001000175,11991001038322:,0,||11991001038323,11991001038322,,57,57,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001038322,0,0,0,,,0
 [...]
+1,11991001038323,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calib
 [...]
+1,11991001038697,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:
 [...]
+1,11991001038911,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-13T10:28:23.000+00:00,2022-03-26T08:56:07.000+00:00,test111test111test111,test-11test-11,,2021-09-13T16:00:00.000+00:00,2022-03-18T16:00:00.000+00:00,0,,,0,,,,,,2022-03-17T04:04:39.000+00:00,11991001000175,11991001038911:,0,||11991001038912,11991001038911,,22,21.5,-0.5,0,0,N,11991001001129,,"""""",IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001038911
 [...]
+1,11991001038912,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-ideograph;font-family:Calibri
 [...]
+1,11991001039664,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-24T07:46:47.000+00:00,2021-10-08T06:31:48.000+00:00,test111test111,test-11test-11,,2021-09-26T16:00:00.000+00:00,2021-09-29T16:00:00.000+00:00,0,,,0,,,,,,2021-10-08T06:31:48.000+00:00,11991001000175,11991001039664:,0,||11991001039673,11991001039664,,3,3,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https:/
 [...]
+1,11991001039673,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;te
 [...]
+1,11991001040086,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-09-29T06:52:01.000+00:00,2021-10-18T05:46:59.000+00:00,test111test111,test-11test-11,,2021-10-07T16:00:00.000+00:00,2021-10-26T16:00:00.000+00:00,0,,,0,,,,,,2021-10-18T05:46:59.000+00:00,11991001000175,11991001040086:,0,||11991001040088,11991001040086,,20,20,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/11991001040
 [...]
+1,11991001040088,11991001000026,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><p></p><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:inter-i
 [...]
+1,11991001041163,11991001000269,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2021-10-19T07:58:33.000+00:00,2021-10-21T01:30:53.000+00:00,test111test111,test-11test-11,,2021-10-19T16:00:00.000+00:00,2021-10-20T16:00:00.000+00:00,0,,,0,,,,,,2021-10-21T01:30:53.000+00:00,11991001000175,11991001041163:,0,||11991001041164,11991001041163,,0,0,0,0,0,N,11991001001129,,,IN_PROGRESS,REQUIREMENT,https://www.tapd.cn/991/prong/stories/view/1
 [...]
+1,11991001041164,11991001000026,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""test-11test-11"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:test-11test-11;mso-style-parent:"""";margin:0.00px;margin-bottom:0.00px;mso-pagination:none;text-align:justify;text-justify:in
 [...]
+1,11991001041165,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,"<div><p>testUnicode672ctestUnicode671ftestUnicode9700testUnicode8981testUnicode6539testUnicode9020testUnicode7684testUnicode9875testUnicode9762testUnicode6709</p><p>1testUnicode3001</p><p><a
 href=""http://news.hexun.com/economy/""; rel=""noopener"" 
target=""_blank"">http://news.hexun.com/economy/</a></p><p><a 
href=""http://news.hexun.com/international/""; rel="" [...]
+1,11991001041166,11991001000026,PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode5b8btestUnicode6587;mso-st
 [...]
+1,11991001041788,11991001000269,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,991,testUnicode6768testUnicode4e39,2021-10-27T08:55:27.000+00:00,2021-11-30T10:04:48.000+00:00,test111test111,testUnicode6768testUnicode4e39,,2021-11-02T16:00:00.000+00:00,2021-11-29T16:00:00.000+00:00,0,,,0,,,,,,2021-11-30T05:57:19.000+00:00,11991001000175,11991001041788:,0,||11991001041789,11991001041
 [...]
+1,11991001041789,11991001000026,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,"<div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div><style>@font-face{font-family:""Times New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode6b63testUnicode6587;mso-style
 [...]
+1,11991001041899,11991001000269,2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c,,991,testUnicode5218testUnicode5b87testUnicode6615,2021-10-28T02:56:01.000+00:00,2021-12-20T01:51:46.000+00:00,test111test111,testUnicode5218testUnicode5b87testUnicode6615,,2021-11-02T16:00:00.000+00:00,2021-12-07T16:00:00.000+00:00,0,3,,0,,,,,,2021-12-20T01:51:46.000+00:00,11991001000175,11991001041899:,0,||11991001041900|11991001042964,11991001041899,,250,250,0,0,0,N,11991001
 [...]
+1,11991001041900,11991001000026,testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d,"<div><div><div><div><div><div><div><!--
 [if gte mso 9]><![endif]--><!-- [if gte mso 
9]><![endif]--></div></div></div></div></div></div><style>@font-face{font-family:""Times
 New 
Roman"";}@font-face{font-family:""testUnicode5b8btestUnicode4f53"";}@font-face{font-family:""Calibri"";}p.MsoNormal{mso-style-name:testUnicode6b63testUnicode6587;mso-style-parent:"""";margin:0.00px;margin-
 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_story_statuses.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_story_statuses.csv
index 8e0e67c1..7038bf0a 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_story_statuses.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_story_statuses.csv
@@ -1,22 +1,22 @@
 
connection_id,workspace_id,english_name,chinese_name,is_last_step,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,991,developing,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,planning,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,rejected,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,resolved,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_10,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_11,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_12,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_13,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_14,test111test111test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_15,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_16,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_17,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_18,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_2,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_3,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_4,test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_5,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_6,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_7,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_8,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
-1,991,status_9,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_story_status,20,
+1,991,developing,开发中,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,planning,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,rejected,已拒绝,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,resolved,已解决,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_10,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_11,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_12,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_13,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_14,test111test111test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_15,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_16,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_17,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_18,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_2,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_3,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_4,test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_5,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_6,test111test111test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_7,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_8,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
+1,991,status_9,test111test111test111,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_story_status,11,
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workspace_stories.csv 
b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workspace_stories.csv
index a9ca9c17..8ce9ca00 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workspace_stories.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workspace_stories.csv
@@ -1,21 +1,21 @@
 
connection_id,workspace_id,story_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,991,11991001037563,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
-1,991,11991001037696,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
-1,991,11991001037697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
-1,991,11991001038322,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
-1,991,11991001038323,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
-1,991,11991001038697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
-1,991,11991001038911,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
-1,991,11991001038912,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
-1,991,11991001039664,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
-1,991,11991001039673,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
-1,991,11991001040086,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
-1,991,11991001040088,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
-1,991,11991001041163,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
-1,991,11991001041164,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
-1,991,11991001041165,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
-1,991,11991001041166,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
-1,991,11991001041788,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
-1,991,11991001041789,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
-1,991,11991001041899,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
-1,991,11991001041900,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
+1,991,11991001037563,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
+1,991,11991001037696,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
+1,991,11991001037697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
+1,991,11991001038322,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
+1,991,11991001038323,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
+1,991,11991001038697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
+1,991,11991001038911,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
+1,991,11991001038912,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
+1,991,11991001039664,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
+1,991,11991001039673,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
+1,991,11991001040086,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
+1,991,11991001040088,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
+1,991,11991001041163,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
+1,991,11991001041164,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
+1,991,11991001041165,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
+1,991,11991001041166,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
+1,991,11991001041788,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
+1,991,11991001041789,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
+1,991,11991001041899,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
+1,991,11991001041900,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
diff --git a/plugins/tapd/e2e/snapshot_tables/board_issues_story.csv 
b/plugins/tapd/e2e/snapshot_tables/board_issues_story.csv
index e20f3434..c47e3861 100644
--- a/plugins/tapd/e2e/snapshot_tables/board_issues_story.csv
+++ b/plugins/tapd/e2e/snapshot_tables/board_issues_story.csv
@@ -1,21 +1,21 @@
 
board_id,issue_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
-tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
+tapd:TapdWorkspace:991,tapd:TapdIssue:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
diff --git a/plugins/tapd/e2e/snapshot_tables/issues_story.csv 
b/plugins/tapd/e2e/snapshot_tables/issues_story.csv
index 1de80608..8edd39c1 100644
--- a/plugins/tapd/e2e/snapshot_tables/issues_story.csv
+++ b/plugins/tapd/e2e/snapshot_tables/issues_story.csv
@@ -1,21 +1,21 @@
 
id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,url,issue_key,title,description,epic_key,type,status,original_status,story_point,resolution_date,created_date,updated_date,lead_time_minutes,parent_issue_id,priority,original_estimate_minutes,time_spent_minutes,time_remaining_minutes,creator_id,assignee_id,assignee_name,severity,component,icon_url,creator_name
-tapd:TapdIssue:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,1,,https://www.tapd.cn/991/prong/stories/view/11991001037563,11991001037563,test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-29T09:54:01.000+00:00,2021-08-30T07:59:44.000+00:00,2021-09-29T09:54:01.000+00:00,43314,tapd:TapdIssue:1:11991001037562,3,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-1
 [...]
-tapd:TapdIssue:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,2,,https://www.tapd.cn/991/prong/stories/view/11991001037696,11991001037696,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-03T08:13:49.000+00:00,2021-08-31T07:24:19.000+00:00,2021-09-03T08:13:49.000+00:00,4369,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:
 [...]
-tapd:TapdIssue:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,3,,https://www.tapd.cn/991/prong/stories/view/11991001037697,11991001037697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-03T08:13:35.000+00:00,2021-08-31T07:27:52.000+00:00,2021-09-03T08:13:35.000+00:00,4365,tapd:TapdIssue:1:11991001037696,,0,0,0,tapd:TapdAccount:1:test-11
 [...]
-tapd:TapdIssue:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,4,,https://www.tapd.cn/991/prong/stories/view/11991001038322,11991001038322,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:33:50.000+00:00,2021-09-07T08:07:25.000+00:00,2021-10-15T10:51:24.000+00:00,44546,tapd:TapdIssue:1:0,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11te
 [...]
-tapd:TapdIssue:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,5,,https://www.tapd.cn/991/prong/stories/view/11991001038323,11991001038323,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:33:36.000+00:00,2021-09-07T08:08:40.000+00:00,2021-10-15T10:51:24.000+00:00,44544,tapd:TapdIssue:1:11991001038322,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test
 [...]
-tapd:TapdIssue:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,6,,https://www.tapd.cn/991/prong/stories/view/11991001038697,11991001038697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-13T02:24:50.000+00:00,2021-09-10T07:15:37.000+00:00,2021-09-13T02:24:50.000+00:00,4029,tapd:TapdIssue:1:11991001035527,,0,0,0,tapd:TapdAccount:1:test-11test-11
 [...]
-tapd:TapdIssue:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,7,,https://www.tapd.cn/991/prong/stories/view/11991001038911,11991001038911,PCtest-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111test111,0,2022-03-17T04:04:39.000+00:00,2021-09-13T10:28:23.000+00:00,2022-03-26T08:56:07.000+00:00,266016,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11te
 [...]
-tapd:TapdIssue:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,8,,https://www.tapd.cn/991/prong/stories/view/11991001038912,11991001038912,PCtest-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111test111,0,2022-03-17T04:04:50.000+00:00,2021-09-13T10:29:22.000+00:00,2022-03-26T08:56:07.000+00:00,266015,tapd:TapdIssue:1:11991001038911,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test
 [...]
-tapd:TapdIssue:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,9,,https://www.tapd.cn/991/prong/stories/view/11991001039664,11991001039664,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:31:48.000+00:00,2021-09-24T07:46:47.000+00:00,2021-10-08T06:31:48.000+00:00,20085,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccoun
 [...]
-tapd:TapdIssue:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,10,,https://www.tapd.cn/991/prong/stories/view/11991001039673,11991001039673,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:31:35.000+00:00,2021-09-24T09:31:03.000+00:00,2021-10-08T06:31:35.000+00:00,19980,tapd:TapdIssue:1:11991001039664,,0,0,0,t
 [...]
-tapd:TapdIssue:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,11,,https://www.tapd.cn/991/prong/stories/view/11991001040086,11991001040086,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-18T05:46:59.000+00:00,2021-09-29T06:52:01.000+00:00,2021-10-18T05:46:59.000+00:00,27294,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11tes
 [...]
-tapd:TapdIssue:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,12,,https://www.tapd.cn/991/prong/stories/view/11991001040088,11991001040088,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-18T05:46:40.000+00:00,2021-09-29T06:53:14.000+00:00,2021-10-18T05:46:40.000+00:00,27293,tapd:TapdIssue:1:11991001040086,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount
 [...]
-tapd:TapdIssue:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,13,,https://www.tapd.cn/991/prong/stories/view/11991001041163,11991001041163,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-21T01:30:53.000+00:00,2021-10-19T07:58:33.000+00:00,2021-10-21T01:30:53.000+00:00,2492,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1
 [...]
-tapd:TapdIssue:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,14,,https://www.tapd.cn/991/prong/stories/view/11991001041164,11991001041164,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-21T01:30:40.000+00:00,2021-10-19T08:12:26.000+00:00,2021-10-21T01:30:41.000+00:00,2478,tapd:TapdIssue:1:11991001041163,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:
 [...]
-tapd:TapdIssue:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,15,,https://www.tapd.cn/991/prong/stories/view/11991001041165,11991001041165,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-16T08:52:01.000+00:00,2021-10-19T08:31:03.000+00:00,2021-11-16T10:13:26.000+00:00,40340,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testU
 [...]
-tapd:TapdIssue:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,16,,https://www.tapd.cn/991/prong/stories/view/11991001041166,11991001041166,PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-16T08:51:42.000+00:00,2021-10-19T08:31:56.000+00:00,2022-05-04T03:56:53.000+00:00,40339,tapd
 [...]
-tapd:TapdIssue:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,17,,https://www.tapd.cn/991/prong/stories/view/11991001041788,11991001041788,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-30T05:57:19.000+00:00,2021-10-27T08:55:27.000+00:00,2021-11-30T10:04:48.000+00:00,48781,tapd:Ta
 [...]
-tapd:TapdIssue:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,18,,https://www.tapd.cn/991/prong/stories/view/11991001041789,11991001041789,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-30T05:56:15.000+00:00,2021-10-27T09:00:55.000+00:00,2021-11-30T10:04:48.000+00:00,48775,tapd:Ta
 [...]
-tapd:TapdIssue:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,19,,https://www.tapd.cn/991/prong/stories/view/11991001041899,11991001041899,2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-12-20T01:51:46.000+00:00,2021-10-28T02:56:01.000+00:00,2021-12-20T01:51:46.000+00:00,76255,tapd:TapdIssue:1:0,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUn
 [...]
-tapd:TapdIssue:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,20,,https://www.tapd.cn/991/prong/stories/view/11991001041900,11991001041900,testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-12-20T01:51:36.000+00:00,2021-10-28T02:58:07.000+00:00,2021-12-20T01:51:36.000+00:00,76253,tapd:TapdIssue:1:11991001041899,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode
 [...]
+tapd:TapdIssue:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,,https://www.tapd.cn/991/prong/stories/view/11991001037563,11991001037563,test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-29T09:54:01.000+00:00,2021-08-30T07:59:44.000+00:00,2021-09-29T09:54:01.000+00:00,43314,tapd:TapdIssue:1:11991001037562,3,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11
 [...]
+tapd:TapdIssue:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,2,,https://www.tapd.cn/991/prong/stories/view/11991001037696,11991001037696,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-03T08:13:49.000+00:00,2021-08-31T07:24:19.000+00:00,2021-09-03T08:13:49.000+00:00,4369,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:T
 [...]
+tapd:TapdIssue:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,,https://www.tapd.cn/991/prong/stories/view/11991001037697,11991001037697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-03T08:13:35.000+00:00,2021-08-31T07:27:52.000+00:00,2021-09-03T08:13:35.000+00:00,4365,tapd:TapdIssue:1:11991001037696,,0,0,0,tapd:TapdAccount:1:test-11t
 [...]
+tapd:TapdIssue:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,4,,https://www.tapd.cn/991/prong/stories/view/11991001038322,11991001038322,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:33:50.000+00:00,2021-09-07T08:07:25.000+00:00,2021-10-15T10:51:24.000+00:00,44546,tapd:TapdIssue:1:0,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11tes
 [...]
+tapd:TapdIssue:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,,https://www.tapd.cn/991/prong/stories/view/11991001038323,11991001038323,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,DONE,已解决,0,2021-10-08T06:33:36.000+00:00,2021-09-07T08:08:40.000+00:00,2021-10-15T10:51:24.000+00:00,44544,tapd:TapdIssue:1:11991001038322,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,
 [...]
+tapd:TapdIssue:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,,https://www.tapd.cn/991/prong/stories/view/11991001038697,11991001038697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-09-13T02:24:50.000+00:00,2021-09-10T07:15:37.000+00:00,2021-09-13T02:24:50.000+00:00,4029,tapd:TapdIssue:1:11991001035527,,0,0,0,tapd:TapdAccount:1:test-11test-11,
 [...]
+tapd:TapdIssue:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,7,,https://www.tapd.cn/991/prong/stories/view/11991001038911,11991001038911,PCtest-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111test111,0,2022-03-17T04:04:39.000+00:00,2021-09-13T10:28:23.000+00:00,2022-03-26T08:56:07.000+00:00,266016,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11tes
 [...]
+tapd:TapdIssue:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,,https://www.tapd.cn/991/prong/stories/view/11991001038912,11991001038912,PCtest-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,DONE,已拒绝,0,2022-03-17T04:04:50.000+00:00,2021-09-13T10:29:22.000+00:00,2022-03-26T08:56:07.000+00:00,266015,tapd:TapdIssue:1:11991001038911,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,"""""";
 [...]
+tapd:TapdIssue:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,9,,https://www.tapd.cn/991/prong/stories/view/11991001039664,11991001039664,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:31:48.000+00:00,2021-09-24T07:46:47.000+00:00,2021-10-08T06:31:48.000+00:00,20085,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount
 [...]
+tapd:TapdIssue:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,,https://www.tapd.cn/991/prong/stories/view/11991001039673,11991001039673,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-08T06:31:35.000+00:00,2021-09-24T09:31:03.000+00:00,2021-10-08T06:31:35.000+00:00,19980,tapd:TapdIssue:1:11991001039664,,0,0,0,ta
 [...]
+tapd:TapdIssue:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,11,,https://www.tapd.cn/991/prong/stories/view/11991001040086,11991001040086,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-18T05:46:59.000+00:00,2021-09-29T06:52:01.000+00:00,2021-10-18T05:46:59.000+00:00,27294,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test
 [...]
+tapd:TapdIssue:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,,https://www.tapd.cn/991/prong/stories/view/11991001040088,11991001040088,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-18T05:46:40.000+00:00,2021-09-29T06:53:14.000+00:00,2021-10-18T05:46:40.000+00:00,27293,tapd:TapdIssue:1:11991001040086,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:
 [...]
+tapd:TapdIssue:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,13,,https://www.tapd.cn/991/prong/stories/view/11991001041163,11991001041163,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-21T01:30:53.000+00:00,2021-10-19T07:58:33.000+00:00,2021-10-21T01:30:53.000+00:00,2492,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:
 [...]
+tapd:TapdIssue:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,,https://www.tapd.cn/991/prong/stories/view/11991001041164,11991001041164,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-10-21T01:30:40.000+00:00,2021-10-19T08:12:26.000+00:00,2021-10-21T01:30:41.000+00:00,2478,tapd:TapdIssue:1:11991001041163,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:T
 [...]
+tapd:TapdIssue:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,15,,https://www.tapd.cn/991/prong/stories/view/11991001041165,11991001041165,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-16T08:52:01.000+00:00,2021-10-19T08:31:03.000+00:00,2021-11-16T10:13:26.000+00:00,40340,tapd:TapdIssue:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testUn
 [...]
+tapd:TapdIssue:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,,https://www.tapd.cn/991/prong/stories/view/11991001041166,11991001041166,PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-16T08:51:42.000+00:00,2021-10-19T08:31:56.000+00:00,2022-05-04T03:56:53.000+00:00,40339,tapd:
 [...]
+tapd:TapdIssue:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,17,,https://www.tapd.cn/991/prong/stories/view/11991001041788,11991001041788,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-30T05:57:19.000+00:00,2021-10-27T08:55:27.000+00:00,2021-11-30T10:04:48.000+00:00,48781,tapd:Tap
 [...]
+tapd:TapdIssue:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,,https://www.tapd.cn/991/prong/stories/view/11991001041789,11991001041789,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-11-30T05:56:15.000+00:00,2021-10-27T09:00:55.000+00:00,2021-11-30T10:04:48.000+00:00,48775,tapd:Tap
 [...]
+tapd:TapdIssue:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,19,,https://www.tapd.cn/991/prong/stories/view/11991001041899,11991001041899,2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-12-20T01:51:46.000+00:00,2021-10-28T02:56:01.000+00:00,2021-12-20T01:51:46.000+00:00,76255,tapd:TapdIssue:1:0,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUni
 [...]
+tapd:TapdIssue:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,,https://www.tapd.cn/991/prong/stories/view/11991001041900,11991001041900,testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d,,,REQUIREMENT,IN_PROGRESS,test111test111,0,2021-12-20T01:51:36.000+00:00,2021-10-28T02:58:07.000+00:00,2021-12-20T01:51:36.000+00:00,76253,tapd:TapdIssue:1:11991001041899,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5
 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/sprint_issues_story.csv 
b/plugins/tapd/e2e/snapshot_tables/sprint_issues_story.csv
index 344136cb..1f5d0eb9 100644
--- a/plugins/tapd/e2e/snapshot_tables/sprint_issues_story.csv
+++ b/plugins/tapd/e2e/snapshot_tables/sprint_issues_story.csv
@@ -1,21 +1,21 @@
-issue_id,sprint_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-tapd:TapdIssue:1:11991001037563,tapd:TapdIteration:1:11991001000767,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
-tapd:TapdIssue:1:11991001037696,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
-tapd:TapdIssue:1:11991001037697,tapd:TapdIteration:1:11991001000745,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
-tapd:TapdIssue:1:11991001038322,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
-tapd:TapdIssue:1:11991001038323,tapd:TapdIteration:1:11991001000614,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
-tapd:TapdIssue:1:11991001038697,tapd:TapdIteration:1:11991001000745,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
-tapd:TapdIssue:1:11991001038911,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
-tapd:TapdIssue:1:11991001038912,tapd:TapdIteration:1:11991001000979,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
-tapd:TapdIssue:1:11991001039664,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
-tapd:TapdIssue:1:11991001039673,tapd:TapdIteration:1:11991001000614,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
-tapd:TapdIssue:1:11991001040086,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
-tapd:TapdIssue:1:11991001040088,tapd:TapdIteration:1:11991001000629,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
-tapd:TapdIssue:1:11991001041163,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
-tapd:TapdIssue:1:11991001041164,tapd:TapdIteration:1:11991001000745,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
-tapd:TapdIssue:1:11991001041165,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
-tapd:TapdIssue:1:11991001041166,tapd:TapdIteration:1:11991001000629,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
-tapd:TapdIssue:1:11991001041788,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
-tapd:TapdIssue:1:11991001041789,tapd:TapdIteration:1:11991001000745,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
-tapd:TapdIssue:1:11991001041899,tapd:TapdIteration:1:0,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
-tapd:TapdIssue:1:11991001041900,tapd:TapdIteration:1:11991001000812,"{""ConnectionId"":1,""CompanyId"":99,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
+sprint_id,issue_id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,2,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,4,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,7,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,9,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,11,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,13,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,15,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,17,
+tapd:TapdIteration:1:0,tapd:TapdIssue:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,19,
+tapd:TapdIteration:1:11991001000614,tapd:TapdIssue:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,
+tapd:TapdIteration:1:11991001000614,tapd:TapdIssue:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,
+tapd:TapdIteration:1:11991001000629,tapd:TapdIssue:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,
+tapd:TapdIteration:1:11991001000629,tapd:TapdIssue:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,
+tapd:TapdIteration:1:11991001000745,tapd:TapdIssue:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,
+tapd:TapdIteration:1:11991001000745,tapd:TapdIssue:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,
+tapd:TapdIteration:1:11991001000745,tapd:TapdIssue:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,
+tapd:TapdIteration:1:11991001000745,tapd:TapdIssue:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,
+tapd:TapdIteration:1:11991001000767,tapd:TapdIssue:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,
+tapd:TapdIteration:1:11991001000812,tapd:TapdIssue:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,
+tapd:TapdIteration:1:11991001000979,tapd:TapdIssue:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,
diff --git a/plugins/tapd/e2e/stories_test.go b/plugins/tapd/e2e/stories_test.go
index 028aa463..0d1d653f 100644
--- a/plugins/tapd/e2e/stories_test.go
+++ b/plugins/tapd/e2e/stories_test.go
@@ -42,11 +42,13 @@ func TestTapdStoryDataFlow(t *testing.T) {
        }
        
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_story_status.csv",
                "_raw_tapd_api_story_status")
-
+       
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_story_status_last_steps.csv",
+               "_raw_tapd_api_story_status_last_steps")
        // verify extraction
        dataflowTester.FlushTabler(&models.TapdWorkitemType{})
        dataflowTester.FlushTabler(&models.TapdStoryStatus{})
        dataflowTester.Subtask(tasks.ExtractStoryStatusMeta, taskData)
+       dataflowTester.Subtask(tasks.EnrichStoryStatusLastStepMeta, taskData)
        dataflowTester.VerifyTable(
                models.TapdStoryStatus{},
                "./snapshot_tables/_tool_tapd_story_statuses.csv",
diff --git a/plugins/tapd/e2e/story_and_bug_status_test.go 
b/plugins/tapd/e2e/story_and_bug_status_test.go
index 60c1ea2f..049862c7 100644
--- a/plugins/tapd/e2e/story_and_bug_status_test.go
+++ b/plugins/tapd/e2e/story_and_bug_status_test.go
@@ -46,6 +46,7 @@ func TestTapdStoryAndBugStatusDataFlow(t *testing.T) {
        // verify extraction
        dataflowTester.FlushTabler(&models.TapdStoryStatus{})
        dataflowTester.Subtask(tasks.ExtractStoryStatusMeta, taskData)
+       dataflowTester.Subtask(tasks.EnrichStoryStatusLastStepMeta, taskData)
        dataflowTester.VerifyTable(
                models.TapdStoryStatus{},
                "./snapshot_tables/_tool_tapd_story_statuses.csv",
@@ -70,6 +71,7 @@ func TestTapdStoryAndBugStatusDataFlow(t *testing.T) {
        // verify extraction
        dataflowTester.FlushTabler(&models.TapdBugStatus{})
        dataflowTester.Subtask(tasks.ExtractBugStatusMeta, taskData)
+       dataflowTester.Subtask(tasks.EnrichBugStatusLastStepMeta, taskData)
        dataflowTester.VerifyTable(
                models.TapdBugStatus{},
                "./snapshot_tables/_tool_tapd_bug_statuses.csv",
diff --git a/plugins/tapd/tasks/bug_extractor.go 
b/plugins/tapd/tasks/bug_extractor.go
index d59d9189..444b1c32 100644
--- a/plugins/tapd/tasks/bug_extractor.go
+++ b/plugins/tapd/tasks/bug_extractor.go
@@ -53,12 +53,13 @@ func ExtractBugs(taskCtx core.SubTaskContext) errors.Error {
        }
 
        statusMap := make(map[string]string, len(statusList))
+       lastStatusMap := make(map[string]bool, len(statusList))
        for _, v := range statusList {
                statusMap[v.EnglishName] = v.ChineseName
+               lastStatusMap[v.ChineseName] = v.IsLastStep
        }
-
        getStdStatus := func(statusKey string) string {
-               if statusKey == "已关闭" || statusKey == "不处理" {
+               if lastStatusMap[statusKey] {
                        return ticket.DONE
                } else if statusKey == "新建" {
                        return ticket.TODO
@@ -66,6 +67,7 @@ func ExtractBugs(taskCtx core.SubTaskContext) errors.Error {
                        return ticket.IN_PROGRESS
                }
        }
+
        extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
                RawDataSubTaskArgs: *rawDataSubTaskArgs,
                BatchSize:          100,
diff --git a/plugins/tapd/tasks/shared.go b/plugins/tapd/tasks/shared.go
index 5ab221c7..42fbb6d0 100644
--- a/plugins/tapd/tasks/shared.go
+++ b/plugins/tapd/tasks/shared.go
@@ -22,7 +22,6 @@ import (
        goerror "errors"
        "fmt"
        "github.com/apache/incubator-devlake/errors"
-       "github.com/apache/incubator-devlake/models/domainlayer/ticket"
        "gorm.io/gorm"
        "io"
        "net/http"
@@ -142,16 +141,6 @@ func CreateRawDataSubTaskArgs(taskCtx core.SubTaskContext, 
rawTable string, useC
        return rawDataSubTaskArgs, &filteredData
 }
 
-func getStdStatus(statusKey string) string {
-       if statusKey == "已实现" || statusKey == "已拒绝" || statusKey == "关闭" || 
statusKey == "已取消" || statusKey == "已解决" {
-               return ticket.DONE
-       } else if statusKey == "草稿" {
-               return ticket.TODO
-       } else {
-               return ticket.IN_PROGRESS
-       }
-}
-
 func getTypeMappings(data *TapdTaskData, db dal.Dal, system string) 
(*typeMappings, errors.Error) {
        typeIdMapping := make(map[uint64]string)
        issueTypes := make([]models.TapdWorkitemType, 0)
diff --git a/plugins/tapd/tasks/story_extractor.go 
b/plugins/tapd/tasks/story_extractor.go
index e4f970d1..9ddcd519 100644
--- a/plugins/tapd/tasks/story_extractor.go
+++ b/plugins/tapd/tasks/story_extractor.go
@@ -23,6 +23,7 @@ import (
        "github.com/apache/incubator-devlake/errors"
        "strings"
 
+       "github.com/apache/incubator-devlake/models/domainlayer/ticket"
        "github.com/apache/incubator-devlake/plugins/core"
        "github.com/apache/incubator-devlake/plugins/core/dal"
        "github.com/apache/incubator-devlake/plugins/helper"
@@ -40,7 +41,7 @@ var ExtractStoryMeta = core.SubTaskMeta{
 }
 
 func ExtractStories(taskCtx core.SubTaskContext) errors.Error {
-       rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx, 
RAW_STORY_TABLE, true)
+       rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx, 
RAW_STORY_TABLE, false)
        db := taskCtx.GetDal()
        statusList := make([]*models.TapdStoryStatus, 0)
        clauses := []dal.Clause{
@@ -52,9 +53,21 @@ func ExtractStories(taskCtx core.SubTaskContext) 
errors.Error {
        }
 
        statusMap := make(map[string]string, len(statusList))
+       lastStatusMap := make(map[string]bool, len(statusList))
        for _, v := range statusList {
                statusMap[v.EnglishName] = v.ChineseName
+               lastStatusMap[v.ChineseName] = v.IsLastStep
        }
+       getStdStatus := func(statusKey string) string {
+               if lastStatusMap[statusKey] {
+                       return ticket.DONE
+               } else if statusKey == "草稿" {
+                       return ticket.TODO
+               } else {
+                       return ticket.IN_PROGRESS
+               }
+       }
+
        mappings, err := getTypeMappings(data, db, "story")
 
        extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
diff --git a/plugins/tapd/tasks/story_status_extractor.go 
b/plugins/tapd/tasks/story_status_extractor.go
index dfc74c02..482c8c4a 100644
--- a/plugins/tapd/tasks/story_status_extractor.go
+++ b/plugins/tapd/tasks/story_status_extractor.go
@@ -36,7 +36,7 @@ var ExtractStoryStatusMeta = core.SubTaskMeta{
 }
 
 func ExtractStoryStatus(taskCtx core.SubTaskContext) errors.Error {
-       rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx, 
RAW_STORY_STATUS_TABLE, true)
+       rawDataSubTaskArgs, data := CreateRawDataSubTaskArgs(taskCtx, 
RAW_STORY_STATUS_TABLE, false)
        extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
                RawDataSubTaskArgs: *rawDataSubTaskArgs,
                Extract: func(row *helper.RawData) ([]interface{}, 
errors.Error) {

Reply via email to