Django1.4: How to use order_by in template?

chobo picture chobo · Feb 13, 2013 · Viewed 11.8k times · Source

Django1.4: How to use order_by in template?

models.py

from django.db import models
from django.contrib.auth.models import User
from django.contrib.contenttypes.models import ContentType
from django.contrib.contenttypes import generic

class Note(models.Model):
    contents = models.TextField()
    writer = models.ForeignKey(User, to_field='username')
    date = models.DateTimeField(auto_now_add=True)

    content_type = models.ForeignKey(ContentType)
    object_id = models.PositiveIntegerField()
    content_object = generic.GenericForeignKey('content_type', 'object_id')


class Customer(models.Model):
    name = models.CharField(max_length=50,)
    notes = generic.GenericRelation(Note, null=True)

Above is my models.py.

I want to use 'order_by'(https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by)

And...

views.py

from django.views.generic import DetailView
from crm.models import *

class customerDetailView(DetailView):
    context_object_name = 'customerDetail'
    template_name = "customerDetail.html"
    allow_empty = True
    model = Customer
    slug_field = 'name'

My views.py use DetailView(https://docs.djangoproject.com/en/1.4/ref/class-based-views/#detailview).

And

customerDetail.html

<table class="table table-bordered" style="width: 100%;">
    <tr>
        <td>Note</td>
    </tr>
    {% for i in customerDetail.notes.all.order_by %}<!-- It's not working -->
        <tr>
            <th>({{ i.date }}) {{ i.contents }}[{{ i.writer }}]</th>
        </tr>
    {% endfor %}
</table>

I want to use order_by in template...

What should I do?

Answer

msc picture msc · Feb 13, 2013

Check out the dictsort filter, it's pretty much what you're looking for I think.