Subversion Repositories SmartDukaan

Rev

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

Rev 3269 Rev 3339
Line 20... Line 20...
20 
    SELECT * FROM activity
 20 
    SELECT * FROM activity
21 
    WHERE customerId = #{customerId}
 21 
    WHERE customerId = #{customerId}
22 
    ORDER BY creationTimestamp DESC
 22 
    ORDER BY creationTimestamp DESC
23 
  </select>
 23 
  </select>
24 
 
 24 
 
- 
 
 25 
  <select id="getActivitiesByCreator" parameterType="long" resultType="activity">
- 
 
 26 
    SELECT * FROM activity
- 
 
 27 
    WHERE creatorId = #{creatorId}
- 
 
 28 
    ORDER BY creationTimestamp DESC
- 
 
 29 
  </select>
- 
 
 30 
 
25 
  <select id="getActivitiesForTicket" parameterType="long" resultType="activity">
 31 
  <select id="getActivitiesForTicket" parameterType="long" resultType="activity">
26 
    SELECT * FROM activity
 32 
    SELECT * FROM activity
27 
    WHERE ticketId = #{ticketId}
 33 
    WHERE ticketId = #{ticketId}
28 
    ORDER BY creationTimestamp DESC
 34 
    ORDER BY creationTimestamp DESC
29 
  </select>
 35 
  </select>