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