Skip to Content
0

Invalid parametertype used at function 'gt'

Jun 07, 2017 at 11:42 AM

777

avatar image

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
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Veeraraghavan Narasimhan
Jun 07, 2017 at 06:56 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Veera,

I tried with datetime, still it gives me the same error.

I have attached the notepad about metadata of the entity, please check.metadata.txt

BR,
Venky.

metadata.txt (22.9 kB)
0