Searching a List Box

[richard_chilvers]

I have a list box which uses a calculated field. The data is listed perfectly, but the search function doesn't work - it never returns any values. I'm guessing this is because its a calculated field, but is there a way to make this work?

Thanks for any help.

Richard

[#2]

Richard,

Are you saying that a search in the list box returns no matches in it or that it doesnt reconcile to a selection in the base data?

Could you provide an example?

What version are you using?

Regards,

Gordon

[#3 · Accepted solution]

Hi , from your question i understand that search function is not working when placing the Expression in Listbox.

If that is the question , try below step.

Goto the  Listbox Properties --> General

You can try the "Use Wildcard Search" in Default Search Mode.

I hope this will helpful to you.

Regards

Venkat

[richard_chilvers]

Hi Venkat

Yes, that works. Are you able to tell me why the 'normal' default search method does not work ?

Regards

Richard

[richard_chilvers]

Hi Gordon

Thanks for taking the time to reply.

I am using version 10 and the search in my list box is returning no matches. My expression is:

=IF(MIXMATCH(number, '1','6','7')> 0, option)

You will see that I have now had a helpful answer which works for me, but I'd be interested to know why I had the problem.

Regards

[#6]

Hi ,

Sorry, i don't know exact reason behind this.

But only WildSearch works when we are using expression in listbox.

Regards

Venkat.

[Miguel_Angel_Baeyens]

Hi Richard,

The "Normal Search" only looks for exact matches, hence it doesn't add any wildcards. If you want to look for a range or something you will need to add manually the wildcards (or the expression). The "Wildcard Search" does that exactly. And you can change that to work any time you use that search in the Settings menu, Document Properties, Presentation tab, and selecting the field and the search type.

Or change it in the Settings menu, User Preferences, General tab, so every document you develop has that shearc type by default instead.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[richard_chilvers]

Hi Miguel

My list box shows the values correctly, but even if I enter an exact match into the search field, no results will show. That doesn't seem correct.

Regards

Richard