Searching + valuelists

Archived from the Xataface Users forum.

generatedname — Fri Jun 29, 2007 3:12 pm

Couldn’t find anywhere that this is brought up so far:

I use valuelists to populate drop down menus, the list can look something like

AAA = A string for the value
BBB = This is how it looks to user
CCC = Etc

Is there a way to make the search feature check the string representation as well?

Right now, if I search for BBB, all the records that were put in for BBB will come up….I was wondering if its possible for them to come up if I search for “how it looks” instead.

Thanks!

-Kurtis

---

shannah — Sat Jun 30, 2007 3:31 pm

Hi Kurtis,

Right now there isn’t really a way to do this. The search in the top right is a text search - so it only searches varchar and text fields in the table - and only searches the actual data stored in the table - not the valuelist value - unfortunately. The Find form offers an easier way to search on fields like this.

-steve