public function getChangeLogByContentTypeQuery($contentType, array $options)
    {
        $alias = $this->getAlias();
        $contentTableName = $this->em->getRepository($contentType)->getTableName();

        $qb = $this->createQueryBuilder();
        $qb->select("$alias.*, $alias.title")
            ->leftJoin($alias, $contentTableName, 'content', "content.id = $alias.contentid");

        // Set required WHERE
        $this->setWhere($qb, $contentType, $options);

        // Set ORDER BY and LIMIT as requested
        $this->setLimitOrder($qb, $options);

        return $qb;
    }
public function getChangeLogByContentTypeQuery($contentType, array $options)
    {
        $alias = $this->getAlias();
        $contentTableName = $this->em->getRepository($contentType)->getTableName();

        $qb = $this->createQueryBuilder();
        $qb->select("$alias.*, $alias.title")
            ->leftJoin($alias, $contentTableName, 'content', "content.id = $alias.contentid");

        // Set required WHERE
        $this->setWhere($qb, $contentType, $options);

        // Set ORDER BY and LIMIT as requested
        $this->setLimitOrder($qb, $options);

        return $qb;
    }
public function getChangeLogByContentTypeQuery ( $ contentType , array $ options ) { $ alias = $ this -> getAlias ( ) ; $ contentTableName = $ this -> em -> getRepository ( $ contentType ) -> getTableName ( ) ; $ qb = $ this -> createQueryBuilder ( ) ; $ qb -> select ( "$alias.*, $alias.title" ) -> leftJoin ( $ alias , $ contentTableName , 'content' , "content.id = $alias.contentid" ) ; // Set required WHERE $ this -> setWhere ( $ qb , $ contentType , $ options ) ; // Set ORDER BY and LIMIT as requested $ this -> setLimitOrder ( $ qb , $ options ) ; return $ qb ; }
Build query to get content changelog entries by ContentType.

@param string $contentType
@param array  $options

@return QueryBuilder
Build query to get content changelog entries by ContentType .