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;

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