django dynamically filtering with q objects django dynamically filtering with q objects django django

django dynamically filtering with q objects


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 withfor t in tags:    q_objects |= Q(tags__tag__contains=t) # 'or' the Q objects togetherdesigns = 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.


You can use this way:

my_dict = {'field_1': 1, 'field_2': 2, 'field_3': 3, ...}  # Your dict with fieldsor_condition = Q()for key, value in my_dict.items():    or_condition.add(Q(**{key: value}), Q.OR)query_set = MyModel.objects.filter(or_condition)

By this way you can use dynamically generated field names. Also you can use Q.AND for AND condition.


Just prepare a tag list first then, query like this:

tags = ['tag1', 'tag2',...]design_list = Design.objects.filter(tags__tag__contains__in = tags)