Subversion Repositories SmartDukaan

Rev

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

Rev 3546 Rev 3578
Line 59... Line 59...
59 
  </update>
 59 
  </update>
60 
 
 60 
 
61 
  <select id="getUnassignedTickets" resultType="ticket">
 61 
  <select id="getUnassignedTickets" resultType="ticket">
62 
    SELECT * FROM ticket
 62 
    SELECT * FROM ticket
63 
    WHERE assigneeId IS NULL
 63 
    WHERE assigneeId IS NULL
64 
    AND category != 'COD_VERIFICATION'
 - 
 
65 
    ORDER BY openDate DESC
 64 
    ORDER BY openDate DESC
66 
  </select>
 65 
  </select>
67 
 
 66 
 
68 
  <select id="getTickets" parameterType="searchFilter" resultType="ticket">
 67 
  <select id="getTickets" parameterType="searchFilter" resultType="ticket">
69 
    SELECT *
 68 
    SELECT *