Search GUI - URLyBird

Hi folks
I need help to build search GUI. Could you ranchers give some opinion or diferent sugest about that ?
My assiganment say:

It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.
It must present search results in a JTable.

I've created some sketch...like this:

Name:_______________
Location:_______________
[] And [] Or
[Find Button]

1. When user click in find button without enter anything....the system will search the data for all records.
2. When user enter name and location values, it need mark [X]And or []Or box...the system will search name and/or location fields exactly match.
Someone have other sugestions ?
Regards.

Fernando,
It looks like you are on the right track.

I open my application with the table displaying all records. I would agree a search with no checkboxes checked would return all records. I used combo boxes for my approach, one dropdown for location and one for name. Each box has an "any" choice. "Any" + "any" = all. Same theory as yours. I think many others have taken your approach.

In my search GUI I went for a similair approach (B&S 2.3.3).
I created the search panel below the main table, with 6 (non-editable) comboboxes also offering the "Any" choice.
To meet the 'or' requirement I added an 'or' checkbox.

Hi Fernando,

I took a simpler approach: just 2 text fields (1 for "name", 1 for "location"), a search button and a clear button.

This approach results in the following 4 possibilities:

If user leaves both text fields empty, all records are returned

If user enters value in both text fields, only records are returned with exactly same name and exactly same location

If user enters only value in text field "name", only records are returned with exactly the same name

If user enters only value in text field "location", only records are returned with exactly the same location

Kind regards,
Roel