Subversion Repositories SmartDukaan

Rev

Rev 5168 | Rev 7636 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5168 Rev 5909
Line 111... Line 111...
111 
        AND category = #{ticketCategory}
 111 
        AND category = #{ticketCategory}
112 
    </if>
 112 
    </if>
113 
    </where>
 113 
    </where>
114 
    ORDER BY openDate
 114 
    ORDER BY openDate
115 
  </select>
 115 
  </select>
- 
 
 116
- 
 
 117 
  <select id="getOpenTicketsMap" resultType="map">
- 
 
 118 
  	SELECT category, count(*) as count
- 
 
 119 
  	FROM ticket
- 
 
 120 
  	<where>
- 
 
 121 
  		status IN ('OPEN','REOPEN')
- 
 
 122 
  	</where>
- 
 
 123 
  	group by category
- 
 
 124 
  </select >
116 
</mapper>
 125 
</mapper>