Django: change the value of a field for all objects in a queryset

python django django-queryset
43Tesseracts picture 43Tesseracts · Jan 16, 2016 · Viewed 34.1k times · Source

I have a model MyModel with a boolean field active

Elsewhere, I am retrieving a queryset:

qs = MyModel.Objects.filter(....)

how can I set active=False for all objects in this qs?

Answer

Pynchia picture Pynchia · Jan 16, 2016

You can update all the records in the queryset with

qs.update(active=False)

Please refer to the official Django documentation for more info

Related questions

How do I do a not equal in Django queryset filtering?

In Django model QuerySets, I see that there is a __gt and __lt for comparative values, but is there a __ne or != (not equals)? I want to filter out using a not equals. For example, for Model: bool a; int …

Read More
How do I filter query objects by date range in Django?

I've got a field in one model like: class Sample(models.Model): date = fields.DateField(auto_now=False) Now, I need to filter the objects by a date range. How do I filter all the objects that have a date …

Read More
How can I filter a Django query with a list of values?

I'm sure this is a trivial operation, but I can't figure out how it's done. There's got to be something smarter than this: ids = [1, 3, 6, 7, 9] for id in ids: MyModel.objects.filter(pk=id) I'm looking to get them all in …

Read More