Using a like in input parameter with filter expression - SAP HANA

ffzefzef zefzeff 0
Viewed 40

I'm using a input parameter: NumeroAffaire with a filter expression :

"NumAffaire"='$$NumeroAffaire$$'

When I enter specific number (example:000933782201109-1), it will work good!

For example, I'm doing that: enter image description here

Now what I want to do, it's to enter only few number (example:00093378220110)and it show me all possibilites data

So, I think I need to use a LIKE and i'm doing this but don't work:

  "NumAffaire" like '$$NumeroAffaire$$%'

Someone can explain me the correct syntax for using a LIKE in input parameter with a filter

hana sql
1 Answers

It may be worth checking if the usage of LIKE can be replaced with a CONTAINS predicate. The latter should work with SQL parameters.

Mathias Kemeter0
Related