Re: Fields outside Aggregation functions

I didn't quite understand have I sent the answer to Somecallitblues... So write it once more Forgot about Stores... Let's look at Publisher and Book (those of Django documentation described) Here is table beneath for example: *Publisher* Publisher-a Publisher-b *Book* id 2 book_1 1$ Pub

Re: Fields outside Aggregation functions

Hi Alex, Am 04.05.2015 um 12:48 schrieb Alex-droid AD: So the question... How can I get records storemin/max price */_book ???_/* I recently had the same question, please see this thread: https://groups.google.com/forum/#!topic/django-users/adRe2_BWMz0 If you ever find a more direct solu

Re: Fields outside Aggregation functions

Can you perhaps order by price and get first and last items? On 4 May 2015 8:48 pm, "Alex-droid AD" wrote: > > > There is example in Django documentation about using Aggregate and > Annotate clauses > > The same rules apply to the aggregate() clause. If you wanted to know the > lowest and highest

Fields outside Aggregation functions

There is example in Django documentation about using Aggregate and Annotate clauses The same rules apply to the aggregate() clause. If you wanted to know the lowest and highest price of any book that is available for sale in a store, you could use the aggregate: Store.objects.annotate(min_pr