how to search a array of objects with array property in laravel

Question

i want query a table with a json column the object stored in json column is like this:

[    
    {
        "title":"first",
        "ids":[79,583,584]
    },
    {
        "title":"second",
        "ids":[600,601,602]
    },
    {
        "title":"third",
        "ids":[605,606,624]
    }
]

and for example i want to find a row where one of its ids property contain for example 79. something like this:

Model::query()->whereJsonContains('data', ['ids[*]' => 79])->first();

i,ve searched a lot and tried some syntaxes but nothing worked. is that possible to do? how? my database is mysql

you can do this : stackoverflow.com/questions/30804878/…

archvayu
– archvayu

2021-08-28 14:39:39 +00:00
Commented Aug 28, 2021 at 14:39 — archvayu
– archvayu, Commented Aug 28, 2021 at 14:39

archvayu · Accepted Answer · 2021-08-28 15:48:42Z

1

querying nested json formats might not be available as of now, you can try filtering the eloquent collection though.

you have to cast the json data column as array on your model first and then filter the collection as per your conditions.

$id = 8;
$filtered = Model::all()->filter(function($item, $key) use($id) {
    $count = 0;
    foreach($item->data as $data) {
        if(in_array($id, $data['ids'])) {
            $count += 1;
        }
    }
    return $count > 0;
})->all();

answered Aug 28, 2021 at 15:48

archvayu

4484 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to search a array of objects with array property in laravel

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related