Filtering many-to-many joins

[ziadoz]

Hi. I wondered if it's possible to filter many-to-many joins using the JoinSupportingQueryBuilderParser?

I have a table setup similar to this (the real thing is more complex, but this is the gist):

products
--------
id
name

attributes
----------
id
name
value

products_attributes
-------------------
product_id
attribute_id

I guess I'm wondering if it's possible to build a query that can filter this setup correctly, selecting all the products by joining on products_attributes.attribute_id but filtering on attributes.value.

Any advice on whether or not this can be done using the existing code would be great. Thanks.

[Naghal]

Have you found a solution?