sandesvitor commented on issue #6055: URL: https://github.com/apache/incubator-devlake/issues/6055#issuecomment-1725548766
Nice @Startrekzky ! I'll follow your approach, keepping the `assignee_name` empty for now and updating the dashboard.  ```sql select i.title as incident_name, group_concat(a.assignee_id separator ', ') as responder_id from issues as i inner join issue_assignees as a on (substring_index(i.id, ":", -1) = substring_index(a.issue_id, ":", -1)) group by i.title; ``` -- 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]
