Django Rest Framework - Ordering a nested reverse lookup serializer

Question

Is it possible to order/sort a serializer availability that is both a reverse lookup and nested inside unit serializer? For example, I wish to order availability by start_time instead of id.

Below is what I tried but I get .order_by('-start_time')' ^ SyntaxError: invalid syntax

Serializers

class AvailabilitySerializer(serializers.ModelSerializer):
    staff = StaffSerializer() 

    class Meta:
        model = Availability
        fields = ['id','start_time', 'end_time','staff']

class ManagerSerializer(serializers.ModelSerializer):

    class Meta:
        model = Manager
        fields = ['company', 'logo']

class UnitSerializer(serializers.ModelSerializer):
    availability = AvailabilitySerializer(source='availability_set.order_by('-start_time')', many=True)
    manager = ManagerSerializer()


    class Meta:
        model = Unit
        fields = ['id', 'address', 'manager', 'availability']

in your Availability model just try to add ordering = ('-start_time') — Baktiyar Bekbergen
– Baktiyar Bekbergen, Commented Jan 9, 2020 at 4:57

Navid Zarepak · Accepted Answer · 2020-01-09 05:46:09Z

2

You can override the field and provide the serializer with your own queryset and then return the data:

from rest_framework.serializers import SerializerMethodField


class UnitSerializer(serializers.ModelSerializer):
    availability = SerializerMethodField()
    manager = ManagerSerializer()

    class Meta:
        model = Unit
        fields = ['id', 'address', 'manager', 'availability']

    def get_availability(self, instance):
        queryset = instance.availability_set.order_by('-start_time')
        return AvailabilitySerializer(queryset, many=True).data

SerializerMethodField

answered Jan 9, 2020 at 5:46

Navid Zarepak

4,2182 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Max Vallee Over a year ago

That's exactly what I was trying to accomplish! Thank you very much :)

Collectives™ on Stack Overflow

Django Rest Framework - Ordering a nested reverse lookup serializer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related