Multi-Search functions
2 posts by 2 authors in: Forums > CMS Builder
Last Post: June 4, 2009 (RSS)
By rentittoday - June 3, 2009
Hello,
We have created a keyword search using a multi-search (attached).
Right now it searches various fields , for example, in the Scooter Rentals table it searches: name, full_description, short_description, company_name, subcategory, metro_area, city, state, zip, country.
If a user types in "Scooter Rentals" it does not pull all items in the scooter rentals category, only those that have "scooter rentals" in the description.
We would like to have the multi-search function search the CMS table names as well. So if a user typed in, for example, scooter rentals it would pull ALL items in the scooter rental category.
I have tried to get it to search tableName, but would always get an error. Is this possible to do? and how? [:)]
thanks,
Lauren
We have created a keyword search using a multi-search (attached).
Right now it searches various fields , for example, in the Scooter Rentals table it searches: name, full_description, short_description, company_name, subcategory, metro_area, city, state, zip, country.
If a user types in "Scooter Rentals" it does not pull all items in the scooter rentals category, only those that have "scooter rentals" in the description.
We would like to have the multi-search function search the CMS table names as well. So if a user typed in, for example, scooter rentals it would pull ALL items in the scooter rental category.
I have tried to get it to search tableName, but would always get an error. Is this possible to do? and how? [:)]
thanks,
Lauren
Jason Glass
Re: [rentittoday] Multi-Search functions
By ross - June 4, 2009
Hi Lauren
Thanks for posting!
The way you have your search setup right now, it's really designed to do the multi table search. If you wanted to have a way to lock it down to just one specific section, I think you would be better off with a separate search.
One would be to do keyword searching in all sections, the other would be to do a search in one specific section.
Now, if you really wanted (or needed) to have this all done in one form, there are some options there too but it will start getting prety tricky.
Let me know what you think and we'll go from there. Thanks!
Thanks for posting!
The way you have your search setup right now, it's really designed to do the multi table search. If you wanted to have a way to lock it down to just one specific section, I think you would be better off with a separate search.
One would be to do keyword searching in all sections, the other would be to do a search in one specific section.
Now, if you really wanted (or needed) to have this all done in one form, there are some options there too but it will start getting prety tricky.
Let me know what you think and we'll go from there. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/