django dynamically filtering with q objects

by

You’ll want to loop through the tag_list and apply a filter for each one.

tag_list = ['tag1', 'tag2', 'tag3']
base_qs = Design.objects.all()
for t in tag_list:
    base_qs = base_qs.filter(tags__tag__contains=t)

This will give you results matching all tags, as your example indicated with and. If in fact you needed or instead, you will probably need Q objects.

Edit: I think I have what you’re looking for now.

tags = ['tag1', 'tag2', 'tag3']
q_objects = Q() # Create an empty Q object to start with
for t in tags:
    q_objects |= Q(tags__tag__contains=t) # 'or' the Q objects together

designs = Design.objects.filter(q_objects)

I tested this and it seems to work really well.

Edit 2: Credit to kezabelle in #django on Freenode for the initial idea.

More Related Contents:

  1. When saving, how can you check if a field has changed?
  2. Django: How can I protect against concurrent modification of database entries
  3. How to express a One-To-Many relationship 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. Override default queryset in Django admin
  8. Setting the selected value on a Django forms.ChoiceField
  9. Custom QuerySet and Manager without breaking DRY?
  10. Django: Query using contains each value in a list
  11. Django: Set foreign key using integer?
  12. How can I have two foreign keys to the same model in Django?
  13. How do you serialize a model instance in Django?
  14. Django migrate –fake and –fake-initial explained
  15. How to make email field unique in model User from contrib.auth in Django
  16. Why does django’s prefetch_related() only work with all() and not filter()?
  17. Select DISTINCT individual columns in django?
  18. django – get() returned more than one topic
  19. Django ModelForm override widget
  20. Django – how to specify a database for a model?
  21. “Post Image data using POSTMAN”
  22. How to add data into ManyToMany field?
  23. Raw SQL queries in Django views
  24. Django model: delete() not triggered
  25. Django – filtering on foreign key properties
  26. How to register users in Django REST framework?
  27. Django unique_together with nullable ForeignKey
  28. django most efficient way to count same field values in a query
  29. Sharing models between Django apps
  30. Django: dynamic database file

Leave a Comment