Showing results for 
Search instead for 
Did you mean: 

Filter Expression for Multiple Entries and Is Mandatory

Former Member
0 Kudos

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

Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (0)