Django Query Filter

Question

The following line in my view selects all records that have a delay of 0

t = Times.objects.filter(delay = 0)

How do i write it such that it selects everything but with delay 0?

Joe Jasinski · Accepted Answer · 2011-06-16 23:14:36Z

3

Can you try doing?

t = Times.objects.exclude(delay=0)

I think that will work for you.

Hope that helps, Joe

answered Jun 16, 2011 at 23:14

Joe Jasinski

10.9k18 gold badges77 silver badges112 bronze badges

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

Comments

Ignacio Vazquez-Abrams · Accepted Answer · 2011-06-16 23:14:22Z

2

With exclude() instead.

answered Jun 16, 2011 at 23:14

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Comments

jakecar · Accepted Answer · 2011-06-16 23:16:20Z

2

Use the exclude() method instead of the filter() method

https://docs.djangoproject.com/en/1.3/topics/db/queries/#retrieving-specific-objects-with-filters

answered Jun 16, 2011 at 23:16

jakecar

5861 gold badge7 silver badges14 bronze badges

Comments

Peter Rowell · Accepted Answer · 2011-06-16 23:14:43Z

0

It's in the docs. You want:

t = Times.objects.filter(delay__ne=0)

answered Jun 16, 2011 at 23:14

Peter Rowell

17.8k2 gold badges52 silver badges65 bronze badges

Collectives™ on Stack Overflow

Django Query Filter

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related