Django Filters - or?

Question

How would I do an "or" in a django filter.

Basically, I want to be able to list the items that either a user has added (they are listed as the creator) or the item has been approved

so I basically need to select

item.creator = owner or item.moderated = False

How would I do this in django (preferably with a filter/queryset)

Answer 1

There is Q objects that allow to complex lookups. Example:

from django.db.models import Q

Item.objects.filter(Q(creator=owner) | Q(moderated=False))

Answer 2

There is a simpler way but I'm not sure if it hits the database twice.

Use the | operator:

result = Item.objects.filter(item.creator = owner) | Item.objects.filter(item.moderated = False)