Within CMS - Keyword Search
2 posts by 2 authors in: Forums > CMS Builder
Last Post: July 17, 2009 (RSS)
By rjbathgate - July 15, 2009
Howdy,
Within a normal CMS table, we have the keyword search top left.
I have a field, Client (label) / ContactNum (name), which is a list, and looks up from another table;
So it's displaying Forename, Surname, but the actual value is num.
And this field (contactNum) is in the searching Search Fields.
So the keyword search is searching for the NUM.
Is it possible to have it search the concatenated label value (forename, surname), instead of the value (num).
I can probably get this done with bespoke code, but before I start hacking, wanted to see if there was a built in easier way.
Cheers in advance,
Rob
Within a normal CMS table, we have the keyword search top left.
I have a field, Client (label) / ContactNum (name), which is a list, and looks up from another table;
SELECT num, CONCAT_WS(' ',forename,surname) FROM cms_contacts
So it's displaying Forename, Surname, but the actual value is num.
And this field (contactNum) is in the searching Search Fields.
So the keyword search is searching for the NUM.
Is it possible to have it search the concatenated label value (forename, surname), instead of the value (num).
I can probably get this done with bespoke code, but before I start hacking, wanted to see if there was a built in easier way.
Cheers in advance,
Rob
Re: [rjbathgate] Within CMS - Keyword Search
By Dave - July 17, 2009
Hi Rob,
There's currently no way to have it search the displayed label value, only the stored database value (which would be the num).
But, if you have the latest version you could create another search field for it on the top of the page and it should create a pulldown of names.
Hope that helps!
There's currently no way to have it search the displayed label value, only the stored database value (which would be the num).
But, if you have the latest version you could create another search field for it on the top of the page and it should create a pulldown of names.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com