Startrekzky opened a new issue, #2122:
URL: https://github.com/apache/incubator-devlake/issues/2122

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### What happened
   
   I set up DevLake v0.11-test version and imported Github and Jira data. 
   When I tried to get Github issue creator's detail by joining table.users. I 
didn't get the full user info, such as organization. Thus, I couldn't tell if 
an issue is created by a community member.
   
   
![image](https://user-images.githubusercontent.com/14050754/172590466-263cc9bd-fefc-4ee2-b2e1-92e53776b5e8.png)
   
   
   ### What you expected to happen
   
   GitHub users appeared in table.users.
   
   ### How to reproduce
   
   1. Set up DevLake main
   2. Collected Github data
   3. Connected to MySQL
   4. Run query
   `select distinct i.creator_id, i.creator_name, u.id, u.name FROM issues i
   left join users u on i.creator_id = u.id`
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   main
   
   ### Are you willing to submit 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]

Reply via email to