oop - Order a "sub level" record - ORM -


let's use orm doctrine , symfony2 framework.

whe have 3 entity (a,b,c) related eache other in fashion:

a --[1-m]-- b b --[m-1]-- c 

let's c has attribute (table column) tell correct order of c records (for user display purposes).
finally, have object of a type fetched using orm.

what's best approach - if - return c object ordered starting a ? have write custom query and, so, lose orm characteristics?

notice

if don't problem, let's remember that, retrieve c object, have pass through b objects ordered in different way order field onto c object and, of course, "copy" order onto b object isn't solution

select a, b, c mapping:entitya join a.b b join b.c c order b.prop1 asc, c.prop1 asc 

that's there really. c's belong b ordered, while b's belonging a ordered well.


Comments

Popular posts from this blog

image - ClassNotFoundException when add a prebuilt apk into system.img in android -

I need to import mysql 5.1 to 5.5? -

Java, Hibernate, MySQL - store UTC date-time -