Opened 11 years ago
Last modified 11 years ago
#24065 closed Bug
aggregate dont find column of annotate — at Initial Version
| Reported by: | mateuspadua | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 1.7 |
| Severity: | Normal | Keywords: | aggregate annotate fielderror |
| Cc: | mateuspaduaweb@… | Triage Stage: | Unreviewed |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
If we try this query, everything works normally
Entry.objects.annotate(num_authors=Count('authors')).aggregate(Avg('num_authors'))
but if we try the one below, it does not find the column authorscount' to the aggregation
Entry.objects.annotate(Count('authors')).aggregate(Avg('authors__count'))
I believe it is a problem because the exception tells us we could use the column 'authorscount'
This is what the exception says:
FieldError: Cannot resolve keyword 'count' into field. Choices are: email, entry, id, name, authorscount <- see the field here.
Thanks.
Note:
See TracTickets
for help on using tickets.