cancel
Showing results for 
Search instead for 
Did you mean: 

Wildcard Character for WEBi Search

JG432
Participant
0 Kudos
126

Hello Community, I am trying to find a wildcard character that will return all inventory numbers beginning with the prefix 'AB' (for example, AB12345, AB12346, AB12347, etc.) I have set my operator to both 'Matches Pattern' and 'In LIst' and typed the input as both 'AB*', and 'AB%' but it does not return any results. Any help on this is greatly appreciated!

JG432_0-1737397067893.png

JG432_1-1737397083888.png

 

View Entire Topic
MichaelGrackin
Contributor

...MATCHES PATTERN... and 'AB%'  should work.

What is your database from which you are pulling data?

Matches Pattern operator | SAP Help Portal

JG432
Participant
0 Kudos
Hi Michael, thanks for the reply. Yes, I have tried that combination as well with no luck. My data source is SAP HANA.
JG432
Participant
0 Kudos
...Might have been a bug in the system, but '%' seems to be working now. Thank you very much for your support!