Search not working

[cbrman97]

Hello.
I have 2.1.8 installed fine. I've created a form and entered 3 records. Every field in my form is set to be searchable. When I view the form, I see all 3 records. fF I search by the field called "Agent Name" to narrow down the records, it says no records match the criteria. That can't be right when you can clearly see Agent Names of all 3 records when viewing "All Records".

To see it:
1) go to eneix.com/forms
2)user: BE
pass: Online71

View the 3 records. Then search the "Agent Name" field for "Chris". There are 2 records for Chris but the search shows no records found.

What am I missing?!?

Thanks for the help!

[Ben]

Hi cbrman,

Ahh... it searches by the option list *value*, not what's being displayed in the dropdown. In your case, the "Agent" dropdown has numeric values for each agent (e.g. Chris = 2), so you need to search by the numeric value to find all of Chris's results.

NOT exactly terrific. Hmm... I'm going to log this as a bug. What should really happen is that the search bar should show a second dropdown containing all the valid values. Or, worst-case, search on the displayed values.

In the meantime, can you change the Option List to store strings for the Option List values instead of the numeric ones? Or are you using a Client Map filter - or have some other reason for the numeric values?

- Ben

[cbrman97]

Ben,
I figured this out while I was waiting for a response. It cost me what little hair I have left!

you are exactly right and I "fixed" it by changing all the values to match the name. I had several options lists to update that way.

Thank you for the response. It doesn't help I'm new to php and mysql or I would have figured it out sooner.

Your suggestions for change sound like a fantastic idea!!

Thanks again!

Bill