Skip to Content

odata $filter functions in sap gateway

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 10 at 02:38 PM

    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/

    
    
    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10 at 10:41 AM

    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

    Add comment
    10|10000 characters needed characters exceeded