[Django]-DRF: custom ordering on related serializers

by

30👍

✅

Since it is read only, wouldn’t it be just as easy to use a serializer method for that field?

class InstructorSerializer(serializers.ModelSerializer):
    courses = serializers.SerializerMethodField()

    def get_courses(self, obj):
         ordered_queryset = <do your magic here>
         return CourseSerializer(ordered_queryset, many=True, context=self.context).data
👤TheAxeR

12👍

Since Django 1.7, you can specify a queryset for prefetch_related. Using prefetch incurs just one additional database query instead of one per parent object with SerializerMethodField.

from rest_framework import viewsets
from django.db.models import Prefetch

class InstructorViewSet(viewsets.ModelViewSet):
    queryset = Instructor.objects.prefetch_related(Prefetch(
        'courses',
        queryset=Course.objects.order_by('dept', 'number')))
👤Endre Both

0👍

In this case you should modulate the ordering via the viewset queryset. I would imagine the following:

queryset = Instructor.objects.select_related('courses').order_by('courses__number')
👤Roba

-3👍

This should be doable simply by providing an ordered queryset argument to your field declaration:

class InstructorSerializer(serializers.ModelSerializer):
    courses = CourseSerializer(
        queryset=Course.objects.order_by('...'),
        many=True,
        read_only=True,
    )

Further details: http://www.django-rest-framework.org/api-guide/relations/#the-queryset-argument

👤Kobold

Leave a comment