On Apr 12, 4:01 pm, David <cthl...@gmail.com> wrote: > The above ORM statement however does not look as elegant to read as I have > come to expect from Django though. The resulting SQL doesn't seem too > shabby however.
.distinct(fields) + .order_by() is pretty low level stuff - that is why it would be nice if there was a dedicated API for queries like this. Something like: > qs.first_related('log', order_by='-modified_on') OUT: qs annotated with log entries. Turning that into efficient and cross-DB compliant SQL isn't the easiest thing to do. If you want N first objects instead of one, then it is going to be even harder. - Anssi -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.