How can I use a data type parameter in the query function on the floor?

[claudneysessa]

How can I use a data type parameter in the query function on the floor?

[claudneysessa]

Example:

Does not work

@query("""
SELECT Coleta.*,
( select sum(ItemColeta.PD_QTD)
from ItemColeta
where ItemColeta.MCO_COD = Coleta.MCO_COD
) as MCO_TOTAL
FROM Coleta
WHERE MCO_DTAGENDA <= :data ================> Does not work
and MCO_STATUS = :status
ORDER BY MCO_DTCOLETA
""")
Future<List> findStatusDataMenor(int status, String data);

This code above does not work, but if I put it directly the value works

@query("""
SELECT Coleta.*,
( select sum(ItemColeta.PD_QTD)
from ItemColeta
where ItemColeta.MCO_COD = Coleta.MCO_COD
) as MCO_TOTAL
FROM Coleta
WHERE MCO_DTAGENDA <= "2020-08-01" =====> OK
and MCO_STATUS = :status
ORDER BY MCO_DTCOLETA
""")
Future findStatusDataMenor(int status);

[mqus]

Please elaborate. What do you mean with "does not work"? Do you get an error message?
I noticed one thing in your example though: we currently only support parameters being referenced in the same order as they're specified in the function(#224). This is being worked on in #361. So the first example might work if you use

@query("""
SELECT Coleta.*,
( select sum(ItemColeta.PD_QTD)
from ItemColeta
where ItemColeta.MCO_COD = Coleta.MCO_COD
) as MCO_TOTAL
FROM Coleta
WHERE MCO_DTAGENDA <= :data
and MCO_STATUS = :status
ORDER BY MCO_DTCOLETA
""")
Future<List> findStatusDataMenor(String data, int status);

(Btw, the Future<List> bit is also not correct but I assume that you are just omitting the details here)

[claudneysessa]

Thanks for the guidance I didn't pay attention to the order of the parameters and this was the problem, thank you very much!

[claudneysessa]

Please elaborate. What do you mean with "does not work"? Do you get an error message?
I noticed one thing in your example though: we currently only support parameters being referenced in the same order as they're specified in the function(#224). This is being worked on in #361. So the first example might work if you use

@query("""
SELECT Coleta.*,
( select sum(ItemColeta.PD_QTD)
from ItemColeta
where ItemColeta.MCO_COD = Coleta.MCO_COD
) as MCO_TOTAL
FROM Coleta
WHERE MCO_DTAGENDA <= :data
and MCO_STATUS = :status
ORDER BY MCO_DTCOLETA
""")
Future<List> findStatusDataMenor(String data, int status);

(Btw, the Future<List> bit is also not correct but I assume that you are just omitting the details here)

Thanks for the guidance I didn't pay attention to the order of the parameters and this was the problem, thank you very much!

[claudneysessa]

Solved!