django.contrib.postgres.aggregates.JSONBAgg does not support ordering

[john-parton]

Here's a contrived example:

class Author(models.Model):
    name = models.CharField(max_length=50)
    alias = models.CharField(max_length=50, null=True, blank=True)
    age = models.PositiveSmallIntegerField(default=30)


class Article(models.Model):
    authors = models.ManyToManyField(Author, related_name='articles')
    title = models.CharField(max_length=50)
    
    
Article.objects.annotate(
    authors_json=JSONBAgg(
        Func(
            Value('name'), 'name',
            Value('alias'), 'alias',
            function='jsonb_build_object'
        ),
        ordering='age'
    )
)

The ordering kwarg is ignored, but Postgres would have no problem understanding the aggregate with an ORDER BY clause

In my code I did the following

class OrderableJSONBAgg(OrderableAggMixin, JSONBAgg)
    pass
    
    
from myapp.aggregates import OrderableJSONBAgg as JSONBAgg

I believe adding that mixin is all that would be required to add this functionality.