django aggregate and filter

Question

I'm going to convert this sql to django commands:

SELECT
  core.id,
  core.title,
  core.age_id,
  core.cat_id,
  max(date) AS max_date
FROM core
WHERE core.state = 'ABC'
GROUP BY cat_id, age_id

I tried this, but not works correctly:

Core.objects.values('id', 'title', 'age_id', 'cat_id').filter(state='ABC').annotate(
            max_date=Max('date')).aggregate(Count('age_id', 'cat_id'))

Why are you using aggregate?

Evans Murithi
– Evans Murithi

2016-12-04 07:54:02 +00:00
Commented Dec 4, 2016 at 7:54 — Evans Murithi
– Evans Murithi, Commented Dec 4, 2016 at 7:54

Krishna Sunuwar · Accepted Answer · 2016-12-04 13:52:41Z

1

You have to do this with values() but restrict fields that you want to group by

Core.objects.values('age_id', 'cat_id').filter(state='ABC').annotate(Max('date'), Count('age_id', 'cat_id'))

edited Dec 4, 2016 at 13:52

answered Dec 4, 2016 at 8:28

Krishna Sunuwar

2,94519 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Sajad Over a year ago

I have compile error in Count('age_id', 'cat_id')

Sajad Over a year ago

Positional argument after keyword argument

Krishna Sunuwar Over a year ago

Edited answer, try that

Sajad Over a year ago

I need id and title columns too.

Krishna Sunuwar Over a year ago

That is syntaz for generatinf query you wanted. About result, 1. explain more what you trying to do? 2. What is the result you are expecting?

|

Collectives™ on Stack Overflow

django aggregate and filter

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related