66👍
✅
They are equal:
>>> str(Person.objects.filter(age__isnull=True).query) == str(Person.objects.filter(age=None).query)
True
>>> print(Person.objects.filter(age=None).query)
SELECT "person_person"."id", "person_person"."name", "person_person"."yes", "person_person"."age" FROM "person_person" WHERE "person_person"."age" IS NULL
>>> print(Person.objects.filter(age__isnull=True).query)
SELECT "person_person"."id", "person_person"."name", "person_person"."yes", "person_person"."age" FROM "person_person" WHERE "person_person"."age" IS NULL
Exclusion: the Postgres JSON field (see the answer of @cameron-lee)
👤knbk
50👍
It depends on the type of field. As mentioned in other answers, they are usually equivalent but in general, this isn’t guaranteed.
For example, the Postgres JSON field uses =None to specify that the json has the value null while __isnull=True means there is no json:
https://docs.djangoproject.com/en/3.0/ref/contrib/postgres/fields/#jsonfield
- [Django]-Why does DEBUG=False setting make my django Static Files Access fail?
- [Django]-In Django Admin how do I disable the Delete link
- [Django]-What is a django.utils.functional.__proxy__ object and what it helps with?
38👍
Just to keep in mind that you cannot reverse the condition with your first solution:
# YOU CANNOT DO THIS
queryset = Model.objects.filter(field!=None)
However you can do this:
queryset = Model.objects.filter(field__isnull=False)
- [Django]-How does the get_or_create function in Django return two values?
- [Django]-Django: Error: You don't have permission to access that port
- [Django]-Can a dictionary be passed to django models on create?
Source:stackexchange.com