Experiences with SAP Gateway

"My foots always in my mouth i just can't stomach defeet" – Hilltop Hoods

Filter String Gotcha

with one comment

.. the Logical Operators ‘eq’,’ne’,’le’,’lt’,’ge’,’gt’ and the String functions ‘substringof’, ‘startswith’, ‘endswith’ are supported currently.
[SOURCE : SAP Note 1574568 – SAP NetWeaver Gateway 2.0 – Known Constraints ]

On their own both the Logical Operators and String Functions work fine.

In Method GET_ENTITYSET the Logical Operator get appended to the IT_FILTER_SELECT_OPTIONS and the String function are put into IV_FILTER_STRING.

When you combine both Logical Operators and String functions

eg. /Suppliers?$filter=City eq ‘London’ and startswith(SupplierName,’A’)

The logical operators are not parsed into IT_FILTER_SELECT_OPTIONS  instead they are included in IV_FILTER_STRING

Advertisements

Written by rsol1

January 17, 2012 at 11:56 am

Posted in Uncategorized

Tagged with , , ,

One Response

Subscribe to comments with RSS.

  1. […] Today I was asked during a demo to share how I use IV_FILTER_STRING and get round the Filter String Gotcha […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: