Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a user who wants to search a wildcard search field with multiple items.
We tried *item number1* | * item number2* | *item number3*, but had no luck.
as well as *item number1* & *item number2* & *item number3* with the same results.
It will work if we don't have the wild card search in there, but unfortunately they'll need it. Is this possible?
Use Wildmatch function...
Like
wildmatch (field name, '*itemnumbet*', *itemnumber2*')
May be this
("*item number1*"|"*item number2*"|"*item number3*")
I think you are suggesting wildmatch -
wildmatch( M, 'ja*','fe?','mar')
instead try this ?
Goto the Listbox Properties --> General
You can try the "Use Wildcard Search" in Default Search Mode
I'm not looking for wildcard match. I'm referencing the object the user is searching on, i.e. they click a multi-box drop down and start typing to search for a field. They are using the wildcard search by adding * before and after the data they are searching for.
Yes, this is what i'm referring to, it will default the * before and after the search criteria. However, it's only allowing to search one item when the user needs to create a bookmark with hundreds.
I tried this and it didn't work as well.
Look here
Sunny's search term using the compound search should work.
You need to enter the compound search exactly as shown.