Level 16
You can still do it using the db.
Model::with([
'related' => fn ($query) => $query->where('xyz', 'abc')
])->get();
Dec 29, 2021
7
Level 1
Query Collection on nested item
Assume I have the following Eloquent query (Since I will use the returned collection in more than one place, I eager load the related model) :
$myModels = MyModel::with(['myRelatedModel'])->where(...) ... ->get();
Now, what if I want to query $myModels to return only the ones where a field of myRelatedModel is xyz ? In a normal Eloquent query I'd use whereHas, but on collections that is not available.
$results = $myModels->where ??
Thanks
Level 1
@mabdullahsari The point was to avoid making another db query, and use the data from the collection I already have.
Level 104
@Nite it'd likely be the more efficient option; depending on the sizes of the main and nested Collections. Iterating over large Collections in PHP would probably be more expensive.
2 likes
Level 16
@Nite Processing done by the database is always cheaper than processing done in PHP.
1 like
Level 1
@tykus @mabdullahsari I didn't know that, thanks
Level 16
@Nite Please mark as solved.
Level 75
You can use filter for that.
1 like
Please or to participate in this conversation.