Django-graphene query sorting is not working

I have model Event which I want to sort by event_datetime column in resolver, but it doesn't work.

My Event model looks like this:

class Event(models.Model):
    name = models.CharField(db_index=True, max_length=255)
    event_type_id = models.ForeignKey(EventType, on_delete=models.PROTECT, default='friendly match', related_name='events_by_type')
    city = models.CharField(max_length=255, db_index=True, blank=False)
    country = models.CharField(max_length=255)
    place_id = models.ForeignKey(Place, on_delete=models.SET_NULL, null=True, related_name='events_by_place')
    event_datetime = models.DateTimeField()
    tournament_id = models.ForeignKey(Tournament,
                                      on_delete=models.PROTECT,
                                      blank=True,
                                      null=True,
                                      related_name='events_by_tournament')
    description = models.TextField(blank=True)
    organizer = models.ForeignKey(User, on_delete=models.PROTECT, related_name='organizer', blank=True)
    participants = models.ManyToManyField(User, blank=True, related_name='events_by_participant')
    creation_datetime = models.DateTimeField(auto_now_add=True, editable=False)
    update_datetime = models.DateTimeField(auto_now=True)

And my Query object looks like this:

class Query(graphene.ObjectType):
    events_by_organizer = graphene.List(EventType, id = graphene.ID(required=True))

    def resolve_events_by_organizer(root, info, id):
        try:
            return Event.objects.filter(organizer=id).order_by('-event_datetime')
        except Event.DoesNotExist:
            return None

In graphQL I get events query without sorting by event_datetime. How can I sort query in Django-graphene?

Back to Top