#35146: Add support for annotate after union -------------------------------------+------------------------------------- Reporter: Alexandru | Owner: nobody Chirila | Type: New | Status: new feature | Component: Database | Version: layer (models, ORM) | Severity: Normal | Keywords: Triage Stage: | Has patch: 0 Unreviewed | Needs documentation: 0 | Needs tests: 0 Patch needs improvement: 0 | Easy pickings: 0 UI/UX: 0 | -------------------------------------+------------------------------------- This is currently not supported, and the ORM rightly throws an error whenever you attempt to do so. I believe it would be beneficial to have such support allowing a query like this be generated
{{{#!sql SELECT release_date AS release_date, MAX(price) AS max_price, MIN(price) AS min_price FROM (SELECT release_date, price FROM products_1 WHERE foo = 'bar' UNION SELECT release_date, price FROM products_2 WHERE foo = 'bar') AS products_subquery GROUP BY release_date }}} Which might look something like this in the ORM {{{#!python query1 = Products1.objects.filter(foo="bar") query2 = Products2.objects.filter(foo="bar") query1.union(query2).values("release_date").annotate( min_price=Min("price"), max_price=Max("price") ) }}} -- Ticket URL: <https://code.djangoproject.com/ticket/35146> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-updates+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/0107018d461d3835-61256a93-2a4a-4c55-80b4-12cfeed6df80-000000%40eu-central-1.amazonses.com.