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

    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