Question Re: OData: Datetime filter to select option (high and low) in Technology Q&A

OData: Datetime filter to select option (high and low)

Former Member — Fri, 03 Feb 2017 10:34:11 GMT

Hi All,

I am trying to fetch values in between the specified range. In the query if I pass as LT and GT then I am unable to fetch the range since only the initial parameter is being selected to fetch the records.

I have googled alot but couldnt find solution for this.

Since this is a standard component where I am trying to pass the value and since I cannot edit the values, I am posting the question here.

My service: Accounts(AccountID='0100000342')/PaymentDocuments?$filter=(ExecutionDate gt (datetime'2016-10-01T00:00:00') or ExecutionDate lt (datetime'2016-12-01T00:00:00'))

Please guide.

Thanks,

Srihari.

Re: OData: Datetime filter to select option (high and low)

janosdezsi — Mon, 20 Nov 2017 16:40:37 GMT

Hi,

Please check KBA 2370618 - SAP Gateway $filter value not handed over correctly to the backend

Thanks,
Janos

Re: OData: Datetime filter to select option (high and low)

Joseph_BERTHE1 — Wed, 22 Nov 2017 05:14:13 GMT

hello,

In addition of janos.dezsi remove ( and ) from your query :

Accounts(AccountID='0100000342')/PaymentDocuments?$filter=ExecutionDate gt (datetime'2016-10-01T00:00:00') or ExecutionDate lt (datetime'2016-12-01T00:00:00')

Reagrds,