Skip to Content
1
Former Member
Jan 25, 2018 at 09:45 AM

How to use OData Date filter query to filter data from OData NetWeaver Gateway Service?

817 Views Last edit Jan 25, 2018 at 06:32 AM 2 rev

Hello,

I am trying to use the OData Filter query. to filter data records from the OData Service, using Date range for filters.

Please check the below URL for the SAP's sample OData Service, with filter option.

Service Query URL :

https://orderdb.herokuapp.com/orders.svc/Orders?$filter=OrderDate+ge+datetime%271996-07-04T00:00:00%27

It gives out following error :->

<message xml:lang="en">Invalid filter expression: 'OrderDate ge datetime'1996-07-04T00:00:00''</message>

Please let me know, if there is any mistake in the Query or is there anything that needs to be done on the
Backend Service.

Thanks & Regards,

Avish Kumar