Startrekzky opened a new issue, #7708: URL: https://github.com/apache/incubator-devlake/issues/7708
### 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. ### Use case As a PM, 1. I used the `from_value` and `to_value` of the field where `field_name = assignee` in the `issues.changelogs` to measure who has contributed to a Jira issue during the whole lifecycle. 2. I also use another customized Jira issue field (whose `jira_field_type` = `jira_account`), for example, `reporter`, to manage the contributors of Jira issues. And I want to measure the contribution by Jira issue reporters. Here comes the problem: When I get the `from_value` and `to_value` of the field where `field_name = reporter's`. The values are `reporter's names`, not their IDs that I could join the `accounts` table for full user profile. ### Description ## To Do 1. Other Jira issue fields whose `jira_field_type` = `jira_account` in table `issue_changelogs` should be written into table `accounts`. 2. Other Jira issue fields whose `jira_field_type` = `jira_account` in table `issue_changelogs` should be stored in the form of `accounts.id`, not `name`. ### Related issues _No response_ ### Are you willing to submit a PR? - [ ] 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]
