Startrekzky commented on issue #1681: URL: https://github.com/apache/incubator-devlake/issues/1681#issuecomment-1181684386
Hi @hezyin @keon94 I think we're on the same page about the epic collection and enrichment flow. In terms of the following point, it's a design that I'm already aware of. But this won't be a problem, as the query logic will be 'boards' -> 'board_issues' -> 'issues (non-epic)' -> 'issues (epic)'. In this way, we can use boards to filter non-epic issues and get the epic that these issues belong to. As a result, we can get epic-level metrics, ie. strategic and non-strategic issue ratio. > 4. If foreign epic issues don't have corresponding entries in _tool_jira_board_issues, then we need to be careful when writing SQL queries for dashboards since right now many SQL queries use a board as a filter. @Startrekzky > > Please advise if there's any misunderstanding in the summary above. @klesh @Startrekzky @terrymanu @keon94 -- 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]
