Django: Query using contains each value in a list

by 
import operator
from django.db.models import Q

User.objects.filter(reduce(operator.and_, (Q(first_name__contains=x) for x in ['x', 'y', 'z'])))

for python 3

from functools import reduce

.

More Related Contents:

  1. How to set a Django model field’s default value to a function call / callable (e.g., a date relative to the time of model object creation)
  2. What does on_delete do on Django models?
  3. Dynamic File Path in Django
  4. Django: Populate user ID when saving a model
  5. Get model’s fields in Django
  6. Can django’s auth_user.username be varchar(75)? How could that be done?
  7. How to ‘bulk update’ with Django?
  8. Using a UUID as a primary key in Django models (generic relations impact)
  9. Custom QuerySet and Manager without breaking DRY?
  10. Django ManyToMany filter()
  11. Django delete FileField
  12. Why does django’s prefetch_related() only work with all() and not filter()?
  13. ImageField overwrite image file with same name
  14. Django “xxxxxx Object” display customization in admin action sidebar
  15. How to limit queryset/the records to view in Django admin site?
  16. How to assign currently logged in user as default value for a model field?
  17. How to register users in Django REST framework?
  18. Using Django auth UserAdmin for a custom user model
  19. Django ManyToMany model validation
  20. Django – Overriding the Model.create() method?
  21. Django : Unable to import model from another App
  22. django.db.utils.IntegrityError: UNIQUE constraint failed: rango_category__new.slug
  23. Can Django automatically create a related one-to-one model?
  24. Django Order By Date, but have “None” at end?
  25. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  26. Password field in Django model
  27. Creating Partial Indexes with Django 1.7
  28. Django: dynamic database file
  29. conversion of datetime Field to string in django queryset.values_list()
  30. Django Rest framework, how to include ‘__all__’ fields and a related field in ModelSerializer ?

Leave a Comment