Filtering 'bundles'

[yeago]

There is no way currently to evaluate two filters together (AND vs OR on the relations queried):0

Given

class Organization(models.Model):
    name = models.CharField(..)

class Location(models.Model):
    organization = models.ForeignKey(Organization)
    zip_code = models.PositiveIntegerfield(...)
    open_saturday = models.BooleanField(...)

A django filter oriented around Organization but with fields for 'zip_code' and 'open_saturday' cannot give you all organization within a particular zip code who are also open saturday.

One possible approach would be to create a filter_together option for Meta, which would be a list of tuples of field name bundles. If there is a way to garner a Q object from a queryset, one could loop through these bundles compiling Q objects and then filter them together. If not, perhaps an as_q() method could be added to a filter which returns a Q object instead.

Like my other Issue in this realm, I really don't mind submitting code if a design decision favors things like this.

[yeago]

btw, its possible queryset.query.where.children could be munged into a Q.

[yeago]

This problem can be solved if extra(select={'the_related_field'... is used, because re-querying is not then necessary.

[yeago]

This is the same basic issue where filters force a join.

[carltongibson]

OK — thanks — really helps to see where the work is needed.