[FLOW3-general] Using DQL

[Pankaj Lele]

Hello!

I want to use DQL inside my package for some complex queries.

What I have figured out for using DQL I just need to:

1. Change my repository class to extend
\TYPO3\FLOW3\Persistence\Doctrine\Repository instead of
\TYPO3\FLOW3\Persistence\Repository

2. Write my query with $this->entityManager->createQuery('SELECT x ...
DQL query ');

Is this is a standard and futuristic way?

I tried switching the repository base class to
\TYPO3\FLOW3\Persistence\Doctrine\Repository for one of my repositories
and the paginate widget failed as it was expecting an
TYPO3\FLOW3\Persistence\QueryResultInterface

Is it possible to have the repository class extends
\TYPO3\FLOW3\Persistence\Repository and still use DQL somehow?

Or

Is it ok to have another repository class only for special DQL queries
where I am aware of special features won't work like paginate or content
security at the moment?

Thanks in advance.


-- 

With best regards,
Pankaj Lele
---------------------------

CTO & Executive Director
Lelesys Infotech Pvt. Ltd.
Pune/Goa, India

Web: http://www.lelesys.com

[Certified TYPO3 Integrator]