Auto-complete not searching multiple fields
-
cbrent
- Profound User
- Posts: 24
- Joined: Tue Oct 12, 2010 1:33 pm
- First Name: Clint
- Last Name: Brent
- Company Name: Invue Security Products
- Phone: 704-752-6513 x342
- Contact:
Auto-complete not searching multiple fields
It appears that the database driven textbox auto-complete function is not searching multiple fields. I have two fields listed in choice options field that are comma separated. When entering text only the first field is being searched. The second field is displayed to the right but is not searchable.
-
Brian
- Profound Logic Staff Member
- Posts: 286
- Joined: Thu Apr 14, 2011 10:23 am
- First Name: Brian
- Last Name: May
- Company Name: Profound Logic Software
- Contact:
Re: Auto-complete not searching multiple fields
You are correct. This is by design.
If you need it to search both columns you can concatenate them into one. The auto complete functionality is building SQL statements in the background to search for your matches. So you can put the two columns together using something like this:
TRIM(FIELD1) || ' ' || FIELD2
This will display both fields separated by a blank, but also allow both to be searched.
If you need it to search both columns you can concatenate them into one. The auto complete functionality is building SQL statements in the background to search for your matches. So you can put the two columns together using something like this:
TRIM(FIELD1) || ' ' || FIELD2
This will display both fields separated by a blank, but also allow both to be searched.
Who is online
Users browsing this forum: Ahrefs [Bot] and 1 guest