How to Pass Multiple Value Range From Query ?

[former_member184614]

Hi,

I have searched over SDN to find about how do we pass multiple value ranges from Query to SAP ODATA?

But I have not found suitable answers so I am posting it here.

If we need to pass a date parameter in Query which has a multiple range like  sales orders created date between 03/02/2014 to 05/07/2014.

How do we phrase it in Query ?

I tried as below but the IT_FILTER_SELECT_OPTIONS of /IWBEP/IF_MGW_APPL_SRV_RUNTIME~GET_ENTITYSET does not get filled up with the parameters

How do we pass multiple values in Query?

http://ctnhsapapp16.corp.ken.com:8000/sap/opu/odata/sap/ZCHAKRABK_MAINT_ORDERS_SRV/Maint_Orders?$fil... eq 'US19' and B_st_dt gt datetime'2015-02-01T00:00:00' and B_st_dt lt datetime'2015-02-28T00:00:00'

Thanks in Advance.

KC.

[former_member184614 · Accepted solution]

Hi,

I Have Found solution to the Query posted above.

Please find the URL's below for more clarifications.

Revert for any suggestions please.

http://ctnhsapapp16.corp.ken.com:8000/sap/opu/odata/sap/ZCHAKRABK_MAINT_ORDERS_SRV/Maint_Orders?$fil... eq 'US19' and ( B_st_dt ge (datetime'2015-02-01T00:00:00') or  B_st_dt le (datetime'2015-02-27T00:00:00'))

http://ctnhsapapp16.corp.ken.com:8000/sap/opu/odata/sap/ZCHAKRABK_MAINT_ORDERS_SRV/Maint_Orders?$fil... eq 'US19' and ( B_st_dt ge (datetime'2015-02-01T00:00:00') and  B_st_dt le (datetime'2015-02-27T00:00:00'))

Thanks KC.