Issues with timestamp filter

[kkaus]

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.

[Joe Dascole]

Kapil,

 

I see we currently have a case open for this but just wanted to close the loop for anyone else experiencing this problem.

 

This is a known issue in LAC 3.2 which has since been resolved in 4.0. The team is currently looking into a possible workaround. Anyone facing this issue is encouraged to open a support ticket referencing 'DE335735' to check on the status.

 

Regards,

Joe