#1049: Join issue with functions
-----------------------------+--------------------------------------------- -
 Reporter:  guilhermeblanco  |       Owner:  jwage
     Type:  defect           |      Status:  new  
 Priority:  minor            |   Milestone:  0.11.1
Component:  Attributes       |     Version:  0.11  
 Keywords:                   |  
-----------------------------+--------------------------------------------- -
 // Couldn't get short alias for LOWER(lme

 $children = Doctrine_Query::create()
         ->select( 'lnt.id, lnt.name, COUNT(lme.id) AS numElements' )
         ->from( 'LogicalNavigationTree lnt' )
         ->leftJoin( 'lnt.LogicalManagedElement lme WITH LOWER(lme.name)
 LIKE LOWER(?)' )
         ->where( 'lnt.lft > ? AND lnt.rgt < ?' )
         ->execute( array(
                 '%' . ( ( $search == '' ) ? '' : $search . '%' ),
                 $record['lft'], $record['rgt']
         ), Doctrine::HYDRATE_ARRAY );

--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1049>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper