Getting all objects of model except

Question

Let the models class:

class MyModel(models.Model):
    name = models.CharField(max_length=200)
    category = models.CharField(max_length=200)

I want to get all the objects of MyModel except those with a specific category. I'm using this code:

[mm for mm in MyModel.objects.all() if mm.category != u'mycategory']

Is there another solution for this question?

Duplicate of http://stackoverflow.com/questions/687295/how-do-i-do-a-not-equal-in-django-queryset-filtering — Eren Güven, Sep 13 '12 at 11:42
actually I think it is a simpler, clearer example for when to use exclude, the other question is a bit more complex on the face of it — Ctrlspc, Sep 13 '12 at 12:06

score 15 · Accepted Answer · answered Sep 13 '12 at 11:40

15

So somethig like:

objects = MyModel.objects.exclude(category= u'mycategory')

answered Sep 13 '12 at 11:40

Ctrlspc

1 Answers1