Doctrine override relation accessor

Question

Hi everybody,

I'm using Symfony 1.4 + Doctrine 1.1.

I have a schema with a one-to-many relation. Let's say A has many B, I ask for all the B's of A as follow: $a->b This returns a Doctrine_Collection.

What I want its a way to tell doctrine to give me all the B's of A sorted by a particular attribute of B.

I don't want to re-write the query, I just want to tell the accesor getBs() to sort as I wanted.

Is this possible? any idea?

Tanks in advance!! Alejandro.

Answer 1

What you are looking for is http://www.doctrine-project.org/blog/cookbook-recipe-relation-dql-behavior

It is an example behavior (written by Jon Wage, lead dev of Doctrine), that allows you to include DQL statements into a relation declaration. It's all described in the blogpost so I'll just say I'd recommend putting everything in your lib/doctrine/ (create it if needed) and there you are!