Jira获取最大Sprint备份

一时失言乱红尘 2022-05-18 06:24 167阅读 0赞

<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.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.pkey, ' 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="getMaxSprintBypname" 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.pname, ' 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="getMaxSprintByADT" 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.pkey, ' scrum')
    	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>