Views in Doctrine ORM

Question

Hello.

I encountered a problem dealing with views in Doctrine.

I have the following view in my database:

$q = Doctrine_Query::create()
                        ->select('c.id, c.name, m.id, m.name, m.status, 
                                  m.modified, m.entered, m.accountid')
                        ->from('Category c')
                        ->leftJoin('c.Mailing m');
$view = new Doctrine_View($q, 'view_mailings');
$q->execute(array(), Doctrine::HYDRATE_ARRAY);

The result comprises of all records. However I need to fetch a subset based on different value for accountid and ordered by different columns. How can I achieve this?

Thanks for your help.

Answer 1

You are just executing the query $q, without using the view you have created.