with_ lamda filters not working.

[yubarajshrestha]

Imagine you have list of products with many to many relation with categories.

Below code works fine

products = Product.with_("categories").get()

[
    {
        "id": 1,
        "name": "Product 1",
        "categories": [
            {
                "id": 1,
                "name": "Category 1",
                "status": "published"
            },
            {
                "id": 2,
                "name": "Category 2",
                "status": "draft"
            }
        ]
    }
]

Filtering with_ lambda (Doesn't work)

products = Product.with_("categories", lambda query: (
    query.where("status", "published")
)).get()

Expected Result

[
    {
        "id": 1,
        "name": "Product 1",
        "categories": [
            {
                "id": 1,
                "name": "Category 1",
                "status": "published"
            },
        ]
    }
]

Actual Result

[
    {
        "id": 1,
        "name": "Product 1",
        "categories": [
            {
                "id": 1,
                "name": "Category 1",
                "status": "published"
            },
            {
                "id": 2,
                "name": "Category 2",
                "status": "draft"
            }
        ]
    }
]

[josephmancuso]

belongs_to_many

[yubarajshrestha]

belongs_to_many

Model class looks like this:

"""CommerceProduct Model."""
class Product(Model):
    """Product Model."""
    __primary_key__ = "id"

    __fillable__ = [
        #...
    ]

    @belongs_to_many(
        local_foreign_key="product_id",
        other_foreign_key="category_id",
        table="category_product",
    )
    def categories(self):
        """Returns all categories for this product."""
        from ..models.Category import Category

        return Category

[josephmancuso]

I could only get this to work with the belongs to if you did this:

products = Product.with_("categories", lambda query: (
    query.where("categories.status", "published")
)).get()