klesh commented on code in PR #7466:
URL:
https://github.com/apache/incubator-devlake/pull/7466#discussion_r1599570179
##########
backend/plugins/jira/tasks/worklog_collector.go:
##########
@@ -59,32 +60,15 @@ func CollectWorklogs(taskCtx plugin.SubTaskContext)
errors.Error {
// filter out issue_ids that needed collection
clauses := []dal.Clause{
- dal.Select("i.issue_id, i.updated AS update_time"),
+ dal.Select("i.issue_id AS issue_id, i.updated AS update_time"),
dal.From("_tool_jira_board_issues bi"),
dal.Join("LEFT JOIN _tool_jira_issues i ON (bi.connection_id =
i.connection_id AND bi.issue_id = i.issue_id)"),
- dal.Join("LEFT JOIN _tool_jira_worklogs wl ON (wl.connection_id
= i.connection_id AND wl.issue_id = i.issue_id)"),
- dal.Where("i.updated > i.created AND bi.connection_id = ? AND
bi.board_id = ? ", data.Options.ConnectionId, data.Options.BoardId),
- dal.Groupby("i.issue_id, i.updated"),
+ dal.Where("bi.connection_id=? and bi.board_id = ? AND
i.std_type != ? and i.worklog_total > 20", data.Options.ConnectionId,
data.Options.BoardId, "Epic"),
Review Comment:
yes, it is, same as the changlog
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
