Beispiel #1
0
 /**
  * Query using outer on automatic join
  * @return <type>
  */
 public function criteriaCommand14()
 {
     $setor = new Setor();
     $criteria = $setor->getCriteria("select nome, count(usuarios.idUsuario) " . "where login like 'A%' " . "group by nome " . "having count(usuarios.idUsuario) = 0")->setAssociationType('usuarios', 'left');
     return $criteria;
 }