You could chain your queries as follows: values = [1,2,3] # Turn list of values into list of Q objects queries = [Q(pk=value) for value in values] # Take one Q object from the list query = queries.pop() # Or the Q object with the ones remaining in the list for item in queries: query … Read more
Concatenating the querysets into a list is the simplest approach. If the database will be hit for all querysets anyway (e.g. because the result needs to be sorted), this won’t add further cost. from itertools import chain result_list = list(chain(page_list, article_list, post_list)) Using itertools.chain is faster than looping each list and appending elements one by … Read more
Try adding parentheses to explicitly specify your grouping? As you already figured out, multiple params to filter() are just joined via AND in the underlying SQL. Originally you had this for the filter: […].filter( Q(hide=False) & Q(deleted=False), Q(stock=False) | Q(quantity__gte=1)) If you wanted (A & B) & (C | D) then this should work: […].filter( … Read more
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 … Read more
Concatenating the querysets into a list is the simplest approach. If the database will be hit for all querysets anyway (e.g. because the result needs to be sorted), this won’t add further cost. from itertools import chain result_list = list(chain(page_list, article_list, post_list)) Using itertools.chain is faster than looping each list and appending elements one by … Read more