On Monday, 13 July 2015 01:50:11 UTC+1, Andrea wrote:
>
> Hello. I'm new to both django and python. Been trying to figure out how to
> group items from a model for hours now.
>
> This in an example code i made up to illustrate my problem:
> # Models
> class Book(models.Model):
> submitted_by = models.ForeignKey(settings.AUTH_USER_MODEL,
> related_name='book_subby')
> submitted_date = models.DateField(auto_now=True)
> book_title = models.CharField(max_length=200)
> book_publisher = models.ForeignKey(Publishers)
>
> class Publishers(models.Model):
> submitted_by = models.ForeignKey(settings.AUTH_USER_MODEL,
> related_name='publisher_subby')
> submitted_date = models.DateField(auto_now=True)
> book_publisher = models.CharField(max_length=200)
>
> # View
> def book_list(request):
> books = Book.objects.filter(submitted_by=request.user,
> submitted_date__lte=timezone.now()).order_by('submitted_date')
>
> return render(request, 'book/list_books.html', {
> 'books': books
> })
>
> # Template list_books.html
> {% for book in books %}
> <ul> {{ book.book_publisher }}
> <li> {{book.book_title }} </li>
> {% endfor %}
>
> This displays:
>
> Publisher X
> * Book A
> Publisher Y
> * Book B
> Publisher X
> * Book C
> Publisher Y
> * Book D
>
> I want to display:
> Publisher X
> * Book A
> * Book C
> Publisher Y
> * Book B
> * Book D
>
> I tried doing multiple for loops in the template, but couldn't make it
> work.
> I would appreciate it alot if someone could nudge me in the right
> direction on how to solve this.
> Thanks, Andrea
>
There are several ways of doing this. One is to sort by Publisher first:
books =
Book.objects.filter(...).select_related('book_publisher').order_by('book_publisher__book_publisher',
'submitted_date')
and use the {% ifchanged %} tag to only print the publisher name when it
changes:
{% for book in books %}
{% ifchanged %} {{ book.book_publisher }} {% endif changed %}
<li> {{book.book_title }} </li>
{% endfor %}
--
DR.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/d6249df1-3566-4fa3-82c6-fc49b52e56cb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
