AnsweredAssumed Answered

Issues with timestamp filter

Question asked by kkaus on Dec 13, 2017
Latest reply on Dec 22, 2017 by dasjo02

When I am hitting the resource in the way as given in the

 

 .../Customer?sysfilter=greaterequal(order_date: timestamp(2015-10-28T13:00:00.000-0800))

 I am getting following error -

 

{
"statusCode": 500,
"errorCode": 5004,
"errorMessage": "Internal server error: Filter error: Filter has incorrect format: bad timestamp value for created_at of '2015-10-28T13:00:00.000-0000' at position 25"
}

 

Then I have changed the timestamp value by removing the timezone - 

 

 .../Customer?sysfilter=greaterequal(order_date: timestamp(2015-10-28T13:00:00))

 

Then I got - 

 

{
"statusCode": 500,
"errorCode": 5004,
"errorMessage": "org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of com.kahuna.util.SimpleTimestamp. Use setObject() with an explicit Types value to specify the type to use.",
"helpUrl": null
}

 

 

What I am missing here? Please help.

Outcomes