Skip to Content

Filter Expression for Multiple Entries and Is Mandatory

Hello Folks,

I'm using the Input Parameters in HANA Studio. I want the Filter Expressions for Multiple Entries (Single value - Unchecked), Is Mandatory (Optional - unchecked). Four combinations - for Mandatory - Yes/No , Multiple Values - Yes/No. Appreciate if you provide the same.

For Optional I got the below expression:

if(isnull('$$IP_MATNR$$') or '$$IP_MATNR$$' = '', match("MATNR",'*'), "MATNR" = '$$IP_MATNR$$')

P.S. - Not able to get the solution.


HANA Developer

Add a comment
10|10000 characters needed characters exceeded

  • Maybe you wanna describe a little bit more what you mean with "... Four combinations - for Mandatory - Yes/No , Multiple Values - Yes/No ...".

    And please also described what you expect, respectively what is not working, cause at the moment that information is missing.

  • Thanks Florian for the prompt response.

    I want the filter expression (input parameters for various columns values ) for each of the below case, then only the input parameters will work. Or else, there exists a single expression which will be fulfilled all the below cases.

    Mandatory - Yes

    Mandatory - No

    Multiple Values - Yes

    Multiple Values - No

    My issue is with filter expression and if the expression is not valid, the XS OData file for the corresponding VDM won't be activated.

Assigned Tags

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.