Java Action : no viable alternative at input DateTime field.

0
Hi, I am trying to execute a OQL query from Java action, but for the datetime parameter its giving the error :  no viable alternative at input 'DateTime' "SELECT * FROM QualityMetrics.E_Measurement  where  QualityMetrics.E_Measurement.DateTime > '2020-07-20T00:00:00' "; For the datetime string I used date with no time : ‘2020-07-20’, but the same error.  Is it possible to use datetime in OQL query ? Use case : For months in a year we need to calculate the average of a field. So I thought of doing all the logic in Java Action and frame a response. Please comment. Thanks, Sandeep
asked
1 answers
1

I think it’s just a syntax issue:

QualityMetrics.E_Measurement.DateTime

should be:

QualityMetrics.E_Measurement/DateTime

or just:

DateTime

Here’s a working example that might also be helpful: https://forum.mendix.com/link/questions/101081

 

answered