Skip to Content
0

odata $filter functions in sap gateway

Aug 10 at 06:45 AM

54

avatar image

Hi,

I'm publishing a CDS View with the annotation @OData.publish: true
Is it possible to call the service with filter funcitons?

For example:
$filter=Name eq 'Test' works great but $filter=toupper(Name) eq 'TEST' doesn't.


I get the error code /IWBEP/CM_MGW_RT/176.

Any ideas?
Thanks, Thomas

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Andre Fischer
Aug 10 at 02:38 PM
0

It is not supported.

But you can implement it yourself as described in my blog.

Hope you like it.

https://blogs.sap.com/2018/08/10/how-to-implement-support-for-toupper-and-tolower-in-filter/


Show 1 Share
10 |10000 characters needed characters left characters exceeded

Does not work on abap 750. No chance to update so unfortunately useless for me

0
Gregor Wolf
Aug 10 at 10:41 AM
0

Hi Thomas,

there is SAP Note: 2367553 - ODataQuery features and limitation but unfortunately it doesn't mention toupper. Perhaps Andre Fischer has any pointer.

Best regards
Gregor

Show 1 Share
10 |10000 characters needed characters left characters exceeded
0