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$ Publisher-a 7
book_2 2$ Publisher-b 9 book_3 0,5$ Publisher-a 14 book_2 4$ Publisher-b
If I'll write something like
*Publisher.objects.annotate(pr_max=Max('book__price'))*
I'll get (as I understand):
*Publisher pr_max*
*Publisher-a; 1$*
*Publisher-b; 4$*
But I want to see wich book was selected by Max() function:
*Publisher pr_max book_id*
*Publisher-a; 1$; 2*
*Publisher-b; 4$; 14*
On Monday, May 4, 2015 at 1:48:30 PM UTC+3, 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 price of any book that is available for sale in a store,
> you could use the aggregate:
>
> Store.objects.annotate(min_price=Min('books__price'),
> max_price=Max('books__price'))
>
> Store.objects.aggregate(min_price=Min('books__price'),
> max_price=Max('books__price'))
>
>
> By this string of code I'll get min/max price each of book in each store
> But I won't see name or id of book, which was selected during use of
> aggregation (max or min)
> So the question... How can I get records
>
> store min/max price *book ???*
>
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/409e63a3-e2c1-4b48-a417-3bb69e3d860a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
