narrowizard opened a new issue, #2181: URL: https://github.com/apache/incubator-devlake/issues/2181
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement. ### Description Now we only stored original status in changelogs entity(in 'status' type), to calculate some metrics (eg: #1796 completion_date), we need to know changelogs of standard status in changelogs entity. ```bash postgres@postgres:lake> select * from changelogs where field_name = 'status' limit 1; "id","created_at","updated_at","_raw_data_params","_raw_data_table","_raw_data_id","_raw_data_remark","issue_id","author_id","author_name","field_id","field_name","from_value","to_value","created_date" "jira:JiraChangelogItem:1:118864:status","2022-05-30 08:59:53.557919+00","2022-05-30 08:59:53.557919+00","{""ConnectionId"":1,""BoardId"":68}","_raw_jira_api_changelogs","60805","","jira:JiraIssue:1:15144","5ecfbd0984083c0c12e5af8f","lin.hao","","status","已关闭","重新打开","2021-06-21 12:00:52.757+00" ``` ### Use case To calculate completion_date of issues, we need to know the latest time when issue come into a done status. ### Related issues #1796 ### Are you willing to submit a PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
