See below for my query editor
SELECT customer_id, MAX(date_created) AS "Last_purchase" FROM public.accounts_order GROUP BY customer_id;
How will this look as a queryset on my django views?
Asked
Active
Viewed 119 times
-3
kamcoder
- 75
- 7
1 Answers
1
I believe it would look something like this:
Accounts_order.objects.values('customer_id') \
.annotate(last_created=Max('date_created'))
Harben
- 1,802
- 1
- 11
- 16
-
I get the error "AttributeError: 'QuerySet' object has no attribute 'group_by'" – kamcoder May 16 '20 at 21:13
-
Try now, had to remove the group_by. Objects.values('customer_id') is the group_by statement – Harben May 17 '20 at 13:49
-
Thanks it worked on my shell, but it didn't do quite what I wanted it to do in my template. I'll post another question. – kamcoder May 17 '20 at 13:53