<div class="codebody" id="code96843">
public function addNameColumnQuery(Doctrine_Query $query,$field,$values)
{
if (is_array($values) && isset($values['text']) && '' != $values['text'])
{
$query->leftJoin('r.Translation t')
// ->andWhere('t.lang = ?',$especify_one_language) // or it will search in all of them
->andWhere('CONCAT(t.name,t.shortname) like ?','%' . $values['text'] . '%');
}
}