Customer search function

[Anonymous]

Hello,

For a specific case I need something like a "Conditional reverse Customer Search".

In a first step I want to search for a ZIP Code or City and in a second step I want search the Streets within the first selection.

The result should be a Customer list where a condition (Geo Coordinates shouldn't be empty) is true.

Currently I use a Straight table object for this. But this is not working exactly as wished.

If I select a City the selection of a Street should be limited of the Streets within the selected City.

Any ideas how this could be solved more smart?

Many thanks and best regards,

Claus

[olivierrobin]

hello

if in your model , you have a Relationship between city and Streets, this is done automatically

otherwise, you have to create that relation

[Anonymous]

I have a flat table with all Customer information in my data model.

Zip Code, City and Street are fields within that table.

If I first select a City and in a second step a Street, the related Streets are displayed with a white Background and the other ones with a grey Background.

[olivierrobin]

so it means your data is well organized and QV mechanism works well

then you can create a straight table

and in your expressions, use a set analysis with the condition you want

[Anonymous]

Sure, I use already a straight table for that.

But my initial question is, if there is a smarter solution than that?

Anyway many thanks for your answer!

[olivierrobin]

in my opinion, it's the simplest one and it is using the qv functionalities

[marcus_sommer]

Some records and screenshots which show the input and the current output and also which result is intended would be helpful to give any useful advise.

- Marcus

[Anonymous]

Well currently I use a straight table object with the "Select by Dropdown" functionality for Company selection.

This is working so far, but I am looking for a smarter and maybe more user friendly and clear search possibility.

I discovered today the functionality to hide "Excluded Values in Search". This makes the Search result a bit more transparent.

Further I tried a combination of different Search boxes, one for City, one for ZIP, one for Street and so on...

Overall I'm looking for ideas how create a simple and easy Search functionality.

Best regards,

Claus

[marcus_sommer]

In my opinion the best way to search for values and to select them are the classical listboxes. If there are too many fields they could be put into container. Quite often we have a few on the top with the period- and most important structure-fields and the others are grouped into two or three containers on the left or right. By not direct selecting values else searching for certain ones by starting of typing anything you get a "<<" on the right side with which you get the functionality of the searchbox.

Quite helpful could also be to create special listbox-sheets (without any charts or other stuff) just to see the relation between the field-values and to use the power of gray.

Another important part is the statusbox which should be on each sheet - it showed not only all selected fields/values else you could also clear and alter them there.

I use the dropdowns rather seldom for selections and mostly if I'm just working in this object so that it is easier as look for the right listbox.

- Marcus