Dynamic OR’d Queryset creation with Django

[elfs]

For multi-select boxes where you have a list of things you want to filter on, and you want the queryset returned to be an OR’d set.

    qset = Q(mode__exact=modes[0])
    if len(modes) > 1:
        for mode in modes[1:]:
           qset = qset | Q(mode__exact=mode)
    r = Responses.objects.filter(qset)

Now, I need to figure out how to do this as a list comprehension!

For extra coolness, you can see what SQL you’re generating:

    print r.query.as_sql()

This entry was automatically cross-posted from Elf's technical journal, ElfSternberg.com

Comments

[tamino.livejournal.com]

What about .filter(mode__in=modes) ?