I'm trying to get users from their foo relationship, and from an id which is stored in a data json column.
I tried the syntax below which is wrong :
User::with('foos')->where(['foos.data->id' => 123])->get()
What is the correct syntax for such query ?
You need to apply the condition to the relationship. You should also better use the where JSON clause.
User::with('foos')->whereRelation('foos', function ($query) {
$query->whereJsonContains('data->id', 123);
});
https://laravel.com/docs/9.x/eloquent-relationships#inline-relationship-existence-queries
You need to make the query on the with() query
User::with(['foos' => function($query)
$query->where('data->id', 123);
})->get()
@Sinnbeck Oh I have thought too complicated. That's the better solution.
The best option is not to use json columns.
@Tray2 I agree :-)
Please or to participate in this conversation.