Doctrine_Core::getTable()->findAll() how to specify order?

php symfony1 doctrine
Jake Wilson picture Jake Wilson · Aug 19, 2011 · Viewed 29.9k times · Source

When using a Doctrine_Table object, is it possible to specify the order of the returned collection when using findAll() or findByWhatever()?

In the doc's I see some stuff about getOrderByStatement() and processOrderBy() but it isn't clear on how to use them...

Answer

Aaron picture Aaron · Mar 25, 2013

You can also leave the first array blank 

  $em->getRepository('BackendDestinyBundle:Destiny')->findBy(array(), array('title'=>'asc'));

Related questions

PHP ORMs: Doctrine vs. Propel

I'm starting a new project with symfony which is readily integrated with Doctrine and Propel, but I of course need to make a choice.... I was wondering if more experienced people out there have general pros and/or cons for …

Read More
How to query NOT NULL with Doctrine?

I have table Test: Test: id | name 1 | aaa 2 | 3 | ccc 4 | aaa 5 | 6 | ddd I want result where name is NOT NULL: aaa ccc aaa ddd How can i get with: Doctrine_Core::getTable('Test')->findBy('name', NOTNULL??) <-doesnt working …

Read More
Why does Doctrine say it can't find the PDO driver?

I tried Symfony 2 today and I tried to play a bit with Doctrine. But when I use the command php app/console doctrine:schema:create in the command line, it returns this error: [PDOException] could not find driver doctrine:schema:…

Read More