Query filter does not recognize function

Support
#1

Hi

Not sure if I’m doing wrong here, it seems that using ‘extract’ feature in query filter criteria does not work. Is it supported ?

<filter>
                    <and>
                        <c>extract(month from e.date) in :component$monthOptions</c>
                    <and>
</filter>

Output:

JpqlSyntaxException: Errors found for input jpql:[where (extract(month from e.invoice.date) in :component$monthOptions and e.invoice.status in :component$statusOptions)]
CommonErrorNode [<unexpected: [@4,15:19='month',<116>,1:15], resync=extract(month from e.invoice.date>]

Regards
Michael

#3

Hi Michael,
Unfortunately, EXTRACT function doesn’t work with IN condition. We have created an issue: Support JPQL EXTRACT function for IN condition · Issue #2438 · cuba-platform/cuba · GitHub