Subversion Repositories SmartDukaan

Rev

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

Rev 5909 Rev 7636
Line 117... Line 117...
117 
  <select id="getOpenTicketsMap" resultType="map">
 117 
  <select id="getOpenTicketsMap" resultType="map">
118 
  	SELECT category, count(*) as count
118 
  	SELECT category, count(*) as count
119 
  	FROM ticket
119 
  	FROM ticket
120 
  	<where>
 120 
  	<where>
121 
  		status IN ('OPEN','REOPEN')
 121 
  		status IN ('OPEN','REOPEN')
- 
 
 122 
  		AND category IS NOT NULL
122 
  	</where>
 123 
  	</where>
123 
  	group by category
 124 
  	group by category
124 
  </select >
 125 
  </select >
125 
</mapper>
 126 
</mapper>