Pass data into a range table from URL

[#1]

I am currently using BAPI_PRODORDCONF_GETLIST to retrieve a list of production order confirmations, I would like to filter this list for a specific work order. I can do this "manually" via the range table as displayed below, but I would like to pass a specific order # to the service from the URL. I read through some documentation on how to add parameters but does not define how to pass the parameters into a low/high field.

Any help would be greatly appreciated.

Thanks, Paul

[Former Member · Accepted solution]

Hi Paul,

This is very much possible in Gateway to pass the low and high values using $filter option.

fo e.g. if you need to query for orders between 1 and 10 you need to pass

$filter = OrderNo gt '1' and OrderNo lt '10'.

More information in

http://www.odata.org/documentation/uri-conventions#FilterSystemQueryOption

Regards

Gururaj

[paschmann · Accepted solution]

Hi Gururaj,

Thank you, your suggestion is correct and working as expected.

Paul

[juanalves_ · Accepted solution]

$filter = OrderNo ge '1' and OrderNo le '10'. Use ge and le instead of using gt and lt 🙂