django query filter code example

Example 1: q django

from django.db.models import Q

Q(question__startswith='Who') | Q(question__startswith='What')

Example 2: 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 3: django q objects

from django.db.models import Q

obj, created = Person.objects.filter(
    Q(first_name='Bob') | Q(first_name='Robert'),
).get_or_create(last_name='Marley', defaults={'first_name': 'Bob'})

Example 4: 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 5: and in django query filter

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

Example 6: objects.filter django

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