src/Sulu/Bundle/ResourceBundle/Entity/FilterRepository.php
protected function getFilterQuery($locale)
    {
        $qb = $this->createQueryBuilder('filter')
            ->addSelect('conditionGroups')
            ->addSelect('translations')
            ->addSelect('conditions')
            ->leftJoin(
                'filter.translations',
                'translations',
                'WITH',
                'translations.locale = :locale'
            )
            ->leftJoin('filter.conditionGroups', 'conditionGroups')
            ->leftJoin('conditionGroups.conditions', 'conditions')
            ->setParameter('locale', $locale);

        return $qb;
    }
protected function getFilterQuery($locale)
    {
        $qb = $this->createQueryBuilder('filter')
            ->addSelect('conditionGroups')
            ->addSelect('translations')
            ->addSelect('conditions')
            ->leftJoin(
                'filter.translations',
                'translations',
                'WITH',
                'translations.locale = :locale'
            )
            ->leftJoin('filter.conditionGroups', 'conditionGroups')
            ->leftJoin('conditionGroups.conditions', 'conditions')
            ->setParameter('locale', $locale);

        return $qb;
    }
protected function getFilterQuery ( $ locale ) { $ qb = $ this -> createQueryBuilder ( 'filter' ) -> addSelect ( 'conditionGroups' ) -> addSelect ( 'translations' ) -> addSelect ( 'conditions' ) -> leftJoin ( 'filter.translations' , 'translations' , 'WITH' , 'translations.locale = :locale' ) -> leftJoin ( 'filter.conditionGroups' , 'conditionGroups' ) -> leftJoin ( 'conditionGroups.conditions' , 'conditions' ) -> setParameter ( 'locale' , $ locale ) ; return $ qb ; }
Returns the query for filters.

@param string $locale The locale to load

@return \Doctrine\ORM\QueryBuilder
Returns the query for filters .