How can i make the Searchhelp so it searches in any of the Fields of a multy field search?

[former_member705295]

Hi i have this search help:

The Problem is, as soon as i type something into the text field, it only shows entries where the street matches the pattern. But i want it to match the entered pattern in any of those parameters.

For example if i type "SAP" into the text field it should also show customers where just the name is SAP even if the street does not contain the string "SAP".

I have a similar searchhelp for the id where this works just fine. The only difference is the Order of the parameters and the assigned LPos and SPos values.

Can i somehow make the searchhelp return results where any of those parameters matches the entered string?

[Sandra_Rossi]

It can't work this way. If you want one input field to search those 4 fields, you need to have a view which joins the 4 fields into one, or something like that. Be careful about performance. By the way, could you show the example which "works just fine", so that to explain you how it works?

[former_member705295]

This is the example that works. If i type in an id, a name, a street or a city does not matter. It finds the right entry. Maybe because of the Datatype of the ID. Because if i enter a string it does not match the datatype of the id. Maybe then it just goes on and searches for the other values. but if i enter a numeric value it matches the id and returns the entry with that id.

I will have to write my own searchhelp anyway, because i also want to fill all 4 textfields with the corresponding values as soon as an entry is selected. And i don't think this works with the searchhelps i defined up there.

But it would be interesting to see why exactly it works with the id.