How to use Group by clause in django with the filter query

Question

I went through a lot of links and sites , but i can't find the solution for my problem anywhere. So at last i came here .

My problem is that, I want to use the group by clause with the filter query.

i have found this

How to query as GROUP BY in django?

for objects.all() . But could not find anything for objects.filter()

Here is my query

query =Kicthen.objects.filter( cabinets='1').query

query.group_by = ['style_id']

results = QuerySet(query=query, model=Kicthen)

But its return nothing.

I don't want to use any annotate and distinct with it

What are you trying to by grouping object? Where is your aggregate function? — Siva Arunachalam
– Siva Arunachalam, Commented Sep 19, 2013 at 5:06
You can use aggregation docs.djangoproject.com/en/dev/topics/db/aggregation/… — Sudip Kafle
– Sudip Kafle, Commented Sep 19, 2013 at 5:31
is this compulsary to use aggregate function with the group by clause. can't i use the group by clause to get the distinct vlaues? — Sakeer
– Sakeer, Commented Sep 19, 2013 at 5:32
If you group your results by a specific column, you need to do something with the other columns. If you just want the distinct values, use .values_list('style_id', flat=True).distinct(). — Thierry J
– Thierry J, Commented Sep 19, 2013 at 6:18

Manuel Pomares · Accepted Answer · 2013-09-20 17:07:57Z

1

Use can use raw to make group by http://doughellmann.com/2007/12/using-raw-sql-in-django.html

answered Sep 20, 2013 at 17:07

Manuel Pomares

212 bronze badges

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

3 Comments

Manuel Pomares Over a year ago

I only show another option. Give that comment to the creator of the raw command

redbmk Over a year ago

@yuvi What's so scary about SQL? Also if you know a better solution it would be nice to add it as an answer.

yuvi Over a year ago

@redbmk but seriously though. SQL is terrible, just... So, so bad. There's a reason people built an entire framework with a feature dedicated to avoiding it. Other than raw, I'd say aggregation is the simple solution but OP doesn't seem to be having it (see comments above) so there aren't really that many other options.

Collectives™ on Stack Overflow

How to use Group by clause in django with the filter query

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related