$tn = $this->tableName();
if (!empty($q['query']['project_search'])) {
$s = $this->escape($q['query']['project_search']);
- $this->whereAdd(" ({$tn}.code LIKE '$s%') OR ({$tn}.name LIKE '%$s%')");
+ $this->whereAdd(" ({$tn}.code LIKE '$s%')
+ OR
+ ({$tn}.name LIKE '%$s%')
+ OR
+ join_client_id_id.name LIKE '%$s%'
+ ");
}
// types of project to list ... - default is only the open ones...
if (!empty($q['query']['project_indaterange'])) {
// DB_DataObjecT::debuglevel(1);
$this->selectAdd();
$this->selectAdd('distinct(client_id)');
- $this->selectAs(DB_DataObject::factory('Companies'), 'client_id_%s','join_client_id_id');
+ $this->selectAs(DB_DataObject::factory('core_company'), 'client_id_%s','join_client_id_id');
$this->groupBy('client_id');
}