Skip to Content

SAP Hana Web IDE Calculation View filter expressions (LIKE '%SCHMI%')

Oct 04, 2017 at 10:15 AM


avatar image


I try to find out, how we have to use the filter expressions, if we want to use i.e. WHERE "NNAMS" LIKE '%SCHMI%'.

Is there a way to do the same within the filter expressions?



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

1 Answer

Best Answer
Florian Pfeffer
Oct 04, 2017 at 12:05 PM

I think what you are searching for is the "match" function which you can use in filter expressions.

For instance (consider that the stars before/after the parameter name are necessary to get the same behavior like you get with % for the like predicate):

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

Thanks a lot! This works!

Only one more question, if I have two parameters and only one of them would be set.

Look for an "if else statement" solution. Tried this:


But "Expression is not valid"


For that you need to use the IF function.

For instance:

if($$PAR1$$ == '', match("COL2", '*$$PAR2$$*'), match("COL1", '*$$PAR2$$*'))

very nice, thank you!