Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to Pass Multiple Value Range From Query ?


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?$filter=Maint_Plant 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.




I Have Found solution to the Query posted above.

Please find the URL's below for more clarifications.

Revert for any suggestions please.$filter=Maint_Plant eq 'US19' and ( B_st_dt ge (datetime'2015-02-01T00:00:00') or  B_st_dt le (datetime'2015-02-27T00:00:00'))$filter=Maint_Plant 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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question