You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@devlake.apache.org by wa...@apache.org on 2022/11/23 07:34:03 UTC
[incubator-devlake] branch main updated: fix(domainlayer): delete deployment id for issues (#3787)
This is an automated email from the ASF dual-hosted git repository.
warren 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 a6cbbd61a fix(domainlayer): delete deployment id for issues (#3787)
a6cbbd61a is described below
commit a6cbbd61a097f6ab335c99b6191e18aec8d28f8e
Author: Warren Chen <yi...@merico.dev>
AuthorDate: Wed Nov 23 15:33:59 2022 +0800
fix(domainlayer): delete deployment id for issues (#3787)
---
models/domainlayer/ticket/issue.go | 1 -
...ric.go => 20221120_add_project_issue_metric.go} | 0
plugins/customize/e2e/raw_tables/issues.csv | 62 +++++++++++-----------
plugins/dora/e2e/snapshot_tables/issues.csv | 15 ------
plugins/pagerduty/e2e/snapshot_tables/issues.csv | 8 +--
.../snapshot_tables/_tool_zentao_executions.csv | 4 +-
plugins/zentao/e2e/snapshot_tables/issues_bug.csv | 10 ++--
.../zentao/e2e/snapshot_tables/issues_story.csv | 16 +++---
plugins/zentao/e2e/snapshot_tables/issues_task.csv | 8 +--
9 files changed, 54 insertions(+), 70 deletions(-)
diff --git a/models/domainlayer/ticket/issue.go b/models/domainlayer/ticket/issue.go
index 637e1766f..08f40b726 100644
--- a/models/domainlayer/ticket/issue.go
+++ b/models/domainlayer/ticket/issue.go
@@ -50,7 +50,6 @@ type Issue struct {
AssigneeName string `gorm:"type:varchar(255)"`
Severity string `gorm:"type:varchar(255)"`
Component string `gorm:"type:varchar(255)"`
- DeploymentId string `gorm:"type:varchar(255)"`
}
func (Issue) TableName() string {
diff --git a/models/migrationscripts/20221120_add_project_issue_meric.go b/models/migrationscripts/20221120_add_project_issue_metric.go
similarity index 100%
rename from models/migrationscripts/20221120_add_project_issue_meric.go
rename to models/migrationscripts/20221120_add_project_issue_metric.go
diff --git a/plugins/customize/e2e/raw_tables/issues.csv b/plugins/customize/e2e/raw_tables/issues.csv
index 8130ef263..aae6d0e2d 100644
--- a/plugins/customize/e2e/raw_tables/issues.csv
+++ b/plugins/customize/e2e/raw_tables/issues.csv
@@ -1,31 +1,31 @@
-"id","created_at","updated_at","_raw_data_params","_raw_data_table","_raw_data_id","_raw_data_remark","url","icon_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","creator_name","assignee_id","assignee_name","severity","component","deployment_id"
-"jira:JiraIssue:1:10063","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1701,"","https://merico.atlassian.net/browse/EE-1","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-1","四个排序图：测试/注释覆盖度、复用度、模块性","","","STORY","DONE","已完成",0,"2020-06-19 06:31:18.495","2020-06-12 00:13:13.360","2021-03-28 08:06:08.713",10458,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c [...]
-"jira:JiraIssue:1:10064","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1702,"","https://merico.atlassian.net/browse/EE-2","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-2","问题堆叠分布排序图","","","STORY","DONE","已完成",0,"2020-06-23 10:20:58.999","2020-06-12 00:15:36.123","2021-03-28 08:05:55.016",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
-"jira:JiraIssue:1:10065","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1703,"","https://merico.atlassian.net/browse/EE-3","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-3","问题积压图率","","","STORY","DONE","已完成",0,"2020-06-23 10:21:11.996","2020-06-12 00:15:41.600","2021-03-28 08:05:55.061",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ranki [...]
-"jira:JiraIssue:1:10066","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1704,"","https://merico.atlassian.net/browse/EE-4","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-4","问题分布的帕累托图","","","STORY","DONE","已完成",0,"2020-06-23 10:21:23.562","2020-06-12 00:15:46.144","2021-03-28 08:06:09.535",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
-"jira:JiraIssue:1:10067","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1705,"","https://merico.atlassian.net/browse/EE-5","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-5","通用技术任务","","","TASK","DONE","已完成",0,"2020-06-18 04:06:00.747","2020-06-12 00:16:44.157","2021-03-28 08:05:54.622",8869,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rankin [...]
-"jira:JiraIssue:1:10068","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1706,"","https://merico.atlassian.net/browse/EE-6","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-6","变异系数、生产率的四象限图","","","STORY","DONE","已完成",0,"2020-06-16 11:56:14.433","2020-06-12 00:17:26.986","2021-03-28 08:05:56.750",6458,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3", [...]
-"jira:JiraIssue:1:10070","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1707,"","https://merico.atlassian.net/browse/EE-8","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-8","多团队支持","","","TASK","DONE","已完成",0,"2020-07-08 17:11:45.201","2020-06-12 00:18:58.050","2021-03-28 08:05:54.576",38452,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rankin [...]
-"jira:JiraIssue:1:10071","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1708,"","https://merico.atlassian.net/browse/EE-9","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-9","Common backend 拆分","","","TASK","DONE","已完成",0,"2020-07-08 17:12:05.663","2020-06-12 00:19:17.336","2021-03-28 08:06:20.165",38452,"","Medium",1680,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc [...]
-"jira:JiraIssue:1:10072","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1709,"","https://merico.atlassian.net/browse/EE-10","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-10","部署SaaS版本","","","TASK","DONE","已完成",0,"2020-07-08 17:11:55.247","2020-06-12 00:19:24.637","2021-03-28 08:05:54.472",38452,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
-"jira:JiraIssue:1:10076","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1710,"","https://merico.atlassian.net/browse/EE-14","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-14","调整文件夹结构","","","TASK","DONE","已完成",0,"2020-06-15 08:59:51.304","2020-06-12 00:24:25.922","2021-03-28 08:05:56.152",4835,"","Medium",240,600,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3"," [...]
-"jira:JiraIssue:1:10077","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1711,"","https://merico.atlassian.net/browse/EE-15","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-15","路由权限控制","","","TASK","DONE","已完成",0,"2020-06-15 09:00:26.956","2020-06-12 00:24:39.624","2021-03-28 08:06:01.995",4835,"","Medium",240,480,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
-"jira:JiraIssue:1:10078","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1712,"","https://merico.atlassian.net/browse/EE-16","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-16","优化前端 webpack 开发阶段构建速度","","","TASK","DONE","已完成",0,"2020-06-15 09:01:44.159","2020-06-12 00:24:49.017","2021-03-28 08:05:55.863",4836,"","Medium",0,60,0,"jira:JiraAccount:1:5e9711ba34f7b90c [...]
-"jira:JiraIssue:1:10079","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1713,"","https://merico.atlassian.net/browse/EE-17","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-17","新的错误处理机制","","","TASK","DONE","已完成",0,"2020-07-22 07:25:29.104","2020-06-12 00:24:56.048","2021-03-28 08:05:54.426",58020,"","Medium",360,120,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3" [...]
-"jira:JiraIssue:1:10081","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1714,"","https://merico.atlassian.net/browse/EE-19","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-19","LDAP需要支持TLS和证书","","","STORY","DONE","已完成",0,"2020-06-18 08:34:11.117","2020-06-12 00:28:00.241","2021-03-28 08:05:57.326",9126,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d [...]
-"jira:JiraIssue:1:10082","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1715,"","https://merico.atlassian.net/browse/EE-20","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-20","团队首页垂直化","","","STORY","DONE","已完成",0,"2020-06-17 07:25:54.370","2020-06-12 00:29:43.677","2021-08-06 06:14:54.647",7616,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rank [...]
-"jira:JiraIssue:1:10085","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1716,"","https://merico.atlassian.net/browse/EE-23","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10303?size=medium","EE-23","批量删除事故","","","BUG","DONE","已完成",0,"2020-06-15 09:07:56.798","2020-06-12 00:33:57.204","2021-03-28 08:05:57.095",4833,"","Medium",0,60,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ranki [...]
-"jira:JiraIssue:1:10086","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1717,"","https://merico.atlassian.net/browse/EE-24","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-24","LDAP支持自定义的证书上传","","","STORY","DONE","已完成",0,"2020-06-12 07:17:28.659","2020-06-12 00:35:15.489","2021-03-28 08:05:55.819",402,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3 [...]
-"jira:JiraIssue:1:10087","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1718,"","https://merico.atlassian.net/browse/EE-25","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-25","组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:02:22.350","2020-06-12 00:40:54.210","2021-03-28 08:05:57.189",8841,"jira:JiraIssue:1:10063","Medium",240,0,0,"jira:JiraAccount:1:5 [...]
-"jira:JiraIssue:1:10088","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1719,"","https://merico.atlassian.net/browse/EE-26","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-26","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:51.438","2020-06-12 00:41:01.683","2021-03-28 08:05:55.208",4825,"jira:JiraIssue:1:10063","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba3 [...]
-"jira:JiraIssue:1:10089","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1720,"","https://merico.atlassian.net/browse/EE-27","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-27","提供后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 06:31:31.662","2020-06-12 00:41:16.622","2021-03-28 08:05:55.498",10430,"jira:JiraIssue:1:10063","Medium",660,0,0,"jira:JiraAccount:1:5e9 [...]
-"jira:JiraIssue:1:10090","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1721,"","https://merico.atlassian.net/browse/EE-28","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-28","数据填充与联调","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:04.637","2020-06-12 00:41:36.317","2021-03-28 08:06:05.443",8841,"jira:JiraIssue:1:10063","Medium",360,0,0,"jira:JiraAccount:1:5e9 [...]
-"jira:JiraIssue:1:10091","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1722,"","https://merico.atlassian.net/browse/EE-29","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-29","组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:30.760","2020-06-12 00:48:29.035","2021-03-28 08:05:55.731",8835,"jira:JiraIssue:1:10064","Medium",360,0,0,"jira:JiraAccount:1:5 [...]
-"jira:JiraIssue:1:10092","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1723,"","https://merico.atlassian.net/browse/EE-30","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-30","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:40.206","2020-06-12 00:48:39.803","2021-03-28 08:05:55.159",4818,"jira:JiraIssue:1:10064","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba3 [...]
-"jira:JiraIssue:1:10093","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1724,"","https://merico.atlassian.net/browse/EE-31","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-31","后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 07:35:31.762","2020-06-12 00:48:46.751","2021-03-28 08:05:55.544",10486,"jira:JiraIssue:1:10064","Medium",120,0,0,"jira:JiraAccount:1:5e971 [...]
-"jira:JiraIssue:1:10094","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1725,"","https://merico.atlassian.net/browse/EE-32","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-32","数据填充与联调","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:48.818","2020-06-12 00:48:53.279","2021-03-28 08:05:55.592",8834,"jira:JiraIssue:1:10064","Medium",360,0,0,"jira:JiraAccount:1:5e9 [...]
-"jira:JiraIssue:1:10095","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1726,"","https://merico.atlassian.net/browse/EE-33","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-33","准备测试用例","","","SUB-TASK","DONE","已完成",0,"2020-06-19 06:32:19.340","2020-06-12 00:50:45.674","2021-03-28 08:05:55.253",10421,"jira:JiraIssue:1:10063","Medium",0,0,0,"jira:JiraAccount:1:5e9711 [...]
-"jira:JiraIssue:1:10096","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1727,"","https://merico.atlassian.net/browse/EE-34","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-34"," 组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:04:05.951","2020-06-12 00:51:57.807","2021-03-28 08:05:57.232",8832,"jira:JiraIssue:1:10065","Medium",240,0,0,"jira:JiraAccount:1: [...]
-"jira:JiraIssue:1:10097","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1728,"","https://merico.atlassian.net/browse/EE-35","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-35","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:30.942","2020-06-12 00:52:04.767","2021-03-28 08:05:55.353",4814,"jira:JiraIssue:1:10065","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34 [...]
-"jira:JiraIssue:1:10098","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1729,"","https://merico.atlassian.net/browse/EE-36","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-36","后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 07:35:44.696","2020-06-12 00:52:12.678","2021-03-28 08:05:55.685",10483,"jira:JiraIssue:1:10065","Medium",120,0,0,"jira:JiraAccount:1:5e9711 [...]
-"jira:JiraIssue:1:10099","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1730,"","https://merico.atlassian.net/browse/EE-37","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-37","数据填充与联调 ","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:04:31.261","2020-06-12 00:52:23.456","2021-03-28 08:05:55.638",8832,"jira:JiraIssue:1:10065","Medium",0,0,0,"jira:JiraAccount:1:5e971 [...]
+"id","created_at","updated_at","_raw_data_params","_raw_data_table","_raw_data_id","_raw_data_remark","url","icon_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","creator_name","assignee_id","assignee_name","severity","component"
+"jira:JiraIssue:1:10063","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1701,"","https://merico.atlassian.net/browse/EE-1","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-1","四个排序图：测试/注释覆盖度、复用度、模块性","","","STORY","DONE","已完成",0,"2020-06-19 06:31:18.495","2020-06-12 00:13:13.360","2021-03-28 08:06:08.713",10458,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c [...]
+"jira:JiraIssue:1:10064","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1702,"","https://merico.atlassian.net/browse/EE-2","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-2","问题堆叠分布排序图","","","STORY","DONE","已完成",0,"2020-06-23 10:20:58.999","2020-06-12 00:15:36.123","2021-03-28 08:05:55.016",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
+"jira:JiraIssue:1:10065","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1703,"","https://merico.atlassian.net/browse/EE-3","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-3","问题积压图率","","","STORY","DONE","已完成",0,"2020-06-23 10:21:11.996","2020-06-12 00:15:41.600","2021-03-28 08:05:55.061",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ranki [...]
+"jira:JiraIssue:1:10066","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1704,"","https://merico.atlassian.net/browse/EE-4","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-4","问题分布的帕累托图","","","STORY","DONE","已完成",0,"2020-06-23 10:21:23.562","2020-06-12 00:15:46.144","2021-03-28 08:06:09.535",16445,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
+"jira:JiraIssue:1:10067","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1705,"","https://merico.atlassian.net/browse/EE-5","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-5","通用技术任务","","","TASK","DONE","已完成",0,"2020-06-18 04:06:00.747","2020-06-12 00:16:44.157","2021-03-28 08:05:54.622",8869,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rankin [...]
+"jira:JiraIssue:1:10068","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1706,"","https://merico.atlassian.net/browse/EE-6","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-6","变异系数、生产率的四象限图","","","STORY","DONE","已完成",0,"2020-06-16 11:56:14.433","2020-06-12 00:17:26.986","2021-03-28 08:05:56.750",6458,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3", [...]
+"jira:JiraIssue:1:10070","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1707,"","https://merico.atlassian.net/browse/EE-8","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-8","多团队支持","","","TASK","DONE","已完成",0,"2020-07-08 17:11:45.201","2020-06-12 00:18:58.050","2021-03-28 08:05:54.576",38452,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rankin [...]
+"jira:JiraIssue:1:10071","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1708,"","https://merico.atlassian.net/browse/EE-9","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-9","Common backend 拆分","","","TASK","DONE","已完成",0,"2020-07-08 17:12:05.663","2020-06-12 00:19:17.336","2021-03-28 08:06:20.165",38452,"","Medium",1680,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc [...]
+"jira:JiraIssue:1:10072","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1709,"","https://merico.atlassian.net/browse/EE-10","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-10","部署SaaS版本","","","TASK","DONE","已完成",0,"2020-07-08 17:11:55.247","2020-06-12 00:19:24.637","2021-03-28 08:05:54.472",38452,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
+"jira:JiraIssue:1:10076","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1710,"","https://merico.atlassian.net/browse/EE-14","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-14","调整文件夹结构","","","TASK","DONE","已完成",0,"2020-06-15 08:59:51.304","2020-06-12 00:24:25.922","2021-03-28 08:05:56.152",4835,"","Medium",240,600,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3"," [...]
+"jira:JiraIssue:1:10077","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1711,"","https://merico.atlassian.net/browse/EE-15","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-15","路由权限控制","","","TASK","DONE","已完成",0,"2020-06-15 09:00:26.956","2020-06-12 00:24:39.624","2021-03-28 08:06:01.995",4835,"","Medium",240,480,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ra [...]
+"jira:JiraIssue:1:10078","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1712,"","https://merico.atlassian.net/browse/EE-16","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-16","优化前端 webpack 开发阶段构建速度","","","TASK","DONE","已完成",0,"2020-06-15 09:01:44.159","2020-06-12 00:24:49.017","2021-03-28 08:05:55.863",4836,"","Medium",0,60,0,"jira:JiraAccount:1:5e9711ba34f7b90c [...]
+"jira:JiraIssue:1:10079","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1713,"","https://merico.atlassian.net/browse/EE-17","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10318?size=medium","EE-17","新的错误处理机制","","","TASK","DONE","已完成",0,"2020-07-22 07:25:29.104","2020-06-12 00:24:56.048","2021-03-28 08:05:54.426",58020,"","Medium",360,120,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3" [...]
+"jira:JiraIssue:1:10081","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1714,"","https://merico.atlassian.net/browse/EE-19","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-19","LDAP需要支持TLS和证书","","","STORY","DONE","已完成",0,"2020-06-18 08:34:11.117","2020-06-12 00:28:00.241","2021-03-28 08:05:57.326",9126,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d [...]
+"jira:JiraIssue:1:10082","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1715,"","https://merico.atlassian.net/browse/EE-20","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-20","团队首页垂直化","","","STORY","DONE","已完成",0,"2020-06-17 07:25:54.370","2020-06-12 00:29:43.677","2021-08-06 06:14:54.647",7616,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Rank [...]
+"jira:JiraIssue:1:10085","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1716,"","https://merico.atlassian.net/browse/EE-23","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10303?size=medium","EE-23","批量删除事故","","","BUG","DONE","已完成",0,"2020-06-15 09:07:56.798","2020-06-12 00:33:57.204","2021-03-28 08:05:57.095",4833,"","Medium",0,60,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3","Ranki [...]
+"jira:JiraIssue:1:10086","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1717,"","https://merico.atlassian.net/browse/EE-24","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10315?size=medium","EE-24","LDAP支持自定义的证书上传","","","STORY","DONE","已完成",0,"2020-06-12 07:17:28.659","2020-06-12 00:35:15.489","2021-03-28 08:05:55.819",402,"","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34f7b90c0fbc37d3 [...]
+"jira:JiraIssue:1:10087","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1718,"","https://merico.atlassian.net/browse/EE-25","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-25","组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:02:22.350","2020-06-12 00:40:54.210","2021-03-28 08:05:57.189",8841,"jira:JiraIssue:1:10063","Medium",240,0,0,"jira:JiraAccount:1:5 [...]
+"jira:JiraIssue:1:10088","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1719,"","https://merico.atlassian.net/browse/EE-26","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-26","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:51.438","2020-06-12 00:41:01.683","2021-03-28 08:05:55.208",4825,"jira:JiraIssue:1:10063","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba3 [...]
+"jira:JiraIssue:1:10089","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1720,"","https://merico.atlassian.net/browse/EE-27","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-27","提供后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 06:31:31.662","2020-06-12 00:41:16.622","2021-03-28 08:05:55.498",10430,"jira:JiraIssue:1:10063","Medium",660,0,0,"jira:JiraAccount:1:5e9 [...]
+"jira:JiraIssue:1:10090","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1721,"","https://merico.atlassian.net/browse/EE-28","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-28","数据填充与联调","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:04.637","2020-06-12 00:41:36.317","2021-03-28 08:06:05.443",8841,"jira:JiraIssue:1:10063","Medium",360,0,0,"jira:JiraAccount:1:5e9 [...]
+"jira:JiraIssue:1:10091","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1722,"","https://merico.atlassian.net/browse/EE-29","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-29","组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:30.760","2020-06-12 00:48:29.035","2021-03-28 08:05:55.731",8835,"jira:JiraIssue:1:10064","Medium",360,0,0,"jira:JiraAccount:1:5 [...]
+"jira:JiraIssue:1:10092","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1723,"","https://merico.atlassian.net/browse/EE-30","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-30","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:40.206","2020-06-12 00:48:39.803","2021-03-28 08:05:55.159",4818,"jira:JiraIssue:1:10064","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba3 [...]
+"jira:JiraIssue:1:10093","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1724,"","https://merico.atlassian.net/browse/EE-31","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-31","后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 07:35:31.762","2020-06-12 00:48:46.751","2021-03-28 08:05:55.544",10486,"jira:JiraIssue:1:10064","Medium",120,0,0,"jira:JiraAccount:1:5e971 [...]
+"jira:JiraIssue:1:10094","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1725,"","https://merico.atlassian.net/browse/EE-32","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-32","数据填充与联调","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:03:48.818","2020-06-12 00:48:53.279","2021-03-28 08:05:55.592",8834,"jira:JiraIssue:1:10064","Medium",360,0,0,"jira:JiraAccount:1:5e9 [...]
+"jira:JiraIssue:1:10095","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1726,"","https://merico.atlassian.net/browse/EE-33","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-33","准备测试用例","","","SUB-TASK","DONE","已完成",0,"2020-06-19 06:32:19.340","2020-06-12 00:50:45.674","2021-03-28 08:05:55.253",10421,"jira:JiraIssue:1:10063","Medium",0,0,0,"jira:JiraAccount:1:5e9711 [...]
+"jira:JiraIssue:1:10096","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1727,"","https://merico.atlassian.net/browse/EE-34","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-34"," 组件封装及Demo","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:04:05.951","2020-06-12 00:51:57.807","2021-03-28 08:05:57.232",8832,"jira:JiraIssue:1:10065","Medium",240,0,0,"jira:JiraAccount:1: [...]
+"jira:JiraIssue:1:10097","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1728,"","https://merico.atlassian.net/browse/EE-35","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-35","定接口","","","SUB-TASK","DONE","已完成",0,"2020-06-15 09:06:30.942","2020-06-12 00:52:04.767","2021-03-28 08:05:55.353",4814,"jira:JiraIssue:1:10065","Medium",0,0,0,"jira:JiraAccount:1:5e9711ba34 [...]
+"jira:JiraIssue:1:10098","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1729,"","https://merico.atlassian.net/browse/EE-36","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-36","后端接口","","","SUB-TASK","DONE","已完成",0,"2020-06-19 07:35:44.696","2020-06-12 00:52:12.678","2021-03-28 08:05:55.685",10483,"jira:JiraIssue:1:10065","Medium",120,0,0,"jira:JiraAccount:1:5e9711 [...]
+"jira:JiraIssue:1:10099","2022-08-01 08:18:48.762","2022-08-23 13:12:41.015","{""ConnectionId"":1,""BoardId"":8}","_raw_jira_api_issues",1730,"","https://merico.atlassian.net/browse/EE-37","https://merico.atlassian.net/rest/api/2/universal_avatar/view/type/issuetype/avatar/10316?size=medium","EE-37","数据填充与联调 ","","","SUB-TASK","DONE","已完成",0,"2020-06-18 04:04:31.261","2020-06-12 00:52:23.456","2021-03-28 08:05:55.638",8832,"jira:JiraIssue:1:10065","Medium",0,0,0,"jira:JiraAccount:1:5e971 [...]
diff --git a/plugins/dora/e2e/snapshot_tables/issues.csv b/plugins/dora/e2e/snapshot_tables/issues.csv
deleted file mode 100644
index 84f06d938..000000000
--- a/plugins/dora/e2e/snapshot_tables/issues.csv
+++ /dev/null
@@ -1,15 +0,0 @@
-id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component,deployment_id
-github:GithubIssue:1:1367714738,https://github.com/apache/incubator-devlake/issues/3036,,3036,[Bug][GitHub Action] The workflow `check-Apache-license-header` doesn't work,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\nThe `skywalking-eyes` could not find the config file `.licenserc.yaml `.\r\nthe following files with missing ASF header were not dete [...]
-github:GithubIssue:1:1370813347,https://github.com/apache/incubator-devlake/issues/3054,,3054,[Bug][github] collect apache/incubator-devlake fail,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\n```\r\ntime=\""2022-09-13 11:44:02\"" level=info msg=\"" [pipeline service] [pipeline #17] [task #28] [github] [extractApiIssues] get data from _raw_github_ap [...]
-github:GithubIssue:1:1370816458,https://github.com/apache/incubator-devlake/issues/3055,,3055,[Bug][config-ui] cannot create my plugin by advance mode in config-ui,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\n\r\n\n\n### What you expected [...]
-github:GithubIssue:1:1370833897,https://github.com/apache/incubator-devlake/issues/3056,,3056,[Bug][Framework] github/gitlab/gitee issues do not have board_repo record,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\nThere is no record in board_repos for github/gitlab/gitea/gitee issues\n\n### What you expected to happen\n\nsave record in board_repos [...]
-github:GithubIssue:1:1371315795,https://github.com/apache/incubator-devlake/issues/3058,,3058,[Feature][Bitbucket] add Pipeline collector & extractor & convertor,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement.\n\n\n### Description\n\n_No response_\n\n### Use case\n\n_No response_\n\n### Related issues\n\n_No response_\n\n### Are you willing to submit a PR?\n\n- [ [...]
-github:GithubIssue:1:1371320153,https://github.com/apache/incubator-devlake/issues/3059,,3059,[Bug][customize] e2e test failed in postgres,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\ncached plan must not change result type in e2e test.\n\n### What you expected to happen\n\nsuccess\n\n### How to reproduce\n\nrun e2e test in postgres check\n\n### A [...]
-github:GithubIssue:1:1371541422,https://github.com/apache/incubator-devlake/issues/3060,,3060,[Bug][Migrationscripts] use common and domainlayer for migrationscripts table model,"""### Search before asking\r\n\r\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\r\n\r\n\r\n### What happened\r\n\r\n\r [...]
-github:GithubIssue:1:1371617668,https://github.com/apache/incubator-devlake/issues/3061,,3061,[Feature][api-client] wait more time to prevent long-time collection canceled by network problem,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement.\n\n\n### Description\n\nWait more time to prevent long-time collection cancelled by network problems.\r\nSome users' Jira serv [...]
-github:GithubIssue:1:1372381019,https://github.com/apache/incubator-devlake/issues/3063,,3063,[Bug][Bitbucket] the other subtasks cannot continue when the number of issues is zero.,"""### Search before asking\r\n\r\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\r\n\r\n\r\n### What happened\r\n\r\nthe other subtasks cannot continue when the number of issues is zero.\r\n<img width=\""1370\"" alt=\""Screen [...]
-github:GithubIssue:1:1372550825,https://github.com/apache/incubator-devlake/issues/3065,,3065,[Bug][tapd] error occurred while adding connection for plugin tapd ,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\nAn error occurred while adding a new connection for plugin `tapd`\r\nfront-end:\r\n![2Owp3eV9t4](https://user-images.githubusercontent.com/845 [...]
-github:GithubIssue:1:1372581663,https://github.com/apache/incubator-devlake/issues/3067,,3067,[Bug][Framework] error getting pipelines,"""### Search before asking\r\n\r\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\r\n\r\n\r\n### What happened\r\n\r\nWe cannot get pipelines and blueprints on config-ui\r\n[2022-09-14 16:25:30] ERROR HTTP 500 error\r\n caused by: error getting pipelines\r\n [...]
-github:GithubIssue:1:1372644519,https://github.com/apache/incubator-devlake/issues/3068,,3068,[Feature][Backend] Establish a standard error logging convention,"""### Search before asking\r\n\r\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement.\r\n\r\n\r\n### Description\r\n\r\nCurrently the codebase is filled with random usages of logger.Error(err, \""msg\""). Calls to this function must be done [...]
-github:GithubIssue:1:1373079324,https://github.com/apache/incubator-devlake/issues/3072,,3072,[Bug][framework] status code 500 returned from the server,"""### Search before asking\n\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\n\n\n### What happened\n\nstatus code 500 returned from the endpoint `/pipelines`\r\n```\r\n$ curl -i 127.0.0.1:8080/pipelines\r\nHTTP/1.1 500 Internal Server Error\r\nContent-T [...]
-github:GithubIssue:1:1373792477,https://github.com/apache/incubator-devlake/issues/3073,,3073,[Bug][github] calculateSince retrun the empty timespace,"""### Search before asking\r\n\r\n- [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues.\r\n\r\n\r\n### What happened\r\n\r\n\r\n\r\n![image](https://user- [...]
diff --git a/plugins/pagerduty/e2e/snapshot_tables/issues.csv b/plugins/pagerduty/e2e/snapshot_tables/issues.csv
index e923dbcfe..dc9e894f1 100644
--- a/plugins/pagerduty/e2e/snapshot_tables/issues.csv
+++ b/plugins/pagerduty/e2e/snapshot_tables/issues.csv
@@ -1,4 +1,4 @@
-id,created_at,updated_at,_raw_data_params,_raw_data_table,_raw_data_id,_raw_data_remark,url,icon_url,issue_key,title,description,epic_key,type,status,original_status,story_point,resolution_date,created_date,updated_date,parent_issue_id,priority,original_estimate_minutes,time_spent_minutes,time_remaining_minutes,creator_id,creator_name,assignee_id,assignee_name,severity,component,deployment_id,lead_time_minutes
-pagerduty:Incident:1:4,2022-11-03T07:11:37.437+00:00,2022-11-03T07:11:37.437+00:00,"{""ConnectionId"":1,""Stream"":""incidents""}",_raw_pagerduty_incidents,1,,https://keon-test.pagerduty.com/incidents/Q3YON8WNWTZMRQ,,4,,[#4] Crash reported,,INCIDENT,TODO,triggered,0,,2022-11-03T06:23:06.000+00:00,2022-11-03T07:02:36.000+00:00,,high,0,0,0,,,P25K520,Kian Amini,,,"",0
-pagerduty:Incident:1:5,2022-11-03T07:11:37.437+00:00,2022-11-03T07:11:37.437+00:00,"{""ConnectionId"":1,""Stream"":""incidents""}",_raw_pagerduty_incidents,2,,https://keon-test.pagerduty.com/incidents/Q3CZAU7Q4008QD,,5,,[#5] Slow startup,,INCIDENT,IN_PROGRESS,acknowledged,0,,2022-11-03T06:44:28.000+00:00,2022-11-03T06:44:37.000+00:00,,high,0,0,0,,,PQYACO3,Keon Amini,,,"",0
-pagerduty:Incident:1:6,2022-11-03T07:11:37.437+00:00,2022-11-03T07:11:37.437+00:00,"{""ConnectionId"":1,""Stream"":""incidents""}",_raw_pagerduty_incidents,3,,https://keon-test.pagerduty.com/incidents/Q1OHFWFP3GPXOG,,6,,[#6] Spamming logs,,INCIDENT,DONE,resolved,0,2022-11-03T06:51:44.000+00:00,2022-11-03T06:45:36.000+00:00,2022-11-03T06:51:44.000+00:00,,low,0,0,0,,,,,,,"",6
+id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component
+pagerduty:Incident:1:4,https://keon-test.pagerduty.com/incidents/Q3YON8WNWTZMRQ,,4,,[#4] Crash reported,,INCIDENT,TODO,triggered,0,,2022-11-03T06:23:06.000+00:00,2022-11-03T07:02:36.000+00:00,0,,high,0,0,0,,,P25K520,Kian Amini,,
+pagerduty:Incident:1:5,https://keon-test.pagerduty.com/incidents/Q3CZAU7Q4008QD,,5,,[#5] Slow startup,,INCIDENT,IN_PROGRESS,acknowledged,0,,2022-11-03T06:44:28.000+00:00,2022-11-03T06:44:37.000+00:00,0,,high,0,0,0,,,PQYACO3,Keon Amini,,
+pagerduty:Incident:1:6,https://keon-test.pagerduty.com/incidents/Q1OHFWFP3GPXOG,,6,,[#6] Spamming logs,,INCIDENT,DONE,resolved,0,2022-11-03T06:51:44.000+00:00,2022-11-03T06:45:36.000+00:00,2022-11-03T06:51:44.000+00:00,6,,low,0,0,0,,,,,,
diff --git a/plugins/zentao/e2e/snapshot_tables/_tool_zentao_executions.csv b/plugins/zentao/e2e/snapshot_tables/_tool_zentao_executions.csv
index 10e80b83e..4a5f7f367 100644
--- a/plugins/zentao/e2e/snapshot_tables/_tool_zentao_executions.csv
+++ b/plugins/zentao/e2e/snapshot_tables/_tool_zentao_executions.csv
@@ -1,2 +1,2 @@
-connection_id,id,project,model,type,lifetime,budget,budget_unit,attribute,percent,milestone,output,auth,parent,path,grade,name,code,plan_begin,plan_end,real_began,real_end,days,status,sub_status,pri,description,version,parent_version,plan_duration,real_duration,opened_by_id,opened_date,opened_version,last_edited_by_id,last_edited_date,closed_by_id,closed_date,canceled_by_id,canceled_date,suspended_date,po_id,pm_id,qd_id,rd_id,team,acl,order_in,vision,display_cards,fluid_board,deleted,tot [...]
-1,1,7,,sprint,short,0,CNY,,0,0,,,7,",7,1,",1,企业网站第一期,coWeb1,2022-05-01T00:00:00.000+00:00,2022-06-01T00:00:00.000+00:00,,,0,doing,,1,开发企业网站的基本雏形。<br />,0,0,0,0,0,,,1,2022-11-21T06:00:56.000+00:00,0,,0,,,2,3,10,2,公司开发团队,open,5,rnd,0,0,0,11753,52,51.5,27.5,0,65.2,0
+connection_id,id,project,model,type,lifetime,budget,budget_unit,attribute,percent,milestone,output,auth,parent,path,grade,name,code,plan_begin,plan_end,real_began,real_end,status,sub_status,pri,description,version,parent_version,plan_duration,real_duration,opened_by_id,opened_date,opened_version,last_edited_by_id,last_edited_date,closed_by_id,closed_date,canceled_by_id,canceled_date,suspended_date,po_id,pm_id,qd_id,rd_id,team,acl,order_in,vision,display_cards,fluid_board,deleted,total_ho [...]
+1,1,7,,sprint,short,0,CNY,,0,0,,,7,",7,1,",1,企业网站第一期,coWeb1,2022-05-01T00:00:00.000+00:00,2022-06-01T00:00:00.000+00:00,,,doing,,1,开发企业网站的基本雏形。<br />,0,0,0,0,0,,,1,2022-11-21T06:00:56.000+00:00,0,,0,,,2,3,10,2,公司开发团队,open,5,rnd,0,0,0,11753,52,51.5,27.5,0,65.2,0
diff --git a/plugins/zentao/e2e/snapshot_tables/issues_bug.csv b/plugins/zentao/e2e/snapshot_tables/issues_bug.csv
index 9a3babe2a..4c260ebfb 100644
--- a/plugins/zentao/e2e/snapshot_tables/issues_bug.csv
+++ b/plugins/zentao/e2e/snapshot_tables/issues_bug.csv
@@ -1,5 +1,5 @@
-id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component,deployment_id
-zentao:ZentaoBug:1:1,,,1,首页页面问题,,,BUG,IN_PROGRESS,active,0,,2012-06-05T02:56:11.000+00:00,2021-04-28T03:09:08.000+00:00,0,zentao:ZentaoStory:1:1,,0,0,0,7,测试甲,4,开发甲,,,
-zentao:ZentaoBug:1:2,,,2,新闻中心页面问题,,,BUG,IN_PROGRESS,delay,0,,2012-06-05T02:57:11.000+00:00,2022-10-05T04:19:22.000+00:00,0,zentao:ZentaoStory:1:2,,0,0,0,7,测试甲,0,,,,
-zentao:ZentaoBug:1:3,,,3,成果展示页面问题,,,BUG,IN_PROGRESS,active,0,,2012-06-05T02:58:22.000+00:00,2021-04-28T03:09:08.000+00:00,0,zentao:ZentaoStory:1:3,,0,0,0,8,测试乙,4,开发甲,,,
-zentao:ZentaoBug:1:4,,,4,售后服务页面问题,,,BUG,DONE,resolved,0,,2012-06-05T03:00:19.000+00:00,2022-10-05T04:10:08.000+00:00,0,zentao:ZentaoStory:1:4,,0,0,0,9,测试丙,9,测试丙,,,
+id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component
+zentao:ZentaoBug:1:1,,,1,首页页面问题,,,BUG,IN_PROGRESS,active,0,,2012-06-05T02:56:11.000+00:00,2021-04-28T03:09:08.000+00:00,0,zentao:ZentaoStory:1:1,,0,0,0,7,测试甲,4,开发甲,,
+zentao:ZentaoBug:1:2,,,2,新闻中心页面问题,,,BUG,IN_PROGRESS,delay,0,,2012-06-05T02:57:11.000+00:00,2022-10-05T04:19:22.000+00:00,0,zentao:ZentaoStory:1:2,,0,0,0,7,测试甲,0,,,
+zentao:ZentaoBug:1:3,,,3,成果展示页面问题,,,BUG,IN_PROGRESS,active,0,,2012-06-05T02:58:22.000+00:00,2021-04-28T03:09:08.000+00:00,0,zentao:ZentaoStory:1:3,,0,0,0,8,测试乙,4,开发甲,,
+zentao:ZentaoBug:1:4,,,4,售后服务页面问题,,,BUG,DONE,resolved,0,,2012-06-05T03:00:19.000+00:00,2022-10-05T04:10:08.000+00:00,0,zentao:ZentaoStory:1:4,,0,0,0,9,测试丙,9,测试丙,,
diff --git a/plugins/zentao/e2e/snapshot_tables/issues_story.csv b/plugins/zentao/e2e/snapshot_tables/issues_story.csv
index e480b42f6..b5364ff74 100644
--- a/plugins/zentao/e2e/snapshot_tables/issues_story.csv
+++ b/plugins/zentao/e2e/snapshot_tables/issues_story.csv
@@ -1,8 +1,8 @@
-id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component,deployment_id
-zentao:ZentaoStory:1:1,,,1,首页设计和开发,,,REQUIREMENT,IN_PROGRESS,developing,0,,2012-06-05T02:09:49.000+00:00,2012-06-05T02:25:19.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:2,,,2,新闻中心的设计和开发。,,,REQUIREMENT,IN_PROGRESS,projected,0,,2012-06-05T02:16:37.000+00:00,2012-06-05T02:25:33.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:3,,,3,成果展示的设计和开发,,,REQUIREMENT,IN_PROGRESS,developing,0,,2012-06-05T02:18:10.000+00:00,2012-06-05T02:25:38.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:4,,,4,售后服务的设计和开发,,,REQUIREMENT,IN_PROGRESS,developed,0,,2012-06-05T02:20:16.000+00:00,2012-06-05T02:25:42.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:5,,,5,诚聘英才的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:21:39.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:6,,,6,合作洽谈的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:23:11.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
-zentao:ZentaoStory:1:7,,,7,关于我们的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:24:19.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,,
+id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component
+zentao:ZentaoStory:1:1,,,1,首页设计和开发,,,REQUIREMENT,IN_PROGRESS,developing,0,,2012-06-05T02:09:49.000+00:00,2012-06-05T02:25:19.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:2,,,2,新闻中心的设计和开发。,,,REQUIREMENT,IN_PROGRESS,projected,0,,2012-06-05T02:16:37.000+00:00,2012-06-05T02:25:33.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:3,,,3,成果展示的设计和开发,,,REQUIREMENT,IN_PROGRESS,developing,0,,2012-06-05T02:18:10.000+00:00,2012-06-05T02:25:38.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:4,,,4,售后服务的设计和开发,,,REQUIREMENT,IN_PROGRESS,developed,0,,2012-06-05T02:20:16.000+00:00,2012-06-05T02:25:42.000+00:00,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:5,,,5,诚聘英才的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:21:39.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:6,,,6,合作洽谈的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:23:11.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
+zentao:ZentaoStory:1:7,,,7,关于我们的设计和开发,,,REQUIREMENT,IN_PROGRESS,planned,0,,2012-06-05T02:24:19.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,2,产品经理,2,产品经理,,
diff --git a/plugins/zentao/e2e/snapshot_tables/issues_task.csv b/plugins/zentao/e2e/snapshot_tables/issues_task.csv
index 96505fad2..e40ef2885 100644
--- a/plugins/zentao/e2e/snapshot_tables/issues_task.csv
+++ b/plugins/zentao/e2e/snapshot_tables/issues_task.csv
@@ -1,4 +1,4 @@
-id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component,deployment_id
-zentao:ZentaoTask:1:1,,,1,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,1,devlake,5,开发乙,,,
-zentao:ZentaoTask:1:2,,,2,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,1,devlake,5,开发乙,,,
-zentao:ZentaoTask:1:3,,,3,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:-1,,0,0,0,1,devlake,5,开发乙,,,
+id,url,icon_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,creator_name,assignee_id,assignee_name,severity,component
+zentao:ZentaoTask:1:1,,,1,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,1,devlake,5,开发乙,,
+zentao:ZentaoTask:1:2,,,2,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:0,,0,0,0,1,devlake,5,开发乙,,
+zentao:ZentaoTask:1:3,,,3,任务名称,任务描述<span> </span><br /><div><br /></div>,,TASK,TODO,wait,0,,2022-09-19T01:50:37.000+00:00,,0,zentao:ZentaoStory:1:-1,,0,0,0,1,devlake,5,开发乙,,