Hi,
I have a Forum-table and a related Post-table.
In my "overview"-view I display a list of all the latest posts for each
forum.
My current solution goes something like this:
posts = []
for f in Forum.objects.all().order_by('name') :
posts += Post.objects.filter(forum=f).order_by('-posted').first()
# the 'posts' variable is pushed into the view context for display
Obviously this isn't optimal..
It would be more efficient if the above could be made into a single
query, but I can't figure out how.
I found some solutions through Google, but so far it is aggregations
using values() and Max() which doesn't allow me to return a query-set to
the list-view. (Or maybe it does, but I have yet to learn how).
So any pointers or hints are much appreciated.
I use Django 1.11 and sqlite.
Thanks.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/0614bdd6-1a48-b8c0-305d-472cb9c7a8b9%40x76.eu.
For more options, visit https://groups.google.com/d/optout.
