How to dynamically provide lookup field name in Django query? [duplicate]

by

I would prefer to use the Q object for something like this. 

from django.db.models import Q

keyword = 'keyword'
fields = ['foo', 'bar', 'baz']

Qr = None
for field in fields:
    q = Q(**{"%s__contains" % field: keyword })
    if Qr:
        Qr = Qr | q # or & for filtering
    else:
        Qr = q

# this you can now combine with other filters, exclude etc.    
results = MyModel.objects.filter(Qr)

More Related Contents:

  1. How can I combine two or more querysets in a Django view?
  2. How do I do an OR filter in a Django query?
  3. How to filter empty or NULL names in a QuerySet?
  4. Custom QuerySet and Manager without breaking DRY?
  5. Why does django’s prefetch_related() only work with all() and not filter()?
  6. Select DISTINCT individual columns in django?
  7. _set in Django for a queryset
  8. Raw SQL queries in Django views
  9. How to limit queryset/the records to view in Django admin site?
  10. Django: implementing JOIN using Django ORM?
  11. Django – filtering on foreign key properties
  12. How to create a Django queryset filter comparing two date fields in the same model
  13. Django Queryset with filtering on reverse foreign key
  14. Django lazy QuerySet and pagination
  15. Django: ManyToMany filter matching on ALL items in a list
  16. Django query datetime for objects older than 5 hours
  17. Django, query filtering from model method
  18. Django: Does prefetch_related() follow reverse relationship lookup?
  19. django most efficient way to count same field values in a query
  20. Django Order By Date, but have “None” at end?
  21. Django query case-insensitive list match
  22. Django: __in query lookup doesn’t maintain the order in queryset
  23. Django queryset get exact manytomany lookup [duplicate]
  24. how to write a query to get find value in a json field in django
  25. How do I filter query objects by date range in Django?
  26. Manager isn’t available; User has been swapped for ‘pet.Person’
  27. How to cURL an Authenticated Django App?
  28. How to iterate over nested dictionaries in django templates
  29. Django on Google App Engine
  30. How to delete a record in Django models?

Leave a Comment