Reverse foreign key relationship in filter

[arlus ishmael]

I have three models that look as follows:

class Project(models.Model):

    name = models.CharField(max_length=100)

class ProjectAllocation(models.Model):

    project = models.ForeignKey(Project)

    location = models.ForeignKey(Location)

    

class Location(models.Model):

    name = models.CharField(max_length=50)

I'm writing a filter for the Project model. Is there a way I can include "Location" in my filter??

[Carlton Gibson]

Hi. 

On Saturday, 9 May 2015 12:14:43 UTC+2, arlus ishmael wrote:

I'm writing a filter for the Project model. Is there a way I can include "Location" in my filter??

 Yes. From the docs:

Items in the fields sequence in the Meta class may include “relationship paths” using Django’s __syntax to filter on fields on a related model:

class ProductFilter(django_filters.FilterSet):
    class Meta:
        model = Product
        fields = ['manufacturer__country']

https://django-filter.readthedocs.org/en/latest/usage.html#the-filter

[connie.s...@gmail.com]

Hi Carlton,

further to this issue, if I was filtering on the reverse of Product (so filtering manufacturer by product) would 

fields = ['product_set__name']? Does the '_set' aspect of the django __ syntax hold?

Thank you!

[Carlton Gibson]

Hi Connie. 

First up: have you tried it? (Always a good idea: even if it doesn't work you get an error that tells you something.)

Second: Yes, it should do. 

`product_set` will be the automatically generated reverse relationship. Yes, you can filter across such relationships. 

Kind Regards,

Carlton