You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@devlake.apache.org by GitBox <gi...@apache.org> on 2022/05/17 08:54:16 UTC
[GitHub] [incubator-devlake] narrowizard opened a new issue, #1895: [jira] assignee data of issue_assignee_history table beyonds users scope
narrowizard opened a new issue, #1895:
URL: https://github.com/apache/incubator-devlake/issues/1895
## Describe the bug
After syncing jira data, I find there are some records of issue_assignee_history.assignee not exists in users table.
```bash
mysql> select distinct issue_assignee_history.assignee
-> from issue_assignee_history
-> left join users on issue_assignee_history.assignee = users.id
-> where users.id is null and assignee != '';
+------------------------------------------+
| assignee |
+------------------------------------------+
| jira:JiraUser:1:5ecfbd0947d31e0c2a15fd83 |
| jira:JiraUser:1:5fab870b7cfc240071f37525 |
+------------------------------------------+
2 rows in set (0.03 sec)
```
## To Reproduce
Steps to reproduce the behavior:
1. Config jira plugin
2. Sync data
3. Query with SQL I provided above.
## Expected behavior
All assignees of issue_assignee_history should be saved in users table, or I cannot find basic info of the assignee.
## Additional context
These user's record also lacked in `_tool_jira_users` table.
--
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: dev-unsubscribe@devlake.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-devlake] warren830 closed issue #1895: [jira] assignee data of issue_assignee_history table beyonds users scope
Posted by GitBox <gi...@apache.org>.
warren830 closed issue #1895: [jira] assignee data of issue_assignee_history table beyonds users scope
URL: https://github.com/apache/incubator-devlake/issues/1895
--
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