django orm filter code example

Example 1: filter django or

#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))

Example 2: filter django or

#It is worth to note that it's possible to add Q expressions.
from django.db.models import Q

query = Q(first_name='mark')
query.add(Q(email='[email protected]'), Q.OR)
query.add(Q(last_name='doe'), Q.AND)

queryset = User.objects.filter(query)

Example 3: and in django query filter

Blog.objects.filter(entry__headline__contains='Lennon', entry__pub_date__year=2008)

Example 4: objects.filter django

>>> Entry.objects.filter(blog_id=4)

Example 5: create django object

Author.objects.create(name="Joe")

Example 6: django 3.0 queryset examples

>>> Entry.objects.filter(
...     headline__startswith='What'
... ).exclude(
...     pub_date__gte=datetime.date.today()
... ).filter(
...     pub_date__gte=datetime.date(2005, 1, 30)
... )