vendredi 23 novembre 2018

How can I select data write where in json object in related ORM Laravel

I have 2 model Basket and product my product table has json object column and I write code like this

            $basket=Basket::with("product")->whereJsonContains("product->store->id",$stores_id)->get();

But laravel don't return me data. Throw this error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product' in 'where clause' (SQL: select * from shopping_cards where json_contains(product->'$.\"store\".\"id\"', 39))

And my data structure like this

{
        "id": 3,
        "users_id": 1,
        "quantity": 1,
        "product": {
            "id": 116,
            "store": {
                "id": 39,
                "status": 41,
            }
         }
}



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire