Eloquent accessing array inside object

Question

I have a get formule that returns some nested relationships in an array. I was wondering how to access them in a where statement.

The initial get

$taken = UserWork::with('work.place')
            ->with('user')
            ->with('work.timeslot')
            ->get();

I tried something like this

$taak = $taken->where('work.timeslot[0].start_hour',"17:00:00")->first();

json result from $taken

do u want to get the userworks records and its timeslot which start_hour is 17:00:00.Or u can post the example that u expected. — TsaiKoga
– TsaiKoga, Commented Apr 30, 2020 at 14:54

Aslam H · Accepted Answer · 2020-04-30 15:23:14Z

1

Using with will endup with two queries. if you want to bring the user with timeslot null then there no need to add whereHas

    $callback = function($query) {
        $query->where('start_hour',"17:00:00");
    };

    $taken = UserWork::whereHas('work.timeslot', $callback)
        ->with(
            ['work.place', 'user', 'work.timeslot' => $callback]
        )->get();

answered Apr 30, 2020 at 15:23

Aslam H

1,8195 gold badges27 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Eloquent accessing array inside object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related