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 a72aa2af7 fix(tapd): fix issue 4731 (#4733)
a72aa2af7 is described below

commit a72aa2af78951212cd121e2169f63ff667e414ca
Author: Warren Chen <[email protected]>
AuthorDate: Wed Mar 22 13:57:47 2023 +0800

    fix(tapd): fix issue 4731 (#4733)
---
 backend/helpers/e2ehelper/data_flow_tester.go      |  6 ++++
 backend/plugins/tapd/e2e/bugs_test.go              |  4 +++
 .../tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv     |  4 +--
 .../tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv   | 40 ++++++++++-----------
 .../plugins/tapd/e2e/snapshot_tables/issue_bug.csv | 40 ++++++++++-----------
 .../tapd/e2e/snapshot_tables/issues_story.csv      | 42 +++++++++++-----------
 .../tapd/e2e/snapshot_tables/issues_task.csv       | 32 ++++++++---------
 backend/plugins/tapd/e2e/stories_test.go           | 38 ++++----------------
 backend/plugins/tapd/e2e/tasks_test.go             | 37 +++----------------
 backend/plugins/tapd/tasks/bug_extractor.go        |  1 -
 10 files changed, 100 insertions(+), 144 deletions(-)

diff --git a/backend/helpers/e2ehelper/data_flow_tester.go 
b/backend/helpers/e2ehelper/data_flow_tester.go
index f768ce7ae..4e99e590a 100644
--- a/backend/helpers/e2ehelper/data_flow_tester.go
+++ b/backend/helpers/e2ehelper/data_flow_tester.go
@@ -247,6 +247,12 @@ func (t *DataFlowTester) CreateSnapshot(dst schema.Tabler, 
opts TableOptions) {
        if err != nil {
                panic(err)
        }
+       for i := 0; i < len(pkColumnNames); i++ {
+               group := strings.Split(pkColumnNames[i], ".")
+               if len(group) > 1 {
+                       pkColumnNames[i] = group[len(group)-1]
+               }
+       }
        allFields := append(pkColumnNames, targetFields...)
        allFields = utils.StringsUniq(allFields)
        dbCursor, err := t.Dal.Cursor(
diff --git a/backend/plugins/tapd/e2e/bugs_test.go 
b/backend/plugins/tapd/e2e/bugs_test.go
index cf85f89f7..15d99c626 100644
--- a/backend/plugins/tapd/e2e/bugs_test.go
+++ b/backend/plugins/tapd/e2e/bugs_test.go
@@ -41,6 +41,10 @@ func TestTapdBugDataFlow(t *testing.T) {
                                        "BUG":  {StandardType: "缺陷"},
                                        "TASK": {StandardType: "任务"},
                                },
+                               StatusMappings: map[string]tasks.OriginalStatus{
+                                       "完成":  []string{"已关闭"},
+                                       "处理中": []string{"接受/处理"},
+                               },
                        },
                },
        }
diff --git a/backend/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv 
b/backend/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
index 06c547a9f..ea6e72b86 100644
--- a/backend/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
+++ b/backend/plugins/tapd/e2e/raw_tables/_raw_tapd_api_bugs.csv
@@ -1,7 +1,7 @@
 id,params,data,url,input,created_at
 
1271,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001025"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11est-11test-11test-11"",""description"":""<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
 [...]
-1272,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001030"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11t11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  \/><\/div><div>test-11test-11test-11test-11test-11<\/div> [...]
-1273,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001031"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  \/><\/div><div>test-11test-11test-11tes [...]
+1272,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001030"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11t11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  \/><\/div><div>test-11test-11test-11test-11test-11<\/div> [...]
+1273,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001031"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  \/><\/div><div>test-11test-11test-11tes [...]
 
1274,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001032"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11
 [...]
 
1275,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001417"",""sid"":""0"",""parent_id"":null,""title"":""test-11test-11-11test-11tesst-11test-11test-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  \/><\/div><div [...]
 
1276,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}","{""Bug"":{""id"":""11991001001418"",""sid"":""0"",""parent_id"":null,""title"":""test-11tesest-11test-11"",""description"":""<div>test-11test-11test-11test-11test-11<\/div><div>1test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11<\/div><div>2test-11test-11test-11test-11test-11test-11test-11<\/div><div><br
  
\/><\/div><div>test-11test-11test-11test-11test-11<\/div><div>test-11test-11test-11test-11tes
 [...]
diff --git a/backend/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv 
b/backend/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
index 6f8526717..d7cb84506 100644
--- a/backend/plugins/tapd/e2e/snapshot_tables/_tool_tapd_bugs.csv
+++ b/backend/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/backend/plugins/tapd/e2e/snapshot_tables/issue_bug.csv 
b/backend/plugins/tapd/e2e/snapshot_tables/issue_bug.csv
index 5a97a6229..c68b2b551 100644
--- a/backend/plugins/tapd/e2e/snapshot_tables/issue_bug.csv
+++ b/backend/plugins/tapd/e2e/snapshot_tables/issue_bug.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:TapdBug:1:11991001001025,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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,""Workspa
 [...]
-tapd:TapdBug:1:11991001001417,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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,""Compa
 [...]
-tapd:TapdBug:1:11991001001423,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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
 [...]
-tapd:TapdBug:1:11991001001426,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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,
 [...]
-tapd:TapdBug:1:11991001001451,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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_ap
 [...]
-tapd:TapdBug:1:11991001001711,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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-11te
 [...]
-tapd:TapdBug:1:11991001001737,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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/bugtrace/bugs/view?bug_id=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,
+tapd:TapdBug:1:11991001001025,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=11991001001025,11991001001025,test-11test-11test-11test-11test-11est-11test-11test-11,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001030,11991001001030,test-11test-11test-11t11test-11,,,缺陷,处理中,接受/处理,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/bugtrace/bugs/view?bug_id=11991001001031,11991001001031,test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,处理中,接受/处理,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/bugtrace/bugs/view?bug_id=11991001001032,11991001001032,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,完成,已关闭,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"":99
 [...]
+tapd:TapdBug:1:11991001001417,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=11991001001417,11991001001417,test-11test-11-11test-11tesst-11test-11test-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=11991001001418,11991001001418,test-11tesest-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=11991001001420,11991001001420,test-11test-11test-11test-11test-11,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001422,11991001001422,test-11te11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=11991001001423,11991001001423,test--11test-11test-11test-11test-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=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,,,缺陷,完成,已关闭,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,"{""Conn
 [...]
+tapd:TapdBug:1:11991001001426,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=11991001001426,11991001001426,test-11test-11te11test-11test-11test-11test-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=11991001001447,11991001001447,IE11
 
test-11te1test-11test-11test-11,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001448,11991001001448,IE11
 
test-11test-11test-11test-11test-11test-11,,,缺陷,,已拒绝,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/bugtrace/bugs/view?bug_id=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,,,缺陷,完成,已关闭,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,"{""Conne
 [...]
+tapd:TapdBug:1:11991001001451,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=11991001001451,11991001001451,IE11
 
test-11test-11test-st-11test-11,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001710,11991001001710,test-11-11test-11test-11test-11test-11test-11test-11test-11test-11,,,缺陷,,已拒绝,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_bu
 [...]
+tapd:TapdBug:1:11991001001711,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=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,,,缺陷,,已拒绝,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-1
 [...]
+tapd:TapdBug:1:11991001001737,https://www.tapd.cn/991/bugtrace/bugs/view?bug_id=11991001001737,11991001001737,test-11tesst-11test-1test-11test-11test-11test-11test-11test-11test-11,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001739,11991001001739,tt6d3btt52a8tt62a5tt5730tt65b986tt7a7att683c,,,缺陷,完成,已关闭,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/bugtrace/bugs/view?bug_id=11991001001740,11991001001740,tt6d3btt52a8tt6ctt5230tt4e13tt5bb6tt4ecbtt7ecdtt9875,,,缺陷,,已拒绝,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/backend/plugins/tapd/e2e/snapshot_tables/issues_story.csv 
b/backend/plugins/tapd/e2e/snapshot_tables/issues_story.csv
index 0fe1a7d24..0cd8403d3 100644
--- a/backend/plugins/tapd/e2e/snapshot_tables/issues_story.csv
+++ b/backend/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,Middle,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";
 [...]
-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,,,故事需求,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,Middle,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: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,Middle,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: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,,,故事需求,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,,,故事需求,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,,,故事需求,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,Middle,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,testUnicode52
 [...]
-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,Middle,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6615,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testUnicode6
 [...]
+id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,url,icon_url,issue_key,title,description,epic_key,type,original_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,creator_name,assignee_id,assignee_name,severity,component,original_project
+tapd:TapdStory:1:11991001037563,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,1,,https://www.tapd.cn/991/prong/stories/view/11991001037563,,11991001037563,test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-09-29T09:54:01.000+00:00,2021-08-30T07:59:44.000+00:00,2021-09-29T09:54:01.000+00:00,43314,tapd:TapdStory:1:11991001037562,Middle,0,0,0,tapd:TapdAccount:1:test-11test-11test-11,test-11test-11test-
 [...]
+tapd:TapdStory:1:11991001037696,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,2,,https://www.tapd.cn/991/prong/stories/view/11991001037696,,11991001037696,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,技术债,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,test-1
 [...]
+tapd:TapdStory:1:11991001037697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,3,,https://www.tapd.cn/991/prong/stories/view/11991001037697,,11991001037697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-09-03T08:13:35.000+00:00,2021-08-31T07:27:52.000+00:00,2021-09-03T08:13:35.000+00:00,4365,tapd:TapdStory:1:11991001037696,,0,0,0,tapd:TapdAccount:1:test-1
 [...]
+tapd:TapdStory:1:11991001038322,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,4,,https://www.tapd.cn/991/prong/stories/view/11991001038322,,11991001038322,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,需求,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,Middle,0,0,0,tapd:TapdAccount:1:test-11test-11,test-11test-11,tapd:TapdAccount:1:test-11t
 [...]
+tapd:TapdStory:1:11991001038323,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,5,,https://www.tapd.cn/991/prong/stories/view/11991001038323,,11991001038323,PCtest-11test-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,技术债,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,Middle,0,0,0,tapd:TapdAccount:1:test-11test-11,test-11test-11,tapd:TapdAccount:1:test-11tes
 [...]
+tapd:TapdStory:1:11991001038697,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,6,,https://www.tapd.cn/991/prong/stories/view/11991001038697,,11991001038697,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-09-13T02:24:50.000+00:00,2021-09-10T07:15:37.000+00:00,2021-09-13T02:24:50.000+00:00,4029,tapd:TapdStory:1:11991001035527,,0,0,0,tapd:TapdAccount:1:test-11test-1
 [...]
+tapd:TapdStory:1:11991001038911,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,7,,https://www.tapd.cn/991/prong/stories/view/11991001038911,,11991001038911,PCtest-11test-11test-11test-11test-11test-11test-11,,,故事需求,需求,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,test-11test-11,tapd:TapdAccount:1:test-11test-1
 [...]
+tapd:TapdStory:1:11991001038912,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,8,,https://www.tapd.cn/991/prong/stories/view/11991001038912,,11991001038912,PCtest-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,技术债,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11
 [...]
+tapd:TapdStory:1:11991001039664,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,9,,https://www.tapd.cn/991/prong/stories/view/11991001039664,,11991001039664,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,需求,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:
 [...]
+tapd:TapdStory:1:11991001039673,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,10,,https://www.tapd.cn/991/prong/stories/view/11991001039673,,11991001039673,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-10-08T06:31:35.000+00:00,2021-09-24T09:31:03.000+00:00,2021-10-08T06:31:35.000+00:00,19980,tapd:TapdStory:1:11991001039664,,0,0,0,
 [...]
+tapd:TapdStory:1:11991001040086,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,11,,https://www.tapd.cn/991/prong/stories/view/11991001040086,,11991001040086,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,需求,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,test-11test-11,tapd:TapdAccount:1
 [...]
+tapd:TapdStory:1:11991001040088,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,12,,https://www.tapd.cn/991/prong/stories/view/11991001040088,,11991001040088,PCtest-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,技术需求债务,技术债,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,test-11test-11,ta
 [...]
+tapd:TapdStory:1:11991001041163,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,13,,https://www.tapd.cn/991/prong/stories/view/11991001041163,,11991001041163,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,故事需求,需求,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,test-11test-11,tapd:Ta
 [...]
+tapd:TapdStory:1:11991001041164,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,14,,https://www.tapd.cn/991/prong/stories/view/11991001041164,,11991001041164,test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11test-11,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-10-21T01:30:40.000+00:00,2021-10-19T08:12:26.000+00:00,2021-10-21T01:30:41.000+00:00,2478,tapd:TapdStory:1:11991001041163,,0,0,0,tapd:TapdAccount:1:test-11test-11,test
 [...]
+tapd:TapdStory:1:11991001041165,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,15,,https://www.tapd.cn/991/prong/stories/view/11991001041165,,11991001041165,PCtest-11test-11test-11test-11test-11test-11test-11testUnicode516btestUnicode671ftestUnicodeff09,,,故事需求,需求,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:testUnicode9f50testUnico
 [...]
+tapd:TapdStory:1:11991001041166,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,16,,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
 [...]
+tapd:TapdStory:1:11991001041788,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,17,,https://www.tapd.cn/991/prong/stories/view/11991001041788,,11991001041788,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,故事需求,需求,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:TapdSt
 [...]
+tapd:TapdStory:1:11991001041789,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,18,,https://www.tapd.cn/991/prong/stories/view/11991001041789,,11991001041789,testUnicode300atestUnicode777ftestUnicode89c1testUnicode300btestUnicode680ftestUnicode76eetestUnicode9875testUnicodeff08pc&mtestUnicode7ad9testUnicodeff09,,,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:Ta
 [...]
+tapd:TapdStory:1:11991001041899,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,19,,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,Middle,0,0,0,tapd:TapdAccount:1:testUnicode5218testUnicode5b87testU
 [...]
+tapd:TapdStory:1:11991001041900,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_stories,20,,https://www.tapd.cn/991/prong/stories/view/11991001041900,,11991001041900,testUnicode4e3btestUnicode8bbatestUnicode575b-testUnicode4f1atestUnicode524d,,,REQUIREMENT,,IN_PROGRESS,test111test111,0,2021-12-20T01:51:36.000+00:00,2021-10-28T02:58:07.000+00:00,2021-12-20T01:51:36.000+00:00,76253,tapd:TapdStory:1:11991001041899,Middle,0,0,0,tapd:TapdAccount:1:testUnicode5218testU
 [...]
diff --git a/backend/plugins/tapd/e2e/snapshot_tables/issues_task.csv 
b/backend/plugins/tapd/e2e/snapshot_tables/issues_task.csv
index f14cf46b4..6fe42f954 100644
--- a/backend/plugins/tapd/e2e/snapshot_tables/issues_task.csv
+++ b/backend/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,,,任务,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
 [...]
+id,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,url,icon_url,issue_key,title,description,epic_key,type,original_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,creator_name,assignee_id,assignee_name,severity,component,original_project
+tapd:TapdTask:1:11991001015107,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4339,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015121,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4340,,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;,test-11test-11;,tapd:TapdAccount:1:test-11test-11,test-11
 [...]
+tapd:TapdTask:1:11991001015142,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4341,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
+tapd:TapdTask:1:11991001015184,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4342,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015203,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4343,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
+tapd:TapdTask:1:11991001015207,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4344,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015253,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4345,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015307,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4346,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015309,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4347,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
+tapd:TapdTask:1:11991001015340,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4348,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015361,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4349,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
+tapd:TapdTask:1:11991001015431,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4350,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
+tapd:TapdTask:1:11991001015441,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4351,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015452,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4352,,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,test-11test-11,tapd:TapdAccount:1:test-11test-11,test-11test-11,,,
+tapd:TapdTask:1:11991001015583,"{""ConnectionId"":1,""CompanyId"":0,""WorkspaceId"":991}",_raw_tapd_api_tasks,4353,,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,test-11test-11test-11,tapd:TapdAccount:1:test-11test-11test
 [...]
diff --git a/backend/plugins/tapd/e2e/stories_test.go 
b/backend/plugins/tapd/e2e/stories_test.go
index d57530995..0c1c69271 100644
--- a/backend/plugins/tapd/e2e/stories_test.go
+++ b/backend/plugins/tapd/e2e/stories_test.go
@@ -18,6 +18,7 @@ limitations under the License.
 package e2e
 
 import (
+       "github.com/apache/incubator-devlake/core/models/common"
        "github.com/apache/incubator-devlake/core/models/domainlayer/ticket"
        "github.com/apache/incubator-devlake/helpers/e2ehelper"
        "github.com/apache/incubator-devlake/plugins/tapd/impl"
@@ -205,38 +206,11 @@ func TestTapdStoryDataFlow(t *testing.T) {
        dataflowTester.FlushTabler(&ticket.SprintIssue{})
        dataflowTester.FlushTabler(&ticket.IssueLabel{})
        dataflowTester.Subtask(tasks.ConvertStoryMeta, taskData)
-       dataflowTester.VerifyTable(
-               ticket.Issue{},
-               "./snapshot_tables/issues_story.csv",
-               e2ehelper.ColumnWithRawData(
-                       "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",
-               ),
-       )
+       dataflowTester.VerifyTableWithOptions(&ticket.Issue{}, 
e2ehelper.TableOptions{
+               CSVRelPath:  "./snapshot_tables/issues_story.csv",
+               IgnoreTypes: []interface{}{common.Model{}},
+       })
+
        dataflowTester.VerifyTable(
                ticket.BoardIssue{},
                "./snapshot_tables/board_issues_story.csv",
diff --git a/backend/plugins/tapd/e2e/tasks_test.go 
b/backend/plugins/tapd/e2e/tasks_test.go
index 728ac0a1f..65731ec91 100644
--- a/backend/plugins/tapd/e2e/tasks_test.go
+++ b/backend/plugins/tapd/e2e/tasks_test.go
@@ -18,6 +18,7 @@ limitations under the License.
 package e2e
 
 import (
+       "github.com/apache/incubator-devlake/core/models/common"
        "github.com/apache/incubator-devlake/core/models/domainlayer/ticket"
        "github.com/apache/incubator-devlake/helpers/e2ehelper"
        "github.com/apache/incubator-devlake/plugins/tapd/impl"
@@ -180,38 +181,10 @@ func TestTapdTaskDataFlow(t *testing.T) {
        dataflowTester.FlushTabler(&ticket.SprintIssue{})
        dataflowTester.FlushTabler(&ticket.IssueLabel{})
        dataflowTester.Subtask(tasks.ConvertTaskMeta, taskData)
-       dataflowTester.VerifyTable(
-               ticket.Issue{},
-               "./snapshot_tables/issues_task.csv",
-               e2ehelper.ColumnWithRawData(
-                       "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",
-               ),
-       )
+       dataflowTester.VerifyTableWithOptions(&ticket.Issue{}, 
e2ehelper.TableOptions{
+               CSVRelPath:  "./snapshot_tables/issues_task.csv",
+               IgnoreTypes: []interface{}{common.Model{}},
+       })
        dataflowTester.VerifyTable(
                ticket.BoardIssue{},
                "./snapshot_tables/board_issues_task.csv",
diff --git a/backend/plugins/tapd/tasks/bug_extractor.go 
b/backend/plugins/tapd/tasks/bug_extractor.go
index 5d3d24ca9..f7dc8b4eb 100644
--- a/backend/plugins/tapd/tasks/bug_extractor.go
+++ b/backend/plugins/tapd/tasks/bug_extractor.go
@@ -73,7 +73,6 @@ func ExtractBugs(taskCtx plugin.SubTaskContext) errors.Error {
                        } else {
                                toolL.StdStatus = getStdStatus(toolL.Status)
                        }
-                       toolL.StdStatus = getStdStatus(toolL.Status)
                        toolL.Url = 
fmt.Sprintf("https://www.tapd.cn/%d/bugtrace/bugs/view?bug_id=%d";, 
toolL.WorkspaceId, toolL.Id)
                        if strings.Contains(toolL.CurrentOwner, ";") {
                                toolL.CurrentOwner = 
strings.Split(toolL.CurrentOwner, ";")[0]


Reply via email to