#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
