Layer 7 API Management

Expand all | Collapse all

Issues with timestamp filter

Jump to Best Answer
  • 1.  Issues with timestamp filter

    Posted 12-12-2017 11:58 PM

    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.

  • 2.  Re: Issues with timestamp filter
    Best Answer

    Posted 12-22-2017 11:33 AM



    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.