narrowizard commented on issue #1938: URL: https://github.com/apache/incubator-devlake/issues/1938#issuecomment-1135304561
## Another case is still failed ### changelogs ``` postgres@172:lake> select "from", "to", created_date from changelogs where issue_id = 'jira:JiraIssue:1:18619' and field_name = 'Sprint' order by created_date asc; +--------+-------+----------------------------+ | from | to | created_date | |--------+-------+----------------------------| | 冲刺9 | 冲刺8 | 2022-04-01 14:29:57.127+08 | | 冲刺8 | | 2022-04-02 09:20:07.687+08 | | | 冲刺9 | 2022-04-02 09:20:12.147+08 | +--------+-------+----------------------------+ ``` ### sprints ``` postgres@172:lake> select id, name, started_date, completed_date, status from sprints where id = 'jira:JiraSprint:1:144'; +-----------------------+--------+----------------------------+----------------------------+----------+ | id | name | started_date | completed_date | status | |-----------------------+--------+----------------------------+----------------------------+----------| | jira:JiraSprint:1:144 | 冲刺9 | 2022-04-06 13:41:58.762+08 | 2022-04-18 09:31:35.413+08 | CLOSED | +-----------------------+--------+----------------------------+----------------------------+----------+ ``` ### issues ``` postgres@172:lake> select created_date, resolution_date, status from issues where id = 'jira:JiraIssue:1:18619'; +----------------------------+----------------------------+----------+ | created_date | resolution_date | status | |----------------------------+----------------------------+----------| | 2022-04-01 14:29:53.117+08 | 2022-04-18 09:16:03.494+08 | DONE | +----------------------------+----------------------------+----------+ ``` ### sprint_issues ``` postgres@172:lake> select is_removed, added_date, removed_date from sprint_issues where sprint_id = 'jira:JiraSprint:1:144' and issue_id = 'jira:JiraIssue:1:18619'; +--------------+----------------------------+----------------------------+ | is_removed | added_date | removed_date | |--------------+----------------------------+----------------------------| | True | 2022-04-01 14:29:53.117+08 | 2022-04-01 14:29:57.127+08 | +--------------+----------------------------+----------------------------+ ``` ## Clean removed_date if is_removed is false -- 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]
