I am encountering an incorrect behaviour from your side when filtering with datetime columns. For example, see the JSON below:
"where": "isDeleted = false AND (dateLastModified < 1464452509857)",
In the response, there is a record with the dateLastModified=1464452509857, which should be filtered out.
I am testing above the ActivityGoalConfiguration entity, but the same thing happened also with JobOrder entity, and I suppose it is an issue will all the entities that use JPQL queries.
The same behaviour is with the '>' operator.
So to conclude, both '<', '>' are treated as '<=', '>=' respectively on datetime fields.
Am I missing something here?