I'm using Django's postgres-specific ArrayAgg aggregator. It works fine but when the list is empty I get [None] instead of []. Is there any way to filter these null values out? I've tried to pass a...

Please help me I've been stuck on this for way too long :( What I want to do: I have these two models: class Specialization(models.Model): name = models.CharField("name", max_length=64) class ...

Suppose I have a object model A, and it has a field called created, which is a datetime type field. If I use annotate to count how many A are created each day, I can use A.objects.annotate(date=...

From the django docs on annotate(): Annotates each object in the QuerySet with the provided list of query expressions. An expression may be a simple value, a reference to a field on the model ...

I have a Booking model that has start and end datetime fields. I want to know how many days a booking covers. I can do this in Python but I need this value for further annotations. Here's what I'v...

Django's QuerySet has two methods, annotate and aggregate. The documentation says that: Unlike aggregate(), annotate() is not a terminal clause. The output of the annotate() clause is a QuerySet. ...

Consider a table called DataTable. It has two fields: A and B. I want to return all rows from this table, and annotating a field called C which is a concatenation of A and B fields. Here is what I ...

I've got a few models and am trying to speed up the page where I list out users. The issue is that I was leveraging model methods to display some of the data - but when I listed the Users out it wa...

An simplified example of my model structure would be class Corporation(models.Model): ... class Division(models.Model): corporation = models.ForeignKey(Corporation) class Department(models.Mod...

This is a bleeding-edge feature that I'm currently skewered upon and quickly bleeding out. I want to annotate a subquery-aggregate onto an existing queryset. Doing this before 1.11 either meant cus...

Let's say I have the following model structure: Parent(): Child(): parent = ForeignKey(Parent) GrandChild(): child = ForeignKey(Child) state = BooleanField() num = FloatField() I'm trying to f...

Using Django I have a field which is of type JSONField. I am wanting to get a distinct count on a nested key/value in the json. With a normal field you can just do soemthing like the following mo...

I am just learning the geo-django. I can find out the distance of all places from a point. But when I use .values method to the annotated distance field, I am getting TypeError: Object of type 'D...

I'm currently trying to annotate and count some dates, based on the number of times they appear. visits = Subs.objects.filter(camp=campdata, timestamp__lte=datetime.datetime.today(), timestamp__gt...

I have a model called Post which has two fields upvotes and downvotes. Now, upvotes, downvotes are ManyToManyField to a Profile. This is the model: class Post(models.Model): profile = models.Fore...

I am trying to query and annotate some data from my models: class Feed(models.Model): # Feed of content user = models.ForeignKey(User, on_delete=models.CASCADE) class Piece(models.Model): # Piec...

I have a model called 'StoreItem' and a model named 'QuoteItem'. A QuoteItem points on a StoreItem. I'm trying to annotate a counter of how many quote items point on store items, but with conditio...

In the process of finding a solution for Django ORM order by exact, I created a custom django Func: from django.db.models import Func class Position(Func): function = 'POSITION' template = "%(f...

I have the following two models. class Product(models.Model): product_group=models.ForeignKey('productgroup.ProductGroup', null=False,blank=False) manufacturer=models.ForeignKey(Manufacturer, nu...

I'm trying to use django annotation to create queryset field which is a list of values of some related model attribute. queryset = ... qs = queryset.annotate( list_field=SomeAggregateFunction( C...

I have many objects and 3 of them have name='AAA' I group them by 'name' and annotate num in group: my_models = MyModel.objects.order_by('name').values('name').annotate(count=Count('name')) for ...

I need to be able to sort on the aggregate of two annotated columns So I'd like to do something like this: c = c.annotate(metric=Sum('results__metric')) c = c.annotate(metric_prior=Sum('results__...