public static function getAll($query)
{
$contactSelect = self::_getDisplayResultPattern("c", "name");
$campaignsSelect = self::_getDisplayResultPattern("C", "name");
$queryData = ["SELECT * FROM (\n (SELECT {$contactSelect}, %C, 'Contact' as `type` FROM %T WHERE %C LIKE %~)\n UNION ALL\n (SELECT {$campaignsSelect}, %C, 'Campaign' as `type` FROM %T WHERE %C LIKE %~ OR %C LIKE %~)\n ) %T ORDER BY %C", "name", Contact::tableName(), "name", $query, "name", Campaign::tableName(), "name", $query, "label", $query, "temp", "name"];
$results = DB::getAccessor("defero_db")->getRows(ParseQuery::parse(DB::getAccessor("defero_db"), $queryData));
return $results;
}
private function _db()
{
return DB::getAccessor($this->_dbServiceName);
}
