How to exclude multiple values of column using Django ORM?

Question

I want to filter mytable & get rows where name does not contain '' or '-' values and for this purpose I have used below query but does not working.

mytable.objects.exclude(name = ['','-']).order_by('name').count() returning 2000 all rows and whereas query mytable.objects.exclude(name = '').order_by('name').count() working perfectly and returning filtered 1460 results.

Below one is my Postgresql query which is working perfectly fine and returning 1450 results excluding name values of ['','-'].

select * from mytable where name != '-' and name != '' order by -id

Underoos · Accepted Answer · 2021-05-17 07:23:39Z

3

Try this.

mytable.objects.exclude(name__in=['', '-'])

This should exclude the rows matching the values you've passed in the list.

And you don't need to do order_by() for getting the count.

Just use the .count() directly on queryset.

edited May 17, 2021 at 7:23

answered Nov 29, 2019 at 7:30

Underoos

5,2769 gold badges55 silver badges106 bronze badges

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

1 Comment

Moon Over a year ago

thanks buddy , able to achieve my task & by the way I have used order_by() to sort values by name & count is just for testing purpose.

Collectives™ on Stack Overflow

How to exclude multiple values of column using Django ORM?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related