Skip to Content

Invalid parametertype used at function 'gt'

Hi, I am using the Request URI in sap gateway client transaction as below:

/sap/opu/odata/sap/Servcie/Entityset?&$filter=((Property1 eq 'O2C_1') and (PropertyFrmDateTime gt datetimeoffset'2017-06-10T12:00:00Z'))

I receive a 400 Bad request error:

<message xml:lang="en">Invalid parametertype used at function 'gt' (Position: 75)</message>

Anything wrong with gt(greaterthan) keyword ?

BR,
Venky.

SAPUI5 | le | eq | gt
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 07, 2017 at 06:56 PM

    Hello Venky,

    I checked with sample odata service url . This one works

     http://services.odata.org/V2/OData/OData.svc/Products?$format=json&$filter=ReleaseDate gt datetime'1995-09-01T00:00:00' and ReleaseDate lt datetime'1995-12-01T00:00:00'            

    I can see using datetimeoffset could be the culprit. Can you provide the metadata your entity. We might need to check the entity type. Else the above url might work.

    Thanks and Regards,

    Veera

    Add comment
    10|10000 characters needed characters exceeded