NEW - Deploy

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

SELECT
	MIN(version_name) AS version,
	version_id,
	MIN(team_key) AS team,
	MIN(status_category_change_date) + interval '3 hour' AS deploy_date
FROM 
	jira.jira_issues_summary
WHERE
	status_name = 'DONE' AND
	team_key IN ($teams) AND
	version_id IS NOT NULL
GROUP BY version_id
HAVING MIN(status_category_change_date) BETWEEN $__timeFrom() AND $__timeTo()
ORDER BY deploy_date