Order by referenced document's field

[D]

Hi!

Is there a way to order a query by a referenced document's field?

Thanks

[Jason Liszka]

Hi, can you give an example? Do you mean ordering by a field of a document referenced by a foreign key? If so, no, mongo does not allow that, since it has no notion of server-side joins.

Regards,

Jason

--
You received this message because you are subscribed to the Google Groups "rogue-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rogue-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[D]

Yes, that's what I meant :(

So no luck? 

Do I have to query for all the results and then manually sort and limit? 

[Jason Liszka]

No, unfortunately. You have to do it in 2 separate queries and sort in memory.

Alternatively, you could denormalize some of the data that lives on the foreign records onto the records you want to sort.