Opened 15 years ago
Last modified 11 years ago
#10972 closed
Use Expressions with Annotations — at Initial Version
| Reported by: | Owned by: | ||
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | expression aggregation aggregates annotation |
| Cc: | samt@…, django@…, Alexander Koshelev, miracle2k, meticulos_slacker, bgrand, nwp, Dan Fairs | Triage Stage: | Accepted |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | yes |
| Easy pickings: | no | UI/UX: | no |
Description
It would be nice if expressions could be used inside annotations, i.e. to perform something like the following:
Customer.objects.annotate('total_purchased': Sum(F('customerorderlineitemquantity') * F('customerorderlineitemprice')))
Note:
See TracTickets
for help on using tickets.