NEW - Lead Time per PR

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

SELECT
	PR.title,
	JI.status_category_change_date_time as done_datetime,
	JI.status_category_change_date_time - PR.created_date_time as lead_time_created,
	JI.status_category_change_date_time - PR.merged_date_time as lead_time_merged
FROM jira.jira_issues_summary JI
INNER JOIN github.git_pull_requests_summary PR ON JI.key = PR.key
WHERE
	JI.status_name = 'DONE' AND
	JI.team_key IN ($teams) AND
	PR.state = 'closed' AND
	$__timeFilter(JI.status_category_change_date_time)
ORDER BY lead_time_created DESC