You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by li...@apache.org on 2023/01/10 07:50:55 UTC
[incubator-devlake] branch main updated: Fix(4120): tapd type mapping (#4171)
This is an automated email from the ASF dual-hosted git repository.
likyh 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 1310b6f40 Fix(4120): tapd type mapping (#4171)
1310b6f40 is described below
commit 1310b6f40e0985909bd60abff4d435b80b3e5c53
Author: Warren Chen <yi...@merico.dev>
AuthorDate: Tue Jan 10 15:50:50 2023 +0800
Fix(4120): tapd type mapping (#4171)
* fix(tapd): bug type mapping
* feat(tapd): update e2e
* fix(tapd): fix minor issues
---
plugins/tapd/e2e/bugs_test.go | 30 +++++-----------
.../tapd/e2e/raw_tables/_raw_tapd_api_stories.csv | 12 +++----
.../raw_tables/_raw_tapd_api_workitem_types.csv | 8 ++---
.../e2e/raw_tables/_tool_tapd_bug_statuses.csv | 8 +++++
.../e2e/raw_tables/_tool_tapd_story_statuses.csv | 22 ++++++++++++
.../e2e/raw_tables/_tool_tapd_workitem_types.csv | 5 +++
.../snapshot_tables/_tool_tapd_bug_labels_bug.csv | 21 ------------
.../tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv | 40 +++++++++++-----------
.../e2e/snapshot_tables/_tool_tapd_stories.csv | 28 +++++++--------
.../tapd/e2e/snapshot_tables/_tool_tapd_tasks.csv | 30 ++++++++--------
.../snapshot_tables/_tool_tapd_workitem_types.csv | 8 ++---
plugins/tapd/e2e/snapshot_tables/issue_bug.csv | 21 ++++++++++++
plugins/tapd/e2e/snapshot_tables/issues_story.csv | 28 +++++++--------
plugins/tapd/e2e/snapshot_tables/issues_task.csv | 30 ++++++++--------
plugins/tapd/e2e/stories_test.go | 32 +++++++----------
plugins/tapd/e2e/story_and_bug_status_test.go | 6 ++--
plugins/tapd/e2e/tasks_test.go | 6 ++++
plugins/tapd/tasks/bug_extractor.go | 9 +++--
plugins/tapd/tasks/shared.go | 12 ++++---
plugins/tapd/tasks/story_changelog_converter.go | 12 +++++--
plugins/tapd/tasks/story_extractor.go | 12 +++----
plugins/tapd/tasks/task_extractor.go | 6 +++-
22 files changed, 210 insertions(+), 176 deletions(-)
diff --git a/plugins/tapd/e2e/bugs_test.go b/plugins/tapd/e2e/bugs_test.go
index 09265dc71..a875abb97 100644
--- a/plugins/tapd/e2e/bugs_test.go
+++ b/plugins/tapd/e2e/bugs_test.go
@@ -38,31 +38,17 @@ func TestTapdBugDataFlow(t *testing.T) {
ConnectionId: 1,
CompanyId: 99,
WorkspaceId: 991,
+ TransformationRules: tasks.TransformationRules{
+ TypeMappings: map[string]tasks.TypeMapping{
+ "BUG": {StandardType: "缺陷"},
+ "TASK": {StandardType: "任务"},
+ },
+ },
},
}
// bug status
- // 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",
- e2ehelper.ColumnWithRawData(
- "connection_id",
- "workspace_id",
- "english_name",
- "chinese_name",
- "is_last_step",
- ),
- )
+ dataflowTester.ImportCsvIntoTabler("./raw_tables/_tool_tapd_bug_statuses.csv", &models.TapdBugStatus{})
// import raw data table
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_bugs.csv", "_raw_tapd_api_bugs")
@@ -246,7 +232,7 @@ func TestTapdBugDataFlow(t *testing.T) {
dataflowTester.Subtask(tasks.ConvertBugMeta, taskData)
dataflowTester.VerifyTable(
ticket.Issue{},
- "./snapshot_tables/_tool_tapd_bug_labels_bug.csv",
+ "./snapshot_tables/issue_bug.csv",
e2ehelper.ColumnWithRawData(
"id",
"url",
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 9620da07a..af4641246 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"":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 [...]
+2,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001037696"",""secret_root_id"":""0"",""sort"":""101474300000"",""workitem_type_id"":""1146949574001000036"",""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"","" [...]
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:\" [...]
+5,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038323"",""secret_root_id"":""0"",""sort"":""103832300000"",""workitem_type_id"":""1146949574001000036"",""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-fami [...]
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 [...]
+8,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001038912"",""secret_root_id"":""0"",""sort"":""103891200000"",""workitem_type_id"":""1146949574001000036"",""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"":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\" [...]
+12,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001040088"",""secret_root_id"":""0"",""sort"":""104008800000"",""workitem_type_id"":""1146949574001000036"",""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 [...]
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{ [...]
+16,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041166"",""secret_root_id"":""0"",""sort"":""104116600000"",""workitem_type_id"":""1146949574001000035"",""name"":""PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09"",""description"":""<div><div><div><!-- [if gte mso 9]><![endif]--><!-- [if gte mso 9]><![endif]--><\/div><\/div><style>@font- [...]
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 [...]
+18,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Story"":{""id"":""11991001041789"",""secret_root_id"":""0"",""sort"":""104178900000"",""workitem_type_id"":""1146949574001000035"",""name"":""testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09"",""description"":""<div><div><div><!-- [if gte mso 9]><![endif]--><!-- [if gte mso 9]><![endif]--><\/div><\/div><style>@font-fac [...]
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_workitem_types.csv b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_workitem_types.csv
index 7fd3a82a6..212fd02ef 100644
--- a/plugins/tapd/e2e/raw_tables/_raw_tapd_api_workitem_types.csv
+++ b/plugins/tapd/e2e/raw_tables/_raw_tapd_api_workitem_types.csv
@@ -1,5 +1,5 @@
id,params,data,url,input,created_at
-1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000036"",""workspace_id"":""46949574"",""entity_type"":""story"",""name"":""\u6280\u672f\u503a"",""english_name"":""TDebt"",""status"":""3"",""color"":""#f85e5e"",""workflow_id"":""1146949574001000033"",""icon"":""46949574\/icon\/1146949574001000045"",""icon_small"":""46949574\/icon\/1146949574001000046"",""creator"":""\u90dd\u7433"",""created"":""2022-07-22 14:19:34"",""modified_by"":" [...]
-2,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000035"",""workspace_id"":""46949574"",""entity_type"":""story"",""name"":""\u957f\u7bc7\u6545\u4e8b"",""english_name"":""LStory"",""status"":""3"",""color"":""#8ebebe"",""workflow_id"":""1146949574001000033"",""icon"":""46949574\/icon\/1146949574001000043"",""icon_small"":""46949574\/icon\/1146949574001000044"",""creator"":""\u90dd\u7433"",""created"":""2022-07-22 14:17:56"",""modified [...]
-3,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000034"",""workspace_id"":""46949574"",""entity_type"":""story"",""name"":""Techstory"",""english_name"":""Tech"",""status"":""3"",""color"":""#3582fb"",""workflow_id"":""1146949574001000035"",""icon"":""46949574\/icon\/1146949574001000041"",""icon_small"":""46949574\/icon\/1146949574001000042"",""creator"":""\u90dd\u7433"",""created"":""2022-07-21 14:13:43"",""modified_by"":""\u90dd\u7 [...]
-4,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000033"",""workspace_id"":""46949574"",""entity_type"":""story"",""name"":""\u9700\u6c42"",""english_name"":""story"",""status"":""3"",""color"":""#3582fb"",""workflow_id"":""1146949574001000033"",""icon"":"""",""icon_small"":"""",""creator"":""TAPD system"",""created"":""2022-07-21 11:34:55"",""modified_by"":"""",""modified"":""2022-07-21 11:34:55"",""icon_viper"":""https:\/\/www.tapd. [...]
+1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000036"",""workspace_id"":""991"",""entity_type"":""story"",""name"":""\u6280\u672f\u503a"",""english_name"":""TDebt"",""status"":""3"",""color"":""#f85e5e"",""workflow_id"":""1146949574001000033"",""icon"":""46949574\/icon\/1146949574001000045"",""icon_small"":""46949574\/icon\/1146949574001000046"",""creator"":""\u90dd\u7433"",""created"":""2022-07-22 14:19:34"",""modified_by"":""\u90 [...]
+2,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000035"",""workspace_id"":""991"",""entity_type"":""story"",""name"":""\u957f\u7bc7\u6545\u4e8b"",""english_name"":""LStory"",""status"":""3"",""color"":""#8ebebe"",""workflow_id"":""1146949574001000033"",""icon"":""46949574\/icon\/1146949574001000043"",""icon_small"":""46949574\/icon\/1146949574001000044"",""creator"":""\u90dd\u7433"",""created"":""2022-07-22 14:17:56"",""modified_by"" [...]
+3,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""1146949574001000034"",""workspace_id"":""991"",""entity_type"":""story"",""name"":""Techstory"",""english_name"":""Tech"",""status"":""3"",""color"":""#3582fb"",""workflow_id"":""1146949574001000035"",""icon"":""46949574\/icon\/1146949574001000041"",""icon_small"":""46949574\/icon\/1146949574001000042"",""creator"":""\u90dd\u7433"",""created"":""2022-07-21 14:13:43"",""modified_by"":""\u90dd\u7433"" [...]
+4,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""WorkitemType"":{""id"":""11991001000269"",""workspace_id"":""991"",""entity_type"":""story"",""name"":""\u9700\u6c42"",""english_name"":""story"",""status"":""3"",""color"":""#3582fb"",""workflow_id"":""1146949574001000033"",""icon"":"""",""icon_small"":"""",""creator"":""TAPD system"",""created"":""2022-07-21 11:34:55"",""modified_by"":"""",""modified"":""2022-07-21 11:34:55"",""icon_viper"":""https:\/\/www.tapd.cn\/\/img\ [...]
diff --git a/plugins/tapd/e2e/raw_tables/_tool_tapd_bug_statuses.csv b/plugins/tapd/e2e/raw_tables/_tool_tapd_bug_statuses.csv
new file mode 100644
index 000000000..ca4ef63dd
--- /dev/null
+++ b/plugins/tapd/e2e/raw_tables/_tool_tapd_bug_statuses.csv
@@ -0,0 +1,8 @@
+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,closed,已关闭,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,in_progress,接受/处理,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,new,新,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,rejected,已拒绝,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,reopened,重新打开,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,resolved,已解决,1,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
+1,991,verified,已验证,0,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bug_status,51,
diff --git a/plugins/tapd/e2e/raw_tables/_tool_tapd_story_statuses.csv b/plugins/tapd/e2e/raw_tables/_tool_tapd_story_statuses.csv
new file mode 100644
index 000000000..7038bf0aa
--- /dev/null
+++ b/plugins/tapd/e2e/raw_tables/_tool_tapd_story_statuses.csv
@@ -0,0 +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,开发中,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/raw_tables/_tool_tapd_workitem_types.csv b/plugins/tapd/e2e/raw_tables/_tool_tapd_workitem_types.csv
new file mode 100644
index 000000000..148f25902
--- /dev/null
+++ b/plugins/tapd/e2e/raw_tables/_tool_tapd_workitem_types.csv
@@ -0,0 +1,5 @@
+connection_id,id,workspace_id,entity_type,name,english_name,status,color,workflow_id,icon,icon_small,creator,created,modified_by,modified,icon_viper,icon_small_viper,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+1,11991001000269,991,story,需求,story,3,#3582fb,1146949574001000033,,,TAPD system,2022-07-21T03:34:55.000+00:00,,2022-07-21T03:34:55.000+00:00,https://www.tapd.cn//img/workitem_type/default_icon/@2/story.png,https://www.tapd.cn//img/workitem_type/default_icon/@2/story_small.png,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_workitem_types,4,
+1,1146949574001000034,991,story,Techstory,Tech,3,#3582fb,1146949574001000035,46949574/icon/1146949574001000041,46949574/icon/1146949574001000042,郝琳,2022-07-21T06:13:43.000+00:00,郝琳,2022-07-21T06:19:15.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000041.png?token=718c3cd9ce755352ca168bf6875a680762fdfefb13942689afd41da6b4802f1e&version=1658384355&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000042.png?token=b1c5a360123fadbd6ea4bc2 [...]
+1,1146949574001000035,991,story,长篇故事,LStory,3,#8ebebe,1146949574001000033,46949574/icon/1146949574001000043,46949574/icon/1146949574001000044,郝琳,2022-07-22T06:17:56.000+00:00,郝琳,2022-07-22T06:18:12.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000043.png?token=9f17a906980a3ea89116d6e75003e6127bf10e6e9a758cffb1e9e8c2a5bb27fd&version=1658470692&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000044.png?token=d0d7885f2029a61149b323450e [...]
+1,1146949574001000036,991,story,技术债,TDebt,3,#f85e5e,1146949574001000033,46949574/icon/1146949574001000045,46949574/icon/1146949574001000046,郝琳,2022-07-22T06:19:34.000+00:00,郝琳,2022-07-22T06:20:14.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000045.png?token=ecc54ec9e76ac4862b0785e8978a9969939aa17add156d447bfba80976e7acd5&version=1658470814&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000046.png?token=54ae24aa2cebb737006a9a0a1b76 [...]
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
deleted file mode 100644
index c807622fa..000000000
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bug_labels_bug.csv
+++ /dev/null
@@ -1,21 +0,0 @@
-id,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,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-tapd:TapdBug:1:11991001001025,https://www.tapd.cn/991/prong/stories/view/11991001001025,11991001001025,test-11test-11test-11test-11test-11est-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-02-14T07:14:30.000+00:00,2020-02-13T06:04:29.000+00:00,2020-02-14T08:50:03.000+00:00,1510,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1271,
-tapd:TapdBug:1:11991001001030,https://www.tapd.cn/991/prong/stories/view/11991001001030,11991001001030,test-11test-11test-11t11test-11,,,BUG,IN_PROGRESS,,0,2020-02-14T07:12:58.000+00:00,2020-02-13T06:33:47.000+00:00,2020-02-17T03:57:42.000+00:00,1479,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1272,
-tapd:TapdBug:1:11991001001031,https://www.tapd.cn/991/prong/stories/view/11991001001031,11991001001031,test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,,0,2020-02-14T08:30:23.000+00:00,2020-02-13T06:45:11.000+00:00,2020-02-17T03:56:58.000+00:00,1545,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1273,
-tapd:TapdBug:1:11991001001032,https://www.tapd.cn/991/prong/stories/view/11991001001032,11991001001032,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-02-13T09:33:17.000+00:00,2020-02-13T06:50:33.000+00:00,2020-02-17T03:56:36.000+00:00,162,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"" [...]
-tapd:TapdBug:1:11991001001417,https://www.tapd.cn/991/prong/stories/view/11991001001417,11991001001417,test-11test-11-11test-11tesst-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-25T08:01:11.000+00:00,2020-03-04T08:12:14.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1275,
-tapd:TapdBug:1:11991001001418,https://www.tapd.cn/991/prong/stories/view/11991001001418,11991001001418,test-11tesest-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-25T08:04:12.000+00:00,2020-03-04T08:27:29.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1276,
-tapd:TapdBug:1:11991001001420,https://www.tapd.cn/991/prong/stories/view/11991001001420,11991001001420,test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-04T07:41:18.000+00:00,2020-02-25T08:07:04.000+00:00,2020-03-04T08:20:12.000+00:00,11494,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1277,
-tapd:TapdBug:1:11991001001422,https://www.tapd.cn/991/prong/stories/view/11991001001422,11991001001422,test-11te11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-25T08:10:51.000+00:00,2020-03-04T08:12:17.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"" [...]
-tapd:TapdBug:1:11991001001423,https://www.tapd.cn/991/prong/stories/view/11991001001423,11991001001423,test--11test-11test-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-25T08:12:56.000+00:00,2020-03-04T08:25:19.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1279,
-tapd:TapdBug:1:11991001001425,https://www.tapd.cn/991/prong/stories/view/11991001001425,11991001001425,test-11test1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-04T07:41:01.000+00:00,2020-02-25T08:18:40.000+00:00,2020-03-04T08:19:48.000+00:00,11482,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""C [...]
-tapd:TapdBug:1:11991001001426,https://www.tapd.cn/991/prong/stories/view/11991001001426,11991001001426,test-11test-11te11test-11test-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-25T08:23:39.000+00:00,2020-03-04T08:12:19.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1281,
-tapd:TapdBug:1:11991001001447,https://www.tapd.cn/991/prong/stories/view/11991001001447,11991001001447,IE11 test-11te1test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-17T08:43:28.000+00:00,2020-02-27T03:06:59.000+00:00,2020-03-18T08:24:37.000+00:00,27696,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1282,
-tapd:TapdBug:1:11991001001448,https://www.tapd.cn/991/prong/stories/view/11991001001448,11991001001448,IE11 test-11test-11test-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-02-27T03:14:02.000+00:00,2020-04-27T02:53:11.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1283,
-tapd:TapdBug:1:11991001001450,https://www.tapd.cn/991/prong/stories/view/11991001001450,11991001001450,IE11 tes-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-17T08:43:04.000+00:00,2020-02-27T03:18:04.000+00:00,2020-03-18T08:24:15.000+00:00,27685,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""Co [...]
-tapd:TapdBug:1:11991001001451,https://www.tapd.cn/991/prong/stories/view/11991001001451,11991001001451,IE11 test-11test-11test-st-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-17T08:42:17.000+00:00,2020-02-27T03:36:29.000+00:00,2020-03-18T08:23:08.000+00:00,27665,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1285,
-tapd:TapdBug:1:11991001001710,https://www.tapd.cn/991/prong/stories/view/11991001001710,11991001001710,test-11-11test-11test-11test-11test-11test-11test-11test-11test-11,,,BUG,DONE,已拒绝,0,,2020-03-13T06:14:26.000+00:00,2020-04-01T09:38:36.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1286,
-tapd:TapdBug:1:11991001001711,https://www.tapd.cn/991/prong/stories/view/11991001001711,11991001001711,test-11tesst-11test-11test-11test-11test-11test-11test-11test-11...test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11...test-11,,,BUG,DONE,已拒绝,0,,2020-03-13T06:20:04.000+00:00,2020-04-01T09:37:52.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11, [...]
-tapd:TapdBug:1:11991001001737,https://www.tapd.cn/991/prong/stories/view/11991001001737,11991001001737,test-11tesst-11test-1test-11test-11test-11test-11test-11test-11test-11,,,BUG,IN_PROGRESS,已关闭,0,2020-03-26T08:31:05.000+00:00,2020-03-18T07:27:14.000+00:00,2020-03-26T09:02:54.000+00:00,11583,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1288,
-tapd:TapdBug:1:11991001001739,https://www.tapd.cn/991/prong/stories/view/11991001001739,11991001001739,tt6d3btt52a8tt62a5tt5730tt65b986tt7a7att683c,,,BUG,IN_PROGRESS,已关闭,0,2020-03-26T08:25:10.000+00:00,2020-03-18T07:32:55.000+00:00,2020-03-26T09:02:37.000+00:00,11572,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:tt90ddtt9a81tt5bb5,,,normal,,,tt90ddtt9a81tt5bb5,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1289,
-tapd:TapdBug:1:11991001001740,https://www.tapd.cn/991/prong/stories/view/11991001001740,11991001001740,tt6d3btt52a8tt6ctt5230tt4e13tt5bb6tt4ecbtt7ecdtt9875,,,BUG,DONE,已拒绝,0,,2020-03-18T07:37:43.000+00:00,2020-03-25T02:38:34.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:郝骁宵,tapd:TapdAccount:1:郝骁宵,郝骁宵,normal,,,郝骁宵,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1290,
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
index 3b8ef7ca9..daace0911 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
@@ -1,21 +1,21 @@
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,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,testtype,testphase,frequency,regression_number,flows,testmode,i [...]
-1,11991001001025,,test-11test-11test-11test-11test-11est-11test-11test-11,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<a href=""http://insurance.xxx-com-sss/index-0212.html"" target=""_blank"">http://insurance.xxx-com-sss/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> [...]
-1,11991001001030,,test-11test-11test-11t11test-11,"<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.xxx-com-sss/insurclass/"" target=""_blank"">http:// [...]
-1,11991001001031,,test-11test-11test-11test-11test-11test-11test-11test-11test-11,<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><d [...]
-1,11991001001032,,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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 h [...]
-1,11991001001417,,test-11test-11-11test-11tesst-11test-11test-11test-11,<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>< [...]
-1,11991001001418,,test-11tesest-11test-11,"<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 [...]
-1,11991001001420,,test-11test-11test-11test-11test-11,"<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> [...]
-1,11991001001422,,test-11te11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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-11 [...]
-1,11991001001423,,test--11test-11test-11test-11test-11test-11,"<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-11tes [...]
-1,11991001001425,,test-11test1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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><b [...]
-1,11991001001426,,test-11test-11te11test-11test-11test-11test-11test-11,"<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-11te [...]
-1,11991001001447,,IE11 test-11te1test-11test-11test-11,"<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- [...]
-1,11991001001448,,IE11 test-11test-11test-11test-11test-11test-11,"<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-11t [...]
-1,11991001001450,,IE11 tes-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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>< [...]
-1,11991001001451,,IE11 test-11test-11test-st-11test-11,"<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- [...]
-1,11991001001710,,test-11-11test-11test-11test-11test-11test-11test-11test-11test-11,<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>t [...]
-1,11991001001711,,test-11tesst-11test-11test-11test-11test-11test-11test-11test-11...test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11...test-11,"<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< [...]
-1,11991001001737,,test-11tesst-11test-1test-11test-11test-11test-11test-11test-11test-11,"<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- [...]
-1,11991001001739,,tt6d3btt52a8tt62a5tt5730tt65b986tt7a7att683c,"<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>tt6d3btt52a8tt8be6tt60c5tt6587tt5b57tt6587t [...]
-1,11991001001740,,tt6d3btt52a8tt6ctt5230tt4e13tt5bb6tt4ecbtt7ecdtt9875,<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>页面 [...]
+1,11991001001025,,test-11test-11test-11test-11test-11est-11test-11test-11,"<div>test-11test-11test-11test-11test-11</div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<a href=""http://insurance.xxx-com-sss/index-0212.html"" target=""_blank"">http://insurance.xxx-com-sss/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> [...]
+1,11991001001030,,test-11test-11test-11t11test-11,"<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.xxx-com-sss/insurclass/"" target=""_blank"">http:// [...]
+1,11991001001031,,test-11test-11test-11test-11test-11test-11test-11test-11test-11,<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><d [...]
+1,11991001001032,,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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 h [...]
+1,11991001001417,,test-11test-11-11test-11tesst-11test-11test-11test-11,<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>< [...]
+1,11991001001418,,test-11tesest-11test-11,"<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 [...]
+1,11991001001420,,test-11test-11test-11test-11test-11,"<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> [...]
+1,11991001001422,,test-11te11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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-11 [...]
+1,11991001001423,,test--11test-11test-11test-11test-11test-11,"<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-11tes [...]
+1,11991001001425,,test-11test1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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><b [...]
+1,11991001001426,,test-11test-11te11test-11test-11test-11test-11test-11,"<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-11te [...]
+1,11991001001447,,IE11 test-11te1test-11test-11test-11,"<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- [...]
+1,11991001001448,,IE11 test-11test-11test-11test-11test-11test-11,"<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-11t [...]
+1,11991001001450,,IE11 tes-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,"<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>< [...]
+1,11991001001451,,IE11 test-11test-11test-st-11test-11,"<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- [...]
+1,11991001001710,,test-11-11test-11test-11test-11test-11test-11test-11test-11test-11,<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>t [...]
+1,11991001001711,,test-11tesst-11test-11test-11test-11test-11test-11test-11test-11...test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11...test-11,"<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< [...]
+1,11991001001737,,test-11tesst-11test-1test-11test-11test-11test-11test-11test-11test-11,"<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- [...]
+1,11991001001739,,tt6d3btt52a8tt62a5tt5730tt65b986tt7a7att683c,"<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>tt6d3btt52a8tt8be6tt60c5tt6587tt5b57tt6587t [...]
+1,11991001001740,,tt6d3btt52a8tt6ctt5230tt4e13tt5bb6tt4ecbtt7ecdtt9875,<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>页面 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_stories.csv
index 013fade15..ac6327266 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,11991001037696,1146949574001000036,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,技术需求债务,https://www.tapd.cn/991/pro [...]
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,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,故事需求,https://www.tapd.cn/991/prong/stories/view/11991001038322,0,0,0,,,0,0,,0 [...]
+1,11991001038323,1146949574001000036,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: [...]
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,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,故事需求,https://www.tapd.cn/991/prong/stories/view/11991001038911,0,0, [...]
+1,11991001038912,1146949574001000036,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:Ca [...]
+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,故事需求,https://www. [...]
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,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,故事需求,https://www.tapd.cn/991/prong/stories/view/11991001040086,0 [...]
+1,11991001040088,1146949574001000036,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:in [...]
+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,故事需求,https://www.tapd.cn/991/prong/stories/view/119910 [...]
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.xxx-com-sss/economy/"" rel=""noopener"" target=""_blank"">http://news.xxx-com-sss/economy/</a></p><p><a href=""http://news.xxx-com-sss/international/"" [...]
-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,11991001041165,11991001000269,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,"<div><p>testUnicode672ctestUnicode671ftestUnicode9700testUnicode8981testUnicode6539testUnicode9020testUnicode7684testUnicode9875testUnicode9762testUnicode6709</p><p>1testUnicode3001</p><p><a href=""http://news.xxx-com-sss/economy/"" rel=""noopener"" target=""_blank"">http://news.xxx-com-sss/economy/</a></p><p><a href=""http://news.xxx-com-sss/international/"" [...]
+1,11991001041166,1146949574001000035,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;m [...]
+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,119910010 [...]
+1,11991001041789,1146949574001000035,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- [...]
+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,119910 [...]
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_tasks.csv b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_tasks.csv
index 30a532111..49e2699df 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_tasks.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_tasks.csv
@@ -1,16 +1,16 @@
connection_id,id,name,description,workspace_id,creator,created,modified,status,owner,cc,begin,due,priority,iteration_id,completed,effort,effort_completed,exceed,remain,std_status,std_type,type,story_id,progress,has_attachment,url,attachment_count,follower,created_from,predecessor_count,successor_count,release_id,label,new_story_id,custom_field_one,custom_field_two,custom_field_three,custom_field_four,custom_field_five,custom_field6,custom_field7,custom_field8,custom_field9,custom_field10 [...]
-1,11991001015107,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-03T09:52:00.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T09:53:39.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015107,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-1,11991001015121,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11;,2020-11-03T10:39:57.000+00:00,2020-11-03T10:40:17.000+00:00,done,test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T10:40:17.000+00:00,9,9,0,0,DONE,TASK,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015121,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}" [...]
-1,11991001015142,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-03T10:58:43.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T11:00:18.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015142,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
-1,11991001015184,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-04T09:12:11.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-03T16:00:00.000+00:00,2020-11-03T16:00:00.000+00:00,,0,2020-11-04T09:14:22.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015184,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-1,11991001015203,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-04T10:38:10.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-03T16:00:00.000+00:00,2020-11-03T16:00:00.000+00:00,,0,2020-11-04T10:38:54.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015203,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
-1,11991001015207,pctest-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-04T10:43:02.000+00:00,2020-11-10T11:01:47.000+00:00,done,test-11test-11,test-11test-11;,2020-11-03T16:00:00.000+00:00,2020-11-09T16:00:00.000+00:00,,0,2020-11-10T11:01:47.000+00:00,27,27,0,0,DONE,TASK,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015207,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":9 [...]
-1,11991001015253,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-05T08:49:42.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-04T16:00:00.000+00:00,,0,2020-11-05T08:50:55.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015253,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-1,11991001015307,Mtest-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-05T11:12:13.000+00:00,2020-11-06T11:03:43.000+00:00,done,test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T11:03:43.000+00:00,19,18,-1,0,DONE,TASK,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015307,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4346,
-1,11991001015309,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-05T11:14:41.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-04T16:00:00.000+00:00,,0,2020-11-05T11:16:00.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015309,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
-1,11991001015340,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-06T09:10:44.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-05T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T09:12:19.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015340,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-1,11991001015361,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-06T10:49:54.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-05T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T10:50:31.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015361,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
-1,11991001015431,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-09T04:45:27.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-08T16:00:00.000+00:00,,0,2020-11-09T04:46:54.000+00:00,3,3,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015431,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
-1,11991001015441,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-09T09:14:15.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-08T16:00:00.000+00:00,,0,2020-11-09T09:16:32.000+00:00,9,9,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015441,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-1,11991001015452,Mtest-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-09T10:22:28.000+00:00,2020-11-11T10:47:24.000+00:00,done,test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-10T16:00:00.000+00:00,,0,2020-11-11T10:47:24.000+00:00,27,27,0,0,DONE,TASK,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015452,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw [...]
-1,11991001015583,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-10T03:45:34.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-09T16:00:00.000+00:00,2020-11-09T16:00:00.000+00:00,,0,2020-11-10T03:47:30.000+00:00,3,3,0,0,DONE,TASK,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015583,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
+1,11991001015107,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-03T09:52:00.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T09:53:39.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015107,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ [...]
+1,11991001015121,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11;,2020-11-03T10:39:57.000+00:00,2020-11-03T10:40:17.000+00:00,done,test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T10:40:17.000+00:00,9,9,0,0,DONE,任务,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015121,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
+1,11991001015142,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-03T10:58:43.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-02T16:00:00.000+00:00,2020-11-02T16:00:00.000+00:00,,0,2020-11-03T11:00:18.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015142,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+1,11991001015184,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-04T09:12:11.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-03T16:00:00.000+00:00,2020-11-03T16:00:00.000+00:00,,0,2020-11-04T09:14:22.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015184,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ [...]
+1,11991001015203,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-04T10:38:10.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-03T16:00:00.000+00:00,2020-11-03T16:00:00.000+00:00,,0,2020-11-04T10:38:54.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015203,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+1,11991001015207,pctest-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-04T10:43:02.000+00:00,2020-11-10T11:01:47.000+00:00,done,test-11test-11,test-11test-11;,2020-11-03T16:00:00.000+00:00,2020-11-09T16:00:00.000+00:00,,0,2020-11-10T11:01:47.000+00:00,27,27,0,0,DONE,任务,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015207,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991 [...]
+1,11991001015253,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-05T08:49:42.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-04T16:00:00.000+00:00,,0,2020-11-05T08:50:55.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015253,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ [...]
+1,11991001015307,Mtest-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-05T11:12:13.000+00:00,2020-11-06T11:03:43.000+00:00,done,test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T11:03:43.000+00:00,19,18,-1,0,DONE,任务,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015307,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4346,
+1,11991001015309,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-05T11:14:41.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-04T16:00:00.000+00:00,2020-11-04T16:00:00.000+00:00,,0,2020-11-05T11:16:00.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015309,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+1,11991001015340,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-06T09:10:44.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-05T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T09:12:19.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015340,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ [...]
+1,11991001015361,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-06T10:49:54.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-05T16:00:00.000+00:00,2020-11-05T16:00:00.000+00:00,,0,2020-11-06T10:50:31.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015361,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+1,11991001015431,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-09T04:45:27.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-08T16:00:00.000+00:00,,0,2020-11-09T04:46:54.000+00:00,3,3,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015431,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+1,11991001015441,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-09T09:14:15.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-08T16:00:00.000+00:00,,0,2020-11-09T09:16:32.000+00:00,9,9,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015441,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ [...]
+1,11991001015452,Mtest-11test-11test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11,2020-11-09T10:22:28.000+00:00,2020-11-11T10:47:24.000+00:00,done,test-11test-11,,2020-11-08T16:00:00.000+00:00,2020-11-10T16:00:00.000+00:00,,0,2020-11-11T10:47:24.000+00:00,27,27,0,0,DONE,任务,TASK,0,100,,https://www.tapd.cn/991/prong/stories/view/11991001015452,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_t [...]
+1,11991001015583,test-11test-11test-11test-11test-11test-11test-11,,991,test-11test-11test-11,2020-11-10T03:45:34.000+00:00,2022-06-01T11:53:30.000+00:00,done,test-11test-11test-11,,2020-11-09T16:00:00.000+00:00,2020-11-09T16:00:00.000+00:00,,0,2020-11-10T03:47:30.000+00:00,3,3,0,0,DONE,任务,TASK,11991001001301,100,,https://www.tapd.cn/991/prong/stories/view/11991001015583,0,,,0,0,0,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workitem_types.csv b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workitem_types.csv
index 0edd9ebc7..148f25902 100644
--- a/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workitem_types.csv
+++ b/plugins/tapd/e2e/snapshot_tables/_tool_tapd_workitem_types.csv
@@ -1,5 +1,5 @@
connection_id,id,workspace_id,entity_type,name,english_name,status,color,workflow_id,icon,icon_small,creator,created,modified_by,modified,icon_viper,icon_small_viper,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-1,1146949574001000033,46949574,story,需求,story,3,#3582fb,1146949574001000033,,,TAPD system,2022-07-21T03:34:55.000+00:00,,2022-07-21T03:34:55.000+00:00,https://www.tapd.cn//img/workitem_type/default_icon/@2/story.png,https://www.tapd.cn//img/workitem_type/default_icon/@2/story_small.png,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_workitem_types,4,
-1,1146949574001000034,46949574,story,Techstory,Tech,3,#3582fb,1146949574001000035,46949574/icon/1146949574001000041,46949574/icon/1146949574001000042,郝琳,2022-07-21T06:13:43.000+00:00,郝琳,2022-07-21T06:19:15.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000041.png?token=718c3cd9ce755352ca168bf6875a680762fdfefb13942689afd41da6b4802f1e&version=1658384355&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000042.png?token=b1c5a360123fadbd6e [...]
-1,1146949574001000035,46949574,story,长篇故事,LStory,3,#8ebebe,1146949574001000033,46949574/icon/1146949574001000043,46949574/icon/1146949574001000044,郝琳,2022-07-22T06:17:56.000+00:00,郝琳,2022-07-22T06:18:12.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000043.png?token=9f17a906980a3ea89116d6e75003e6127bf10e6e9a758cffb1e9e8c2a5bb27fd&version=1658470692&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000044.png?token=d0d7885f2029a61149b32 [...]
-1,1146949574001000036,46949574,story,技术债,TDebt,3,#f85e5e,1146949574001000033,46949574/icon/1146949574001000045,46949574/icon/1146949574001000046,郝琳,2022-07-22T06:19:34.000+00:00,郝琳,2022-07-22T06:20:14.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000045.png?token=ecc54ec9e76ac4862b0785e8978a9969939aa17add156d447bfba80976e7acd5&version=1658470814&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000046.png?token=54ae24aa2cebb737006a9a0 [...]
+1,11991001000269,991,story,需求,story,3,#3582fb,1146949574001000033,,,TAPD system,2022-07-21T03:34:55.000+00:00,,2022-07-21T03:34:55.000+00:00,https://www.tapd.cn//img/workitem_type/default_icon/@2/story.png,https://www.tapd.cn//img/workitem_type/default_icon/@2/story_small.png,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_workitem_types,4,
+1,1146949574001000034,991,story,Techstory,Tech,3,#3582fb,1146949574001000035,46949574/icon/1146949574001000041,46949574/icon/1146949574001000042,郝琳,2022-07-21T06:13:43.000+00:00,郝琳,2022-07-21T06:19:15.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000041.png?token=718c3cd9ce755352ca168bf6875a680762fdfefb13942689afd41da6b4802f1e&version=1658384355&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000042.png?token=b1c5a360123fadbd6ea4bc2 [...]
+1,1146949574001000035,991,story,长篇故事,LStory,3,#8ebebe,1146949574001000033,46949574/icon/1146949574001000043,46949574/icon/1146949574001000044,郝琳,2022-07-22T06:17:56.000+00:00,郝琳,2022-07-22T06:18:12.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000043.png?token=9f17a906980a3ea89116d6e75003e6127bf10e6e9a758cffb1e9e8c2a5bb27fd&version=1658470692&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000044.png?token=d0d7885f2029a61149b323450e [...]
+1,1146949574001000036,991,story,技术债,TDebt,3,#f85e5e,1146949574001000033,46949574/icon/1146949574001000045,46949574/icon/1146949574001000046,郝琳,2022-07-22T06:19:34.000+00:00,郝琳,2022-07-22T06:20:14.000+00:00,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000045.png?token=ecc54ec9e76ac4862b0785e8978a9969939aa17add156d447bfba80976e7acd5&version=1658470814&company_id=55850509,https://viper.tapd.cn/icon/files/46949574/icon/1146949574001000046.png?token=54ae24aa2cebb737006a9a0a1b76 [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/issue_bug.csv b/plugins/tapd/e2e/snapshot_tables/issue_bug.csv
new file mode 100644
index 000000000..aa1dae8e8
--- /dev/null
+++ b/plugins/tapd/e2e/snapshot_tables/issue_bug.csv
@@ -0,0 +1,21 @@
+id,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,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
+tapd:TapdBug:1:11991001001025,https://www.tapd.cn/991/prong/stories/view/11991001001025,11991001001025,test-11test-11test-11test-11test-11est-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-02-14T07:14:30.000+00:00,2020-02-13T06:04:29.000+00:00,2020-02-14T08:50:03.000+00:00,1510,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1271,
+tapd:TapdBug:1:11991001001030,https://www.tapd.cn/991/prong/stories/view/11991001001030,11991001001030,test-11test-11test-11t11test-11,,,缺陷,IN_PROGRESS,,0,2020-02-14T07:12:58.000+00:00,2020-02-13T06:33:47.000+00:00,2020-02-17T03:57:42.000+00:00,1479,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1272,
+tapd:TapdBug:1:11991001001031,https://www.tapd.cn/991/prong/stories/view/11991001001031,11991001001031,test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,,0,2020-02-14T08:30:23.000+00:00,2020-02-13T06:45:11.000+00:00,2020-02-17T03:56:58.000+00:00,1545,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1273,
+tapd:TapdBug:1:11991001001032,https://www.tapd.cn/991/prong/stories/view/11991001001032,11991001001032,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-02-13T09:33:17.000+00:00,2020-02-13T06:50:33.000+00:00,2020-02-17T03:56:36.000+00:00,162,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11.,,,normal,,,test-11test-11.,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"": [...]
+tapd:TapdBug:1:11991001001417,https://www.tapd.cn/991/prong/stories/view/11991001001417,11991001001417,test-11test-11-11test-11tesst-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-25T08:01:11.000+00:00,2020-03-04T08:12:14.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1275,
+tapd:TapdBug:1:11991001001418,https://www.tapd.cn/991/prong/stories/view/11991001001418,11991001001418,test-11tesest-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-25T08:04:12.000+00:00,2020-03-04T08:27:29.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1276,
+tapd:TapdBug:1:11991001001420,https://www.tapd.cn/991/prong/stories/view/11991001001420,11991001001420,test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-04T07:41:18.000+00:00,2020-02-25T08:07:04.000+00:00,2020-03-04T08:20:12.000+00:00,11494,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1277,
+tapd:TapdBug:1:11991001001422,https://www.tapd.cn/991/prong/stories/view/11991001001422,11991001001422,test-11te11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-25T08:10:51.000+00:00,2020-03-04T08:12:17.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"": [...]
+tapd:TapdBug:1:11991001001423,https://www.tapd.cn/991/prong/stories/view/11991001001423,11991001001423,test--11test-11test-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-25T08:12:56.000+00:00,2020-03-04T08:25:19.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1279,
+tapd:TapdBug:1:11991001001425,https://www.tapd.cn/991/prong/stories/view/11991001001425,11991001001425,test-11test1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-04T07:41:01.000+00:00,2020-02-25T08:18:40.000+00:00,2020-03-04T08:19:48.000+00:00,11482,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""Co [...]
+tapd:TapdBug:1:11991001001426,https://www.tapd.cn/991/prong/stories/view/11991001001426,11991001001426,test-11test-11te11test-11test-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-25T08:23:39.000+00:00,2020-03-04T08:12:19.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1281,
+tapd:TapdBug:1:11991001001447,https://www.tapd.cn/991/prong/stories/view/11991001001447,11991001001447,IE11 test-11te1test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-17T08:43:28.000+00:00,2020-02-27T03:06:59.000+00:00,2020-03-18T08:24:37.000+00:00,27696,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1282,
+tapd:TapdBug:1:11991001001448,https://www.tapd.cn/991/prong/stories/view/11991001001448,11991001001448,IE11 test-11test-11test-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-02-27T03:14:02.000+00:00,2020-04-27T02:53:11.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1283,
+tapd:TapdBug:1:11991001001450,https://www.tapd.cn/991/prong/stories/view/11991001001450,11991001001450,IE11 tes-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-17T08:43:04.000+00:00,2020-02-27T03:18:04.000+00:00,2020-03-18T08:24:15.000+00:00,27685,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""Con [...]
+tapd:TapdBug:1:11991001001451,https://www.tapd.cn/991/prong/stories/view/11991001001451,11991001001451,IE11 test-11test-11test-st-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-17T08:42:17.000+00:00,2020-02-27T03:36:29.000+00:00,2020-03-18T08:23:08.000+00:00,27665,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1285,
+tapd:TapdBug:1:11991001001710,https://www.tapd.cn/991/prong/stories/view/11991001001710,11991001001710,test-11-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,DONE,已拒绝,0,,2020-03-13T06:14:26.000+00:00,2020-04-01T09:38:36.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1286,
+tapd:TapdBug:1:11991001001711,https://www.tapd.cn/991/prong/stories/view/11991001001711,11991001001711,test-11tesst-11test-11test-11test-11test-11test-11test-11test-11...test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11...test-11,,,缺陷,DONE,已拒绝,0,,2020-03-13T06:20:04.000+00:00,2020-04-01T09:37:52.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,t [...]
+tapd:TapdBug:1:11991001001737,https://www.tapd.cn/991/prong/stories/view/11991001001737,11991001001737,test-11tesst-11test-1test-11test-11test-11test-11test-11test-11test-11,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-26T08:31:05.000+00:00,2020-03-18T07:27:14.000+00:00,2020-03-26T09:02:54.000+00:00,11583,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,,,normal,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1288,
+tapd:TapdBug:1:11991001001739,https://www.tapd.cn/991/prong/stories/view/11991001001739,11991001001739,tt6d3btt52a8tt62a5tt5730tt65b986tt7a7att683c,,,缺陷,IN_PROGRESS,已关闭,0,2020-03-26T08:25:10.000+00:00,2020-03-18T07:32:55.000+00:00,2020-03-26T09:02:37.000+00:00,11572,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:tt90ddtt9a81tt5bb5,,,normal,,,tt90ddtt9a81tt5bb5,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1289,
+tapd:TapdBug:1:11991001001740,https://www.tapd.cn/991/prong/stories/view/11991001001740,11991001001740,tt6d3btt52a8tt6ctt5230tt4e13tt5bb6tt4ecbtt7ecdtt9875,,,缺陷,DONE,已拒绝,0,,2020-03-18T07:37:43.000+00:00,2020-03-25T02:38:34.000+00:00,0,tapd:TapdBug:1:0,medium,0,0,0,tapd:TapdAccount:1:郝骁宵,tapd:TapdAccount:1:郝骁宵,郝骁宵,normal,,,郝骁宵,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_bugs,1290,
diff --git a/plugins/tapd/e2e/snapshot_tables/issues_story.csv b/plugins/tapd/e2e/snapshot_tables/issues_story.csv
index 56dc3b154..9d9fba06c 100644
--- a/plugins/tapd/e2e/snapshot_tables/issues_story.csv
+++ b/plugins/tapd/e2e/snapshot_tables/issues_story.csv
@@ -1,21 +1,21 @@
id,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,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
tapd:TapdStory:1:11991001037563,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:TapdStory:1:11991001037562,3,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1," [...]
-tapd:TapdStory:1:11991001037696,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,"" [...]
+tapd:TapdStory:1:11991001037696,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,,,技术需求债务,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""Compa [...]
tapd:TapdStory:1:11991001037697,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:TapdStory:1:11991001037696,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""Connec [...]
-tapd:TapdStory:1:11991001038322,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:TapdStory:1:0,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_r [...]
-tapd:TapdStory:1:11991001038323,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:TapdStory:1:11991001038322,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_ta [...]
+tapd:TapdStory:1:11991001038322,https://www.tapd.cn/991/prong/stories/view/11991001038322,11991001038322,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,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:TapdStory:1:0,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd [...]
+tapd:TapdStory:1:11991001038323,https://www.tapd.cn/991/prong/stories/view/11991001038323,11991001038323,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,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:TapdStory:1:11991001038322,3,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_ap [...]
tapd:TapdStory:1:11991001038697,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:TapdStory:1:11991001035527,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId" [...]
-tapd:TapdStory:1:11991001038911,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,"""""",,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
-tapd:TapdStory:1:11991001038912,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:TapdStory:1:11991001038911,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,"""""",,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tap [...]
-tapd:TapdStory:1:11991001039664,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11 [...]
+tapd:TapdStory:1:11991001038911,https://www.tapd.cn/991/prong/stories/view/11991001038911,11991001038911,PCtest-11test-11test-11test-11test-11test-11test-11,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,"""""",,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdStory:1:11991001038912,https://www.tapd.cn/991/prong/stories/view/11991001038912,11991001038912,PCtest-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,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:TapdStory:1:11991001038911,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,"""""",,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api [...]
+tapd:TapdStory:1:11991001039664,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,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""Co [...]
tapd:TapdStory:1:11991001039673,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:TapdStory:1:11991001039664,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,t [...]
-tapd:TapdStory:1:11991001040086,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""Workspace [...]
-tapd:TapdStory:1:11991001040088,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:TapdStory:1:11991001040086,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"": [...]
-tapd:TapdStory:1:11991001041163,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0, [...]
+tapd:TapdStory:1:11991001040086,https://www.tapd.cn/991/prong/stories/view/11991001040086,11991001040086,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":99 [...]
+tapd:TapdStory:1:11991001040088,https://www.tapd.cn/991/prong/stories/view/11991001040088,11991001040088,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,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:TapdStory:1:11991001040086,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""W [...]
+tapd:TapdStory:1:11991001041163,https://www.tapd.cn/991/prong/stories/view/11991001041163,11991001041163,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""Works [...]
tapd:TapdStory:1:11991001041164,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:TapdStory:1:11991001041163,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""C [...]
-tapd:TapdStory:1:11991001041165,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,testUnicode9f50testUnicod [...]
-tapd:TapdStory:1:11991001041166,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:TapdStory:1:11991001041165,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,t [...]
-tapd:TapdStory:1:11991001041788,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode6768testUnicode4e39,tapd:TapdAccount: [...]
-tapd:TapdStory:1:11991001041789,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:TapdStory:1:11991001041788,,0,0,0,tapd:TapdAccount:1:testUnicode6768testUnicode4e39,tapd [...]
-tapd:TapdStory:1:11991001041899,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:TapdStory:1:0,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,testUnicode [...]
+tapd:TapdStory:1:11991001041165,https://www.tapd.cn/991/prong/stories/view/11991001041165,11991001041165,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,testUnicode9f50testUnicode9e9f,, [...]
+tapd:TapdStory:1:11991001041166,https://www.tapd.cn/991/prong/stories/view/11991001041166,11991001041166,PCtestUnicode7aefhttpstestUnicode6539testUnicode9020testUnicode5de5testUnicode4f5ctestUnicodeff08testUnicode7b2ctestUnicode516btestUnicode671ftestUnicodeff09,,,EPIC需求,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:TapdStory:1:11991001041165,,0,0,0,tapd:TapdAccount:1:testUnicode9f50testUnicode9e9f,tapd:T [...]
+tapd:TapdStory:1:11991001041788,https://www.tapd.cn/991/prong/stories/view/11991001041788,11991001041788,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,故事需求,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:TapdStory:1:0,,0,0,0,tapd:TapdAccount:1:testUnicode6768testUnicode4e39,tapd:TapdAccount:1:testU [...]
+tapd:TapdStory:1:11991001041789,https://www.tapd.cn/991/prong/stories/view/11991001041789,11991001041789,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,EPIC需求,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:TapdStory:1:11991001041788,,0,0,0,tapd:TapdAccount:1:testUnicode6768testUnicode4e39,tapd:Tapd [...]
+tapd:TapdStory:1:11991001041899,https://www.tapd.cn/991/prong/stories/view/11991001041899,11991001041899,2021testUnicode8d22testUnicode7ecftestUnicode98cetestUnicode4e91testUnicode699c,,,故事需求,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:TapdStory:1:0,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,testUnicode5218tes [...]
tapd:TapdStory:1:11991001041900,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:TapdStory:1:11991001041899,3,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,t [...]
diff --git a/plugins/tapd/e2e/snapshot_tables/issues_task.csv b/plugins/tapd/e2e/snapshot_tables/issues_task.csv
index b24282280..f14cf46b4 100644
--- a/plugins/tapd/e2e/snapshot_tables/issues_task.csv
+++ b/plugins/tapd/e2e/snapshot_tables/issues_task.csv
@@ -1,16 +1,16 @@
id,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,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark
-tapd:TapdTask:1:11991001015107,https://www.tapd.cn/991/prong/stories/view/11991001015107,11991001015107,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-03T09:53:39.000+00:00,2020-11-03T09:52:00.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4339,
-tapd:TapdTask:1:11991001015121,https://www.tapd.cn/991/prong/stories/view/11991001015121,11991001015121,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-03T10:40:17.000+00:00,2020-11-03T10:39:57.000+00:00,2020-11-03T10:40:17.000+00:00,0,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11;,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11;,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4340,
-tapd:TapdTask:1:11991001015142,https://www.tapd.cn/991/prong/stories/view/11991001015142,11991001015142,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-03T11:00:18.000+00:00,2020-11-03T10:58:43.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
-tapd:TapdTask:1:11991001015184,https://www.tapd.cn/991/prong/stories/view/11991001015184,11991001015184,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-04T09:14:22.000+00:00,2020-11-04T09:12:11.000+00:00,2022-06-01T11:53:30.000+00:00,2,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4342,
-tapd:TapdTask:1:11991001015203,https://www.tapd.cn/991/prong/stories/view/11991001015203,11991001015203,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-04T10:38:54.000+00:00,2020-11-04T10:38:10.000+00:00,2022-06-01T11:53:30.000+00:00,0,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
-tapd:TapdTask:1:11991001015207,https://www.tapd.cn/991/prong/stories/view/11991001015207,11991001015207,pctest-11test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-10T11:01:47.000+00:00,2020-11-04T10:43:02.000+00:00,2020-11-10T11:01:47.000+00:00,8658,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4344,
-tapd:TapdTask:1:11991001015253,https://www.tapd.cn/991/prong/stories/view/11991001015253,11991001015253,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-05T08:50:55.000+00:00,2020-11-05T08:49:42.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4345,
-tapd:TapdTask:1:11991001015307,https://www.tapd.cn/991/prong/stories/view/11991001015307,11991001015307,Mtest-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-06T11:03:43.000+00:00,2020-11-05T11:12:13.000+00:00,2020-11-06T11:03:43.000+00:00,1431,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4346,
-tapd:TapdTask:1:11991001015309,https://www.tapd.cn/991/prong/stories/view/11991001015309,11991001015309,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-05T11:16:00.000+00:00,2020-11-05T11:14:41.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
-tapd:TapdTask:1:11991001015340,https://www.tapd.cn/991/prong/stories/view/11991001015340,11991001015340,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-06T09:12:19.000+00:00,2020-11-06T09:10:44.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4348,
-tapd:TapdTask:1:11991001015361,https://www.tapd.cn/991/prong/stories/view/11991001015361,11991001015361,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-06T10:50:31.000+00:00,2020-11-06T10:49:54.000+00:00,2022-06-01T11:53:30.000+00:00,0,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
-tapd:TapdTask:1:11991001015431,https://www.tapd.cn/991/prong/stories/view/11991001015431,11991001015431,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-09T04:46:54.000+00:00,2020-11-09T04:45:27.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
-tapd:TapdTask:1:11991001015441,https://www.tapd.cn/991/prong/stories/view/11991001015441,11991001015441,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-09T09:16:32.000+00:00,2020-11-09T09:14:15.000+00:00,2022-06-01T11:53:30.000+00:00,2,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4351,
-tapd:TapdTask:1:11991001015452,https://www.tapd.cn/991/prong/stories/view/11991001015452,11991001015452,Mtest-11test-11test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-11T10:47:24.000+00:00,2020-11-09T10:22:28.000+00:00,2020-11-11T10:47:24.000+00:00,2904,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4352,
-tapd:TapdTask:1:11991001015583,https://www.tapd.cn/991/prong/stories/view/11991001015583,11991001015583,test-11test-11test-11test-11test-11test-11test-11,,,TASK,DONE,done,0,2020-11-10T03:47:30.000+00:00,2020-11-10T03:45:34.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ [...]
+tapd:TapdTask:1:11991001015107,https://www.tapd.cn/991/prong/stories/view/11991001015107,11991001015107,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-03T09:53:39.000+00:00,2020-11-03T09:52:00.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4339,
+tapd:TapdTask:1:11991001015121,https://www.tapd.cn/991/prong/stories/view/11991001015121,11991001015121,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-03T10:40:17.000+00:00,2020-11-03T10:39:57.000+00:00,2020-11-03T10:40:17.000+00:00,0,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11;,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11;,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4340,
+tapd:TapdTask:1:11991001015142,https://www.tapd.cn/991/prong/stories/view/11991001015142,11991001015142,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-03T11:00:18.000+00:00,2020-11-03T10:58:43.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdTask:1:11991001015184,https://www.tapd.cn/991/prong/stories/view/11991001015184,11991001015184,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-04T09:14:22.000+00:00,2020-11-04T09:12:11.000+00:00,2022-06-01T11:53:30.000+00:00,2,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4342,
+tapd:TapdTask:1:11991001015203,https://www.tapd.cn/991/prong/stories/view/11991001015203,11991001015203,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-04T10:38:54.000+00:00,2020-11-04T10:38:10.000+00:00,2022-06-01T11:53:30.000+00:00,0,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdTask:1:11991001015207,https://www.tapd.cn/991/prong/stories/view/11991001015207,11991001015207,pctest-11test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-10T11:01:47.000+00:00,2020-11-04T10:43:02.000+00:00,2020-11-10T11:01:47.000+00:00,8658,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4344,
+tapd:TapdTask:1:11991001015253,https://www.tapd.cn/991/prong/stories/view/11991001015253,11991001015253,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-05T08:50:55.000+00:00,2020-11-05T08:49:42.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4345,
+tapd:TapdTask:1:11991001015307,https://www.tapd.cn/991/prong/stories/view/11991001015307,11991001015307,Mtest-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-06T11:03:43.000+00:00,2020-11-05T11:12:13.000+00:00,2020-11-06T11:03:43.000+00:00,1431,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4346,
+tapd:TapdTask:1:11991001015309,https://www.tapd.cn/991/prong/stories/view/11991001015309,11991001015309,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-05T11:16:00.000+00:00,2020-11-05T11:14:41.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdTask:1:11991001015340,https://www.tapd.cn/991/prong/stories/view/11991001015340,11991001015340,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-06T09:12:19.000+00:00,2020-11-06T09:10:44.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4348,
+tapd:TapdTask:1:11991001015361,https://www.tapd.cn/991/prong/stories/view/11991001015361,11991001015361,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-06T10:50:31.000+00:00,2020-11-06T10:49:54.000+00:00,2022-06-01T11:53:30.000+00:00,0,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdTask:1:11991001015431,https://www.tapd.cn/991/prong/stories/view/11991001015431,11991001015431,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-09T04:46:54.000+00:00,2020-11-09T04:45:27.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
+tapd:TapdTask:1:11991001015441,https://www.tapd.cn/991/prong/stories/view/11991001015441,11991001015441,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-09T09:16:32.000+00:00,2020-11-09T09:14:15.000+00:00,2022-06-01T11:53:30.000+00:00,2,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4351,
+tapd:TapdTask:1:11991001015452,https://www.tapd.cn/991/prong/stories/view/11991001015452,11991001015452,Mtest-11test-11test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-11T10:47:24.000+00:00,2020-11-09T10:22:28.000+00:00,2020-11-11T10:47:24.000+00:00,2904,tapd:TapdTask:1:0,,0,0,0,tapd:TapdAccount:1:test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,,test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4352,
+tapd:TapdTask:1:11991001015583,https://www.tapd.cn/991/prong/stories/view/11991001015583,11991001015583,test-11test-11test-11test-11test-11test-11test-11,,,任务,DONE,done,0,2020-11-10T03:47:30.000+00:00,2020-11-10T03:45:34.000+00:00,2022-06-01T11:53:30.000+00:00,1,tapd:TapdTask:1:11991001001301,,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-11,,,,test-11test-11test-11,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_ra [...]
diff --git a/plugins/tapd/e2e/stories_test.go b/plugins/tapd/e2e/stories_test.go
index 37e6159c5..4a0956d5e 100644
--- a/plugins/tapd/e2e/stories_test.go
+++ b/plugins/tapd/e2e/stories_test.go
@@ -38,28 +38,20 @@ func TestTapdStoryDataFlow(t *testing.T) {
ConnectionId: 1,
CompanyId: 99,
WorkspaceId: 991,
+ TransformationRules: tasks.TransformationRules{
+ TypeMappings: map[string]tasks.TypeMapping{
+ "BUG": {StandardType: "缺陷"},
+ "TASK": {StandardType: "任务"},
+ "需求": {StandardType: "故事需求"},
+ "技术债": {StandardType: "技术需求债务"},
+ "长篇故事": {StandardType: "Epic需求"},
+ },
+ },
},
}
- 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",
- e2ehelper.ColumnWithRawData(
- "connection_id",
- "workspace_id",
- "english_name",
- "chinese_name",
- "is_last_step",
- ),
- )
+
+ dataflowTester.ImportCsvIntoTabler("./raw_tables/_tool_tapd_workitem_types.csv", &models.TapdWorkitemType{})
+ dataflowTester.ImportCsvIntoTabler("./raw_tables/_tool_tapd_story_statuses.csv", &models.TapdStoryStatus{})
// import raw data table
dataflowTester.ImportCsvIntoRawTable("./raw_tables/_raw_tapd_api_stories.csv",
diff --git a/plugins/tapd/e2e/story_and_bug_status_test.go b/plugins/tapd/e2e/story_and_bug_status_test.go
index 8cfc09df0..7cd10016c 100644
--- a/plugins/tapd/e2e/story_and_bug_status_test.go
+++ b/plugins/tapd/e2e/story_and_bug_status_test.go
@@ -42,7 +42,8 @@ func TestTapdStoryAndBugStatusDataFlow(t *testing.T) {
// import raw data table
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.TapdStoryStatus{})
dataflowTester.Subtask(tasks.ExtractStoryStatusMeta, taskData)
@@ -63,7 +64,8 @@ func TestTapdStoryAndBugStatusDataFlow(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)
diff --git a/plugins/tapd/e2e/tasks_test.go b/plugins/tapd/e2e/tasks_test.go
index 6d13bcf4f..ca731b496 100644
--- a/plugins/tapd/e2e/tasks_test.go
+++ b/plugins/tapd/e2e/tasks_test.go
@@ -38,6 +38,12 @@ func TestTapdTaskDataFlow(t *testing.T) {
ConnectionId: 1,
CompanyId: 99,
WorkspaceId: 991,
+ TransformationRules: tasks.TransformationRules{
+ TypeMappings: map[string]tasks.TypeMapping{
+ "BUG": {StandardType: "缺陷"},
+ "TASK": {StandardType: "任务"},
+ },
+ },
},
}
// import raw data table
diff --git a/plugins/tapd/tasks/bug_extractor.go b/plugins/tapd/tasks/bug_extractor.go
index bc2f79d10..8b3cfdbf3 100644
--- a/plugins/tapd/tasks/bug_extractor.go
+++ b/plugins/tapd/tasks/bug_extractor.go
@@ -48,7 +48,7 @@ func ExtractBugs(taskCtx core.SubTaskContext) errors.Error {
return err
}
customStatusMap := getStatusMapping(data)
-
+ stdTypeMappings := getStdTypeMappings(data)
extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
RawDataSubTaskArgs: *rawDataSubTaskArgs,
BatchSize: 100,
@@ -64,8 +64,11 @@ func ExtractBugs(taskCtx core.SubTaskContext) errors.Error {
toolL.Status = statusLanguageMap[toolL.Status]
toolL.ConnectionId = data.Options.ConnectionId
- toolL.Type = toolL.Bugtype
- toolL.StdType = ticket.BUG
+ toolL.Type = "BUG"
+ toolL.StdType = stdTypeMappings[toolL.Type]
+ if toolL.StdType == "" {
+ toolL.StdType = ticket.BUG
+ }
if len(customStatusMap) != 0 {
toolL.StdStatus = customStatusMap[toolL.Status]
} else {
diff --git a/plugins/tapd/tasks/shared.go b/plugins/tapd/tasks/shared.go
index 5b3620593..003d5e5f1 100644
--- a/plugins/tapd/tasks/shared.go
+++ b/plugins/tapd/tasks/shared.go
@@ -160,7 +160,8 @@ func CreateRawDataSubTaskArgs(taskCtx core.SubTaskContext, rawTable string, useC
return rawDataSubTaskArgs, &filteredData
}
-func getTypeMappings(data *TapdTaskData, db dal.Dal, system string) (*typeMappings, errors.Error) {
+// getTapdTypeMappings will map story types in _tool_tapd_workitem_types to our typeMapping
+func getTapdTypeMappings(data *TapdTaskData, db dal.Dal, system string) (map[uint64]string, errors.Error) {
typeIdMapping := make(map[uint64]string)
issueTypes := make([]models.TapdWorkitemType, 0)
clauses := []dal.Clause{
@@ -175,14 +176,15 @@ func getTypeMappings(data *TapdTaskData, db dal.Dal, system string) (*typeMappin
for _, issueType := range issueTypes {
typeIdMapping[issueType.Id] = issueType.Name
}
+ return typeIdMapping, nil
+}
+
+func getStdTypeMappings(data *TapdTaskData) map[string]string {
stdTypeMappings := make(map[string]string)
for userType, stdType := range data.Options.TransformationRules.TypeMappings {
stdTypeMappings[userType] = strings.ToUpper(stdType.StandardType)
}
- return &typeMappings{
- typeIdMappings: typeIdMapping,
- stdTypeMappings: stdTypeMappings,
- }, nil
+ return stdTypeMappings
}
func getStatusMapping(data *TapdTaskData) map[string]string {
diff --git a/plugins/tapd/tasks/story_changelog_converter.go b/plugins/tapd/tasks/story_changelog_converter.go
index 5e79d2fc3..e234a2768 100644
--- a/plugins/tapd/tasks/story_changelog_converter.go
+++ b/plugins/tapd/tasks/story_changelog_converter.go
@@ -68,7 +68,7 @@ func ConvertStoryChangelog(taskCtx core.SubTaskContext) errors.Error {
logger.Info("convert changelog :%d", data.Options.WorkspaceId)
clIdGen := didgen.NewDomainIdGenerator(&models.TapdStoryChangelog{})
issueIdGen := didgen.NewDomainIdGenerator(&models.TapdStory{})
-
+ stdTypeMappings := getStdTypeMappings(data)
clauses := []dal.Clause{
dal.Select("tc.created, tc.id, tc.workspace_id, tc.story_id, tc.creator, _tool_tapd_story_changelog_items.*"),
dal.From(&models.TapdStoryChangelogItem{}),
@@ -110,7 +110,15 @@ func ConvertStoryChangelog(taskCtx core.SubTaskContext) errors.Error {
domainCl.ToValue = getStdStatus(domainCl.OriginalToValue)
}
}
-
+ if domainCl.FieldName == "workitem_type_id" {
+ // As OriginalFromValue is value_before_parsed, so we don't need to transform id to name
+ if stdTypeMappings[domainCl.OriginalFromValue] != "" {
+ domainCl.FromValue = stdTypeMappings[domainCl.OriginalFromValue]
+ }
+ if stdTypeMappings[domainCl.OriginalToValue] != "" {
+ domainCl.ToValue = stdTypeMappings[domainCl.OriginalToValue]
+ }
+ }
return []interface{}{
domainCl,
}, nil
diff --git a/plugins/tapd/tasks/story_extractor.go b/plugins/tapd/tasks/story_extractor.go
index d7c28550a..994b22f33 100644
--- a/plugins/tapd/tasks/story_extractor.go
+++ b/plugins/tapd/tasks/story_extractor.go
@@ -48,7 +48,8 @@ func ExtractStories(taskCtx core.SubTaskContext) errors.Error {
return err
}
customStatusMap := getStatusMapping(data)
- typeMap, err := getTypeMappings(data, db, "story")
+ stdTypeMappings := getStdTypeMappings(data)
+ typeIdMapping, err := getTapdTypeMappings(data, db, "story")
if err != nil {
return err
}
@@ -73,8 +74,8 @@ func ExtractStories(taskCtx core.SubTaskContext) errors.Error {
toolL.ConnectionId = data.Options.ConnectionId
- toolL.Type = typeMap.typeIdMappings[toolL.WorkitemTypeId]
- toolL.StdType = typeMap.stdTypeMappings[toolL.Type]
+ toolL.Type = typeIdMapping[toolL.WorkitemTypeId]
+ toolL.StdType = stdTypeMappings[toolL.Type]
if toolL.StdType == "" {
toolL.StdType = ticket.REQUIREMENT
}
@@ -121,8 +122,3 @@ func ExtractStories(taskCtx core.SubTaskContext) errors.Error {
return extractor.Execute()
}
-
-type typeMappings struct {
- typeIdMappings map[uint64]string
- stdTypeMappings map[string]string
-}
diff --git a/plugins/tapd/tasks/task_extractor.go b/plugins/tapd/tasks/task_extractor.go
index 9cb3585a6..b1db7f9bc 100644
--- a/plugins/tapd/tasks/task_extractor.go
+++ b/plugins/tapd/tasks/task_extractor.go
@@ -50,6 +50,7 @@ func ExtractTasks(taskCtx core.SubTaskContext) errors.Error {
return ticket.TODO
}
}
+ stdTypeMappings := getStdTypeMappings(data)
extractor, err := helper.NewApiExtractor(helper.ApiExtractorArgs{
RawDataSubTaskArgs: *rawDataSubTaskArgs,
BatchSize: 100,
@@ -66,7 +67,10 @@ func ExtractTasks(taskCtx core.SubTaskContext) errors.Error {
toolL.ConnectionId = data.Options.ConnectionId
toolL.Type = "TASK"
- toolL.StdType = ticket.TASK
+ toolL.StdType = stdTypeMappings[toolL.Type]
+ if toolL.StdType == "" {
+ toolL.StdType = ticket.TASK
+ }
toolL.StdStatus = getTaskStdStatus(toolL.Status)
if strings.Contains(toolL.Owner, ";") {
toolL.Owner = strings.Split(toolL.Owner, ";")[0]