Question
How to query data in ER applying function on a specific field
Hi,
I was wondering if it is possible to query some data with an ER applying function on a specific field ?
I would like to do something like this (of course, "function" attribute does not exist) :
a!queryFilter(
field: "end_date",
function: "month", /* month(end_date) */
operator: "<=",
value: 10
),
Of course, I would like to avoid to have to create an intermediate view or stored procedure... and avoid to loop over each line of my data to make the comparison.
Is there a simple solution ?
Regards
