[GitHub] [incubator-devlake] narrowizard opened a new issue, #2181: [Feature][ticket] add standard status in changelogs

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@devlake.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-devlake] mindlesscloud closed issue #2181: [Feature][ticket] add standard status in changelogs

[GitBox <gi...@apache.org>]

mindlesscloud closed issue #2181: [Feature][ticket] add standard status in changelogs
URL: https://github.com/apache/incubator-devlake/issues/2181


-- 
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: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org