Hi all!, i write a simple example to compare a range of dates, this is the method:
<query> <query-method> <method-name>findByDate</method-name> <method-params> <method-param>java.lang.Integer</method-param> <method-param>java.util.Date</method-param> <method-param>java.util.Date</method-param> </method-params> </query-method> <declared-sql> <where><![CDATA[ idPaciente = {0} AND fecha >= {1} AND fecha <= {2}]]></where> </declared-sql> <read-ahead> <strategy>none</strategy> </read-ahead> </query>
SELECT * FROM IMAGEN WHERE idPaciente = {0} AND fecha >= {1} AND fecha <= {2}