Jira获取最大Sprint备份

最新推荐文章于 2021-12-12 22:18:28 发布

intelrain

最新推荐文章于 2021-12-12 22:18:28 发布

阅读量609

点赞数

分类专栏： Jira 文章标签：备份

本文链接：https://blog.csdn.net/intelrain/article/details/81297310

版权

<select id="getMaxSprint" resultType="java.lang.Integer" parameterType="java.lang.String">
  SELECT MAX(CONVERT(tableone.sprintname, SIGNED)) AS sprintname
FROM (
	SELECT p.pname, rv.NAME AS boardname
		, LEFT(substring_index(s.NAME, 'Sprint', -1), 5) AS sprintname
		, s.STARTED, s.CLOSED
	FROM zendtao_new.ao_60db71_sprint s
		LEFT JOIN zendtao_new.ao_60db71_rapidview rv ON s.RAPID_VIEW_ID = rv.ID
		LEFT JOIN zendtao_new.project p ON rv.NAME = CONCAT(p.originalkey, ' board')
	WHERE (p.pname IN (
			SELECT pname
			FROM zendtao_new.custompdu
		)
		AND s.started = 1
		AND s.closed = 1
		AND p.pname = #{pduName,jdbcType=VARCHAR})
) tableone
ORDER BY CONVERT(tableone.sprintname, SIGNED) DESC
    </select>
 
 <select id="getMaxSprintBypkey" resultType="java.lang.Integer" parameterType="java.lang.String">
  SELECT MAX(CONVERT(tableone.sprint