[FLOW3-general] Custom query [sic] - what is the best way?

[Mathias Bolt Lesniak, LiliO Design]

Hi Karsten!

Thanks for the help. I'll try that. :-)


Mathias Bolt Lesniak
LiliO - www.lilio.no
mathias at lilio.com


On 12. jan. 2012, at 11:13, Karsten Dambekalns wrote:

> Hi.
> 
> On 10.01.12 12:40, Mathias Bolt Lesniak, LiliO Design wrote:
>> I'm wondering what the best way is to create a custom Doctrine query. 
> 
> If you want to know how to do custom Doctrine things, this is the answer:
> 
> Make your repository extend …\Doctrine\Repository instead of
> …\Generic\Repository. Then you have $this->entityManager available and
> can use it to access anything from the EventManager to DQL queries.
> 
>> I need to optimize a search in three tables, and the fastest would be to join them (returning identities for the three different tables).
> 
> If your question was how to do joins in DQL, please check the Doctrine
> documentation and/or IRC channel(s). :)
> 
> Regards,
> Karsten
> _______________________________________________
> FLOW3-general mailing list
> FLOW3-general at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow3-general