Level 63
Do you have an error ? Have you declared the relationship in the application model ?
Have you tried with whereHas() instead of with() ?
Jun 24, 2022
23
Level 4
Laravel Relationship Query Did not work
I have two table 1. applications 2. users --applications-- table contains id,user_id,categroy,status | I want to filter applications table user name and also application column name
$applications = Application::with(['user'=>function($query) use ($request){
$query->where('name','like','%'.$request->name.'%');
}])->when($request->category,function ($query,$category){
return $query->where('category',$category);
})->paginate(10)->appends([
'name'=>$request->name,
'category'=>$request->category
]);
with relatinship query didn't work how to solve this issue?
- Thanks
Level 4
@vincent15000 it shows all data... Didn't work like query
1 like
Level 63
@Jarjis Ok ... I just edited my previous answer ... have a look ;) => whereHas().
Level 4
@vincent15000 yes also use whereHas() but not working
1 like
Level 63
Level 4
@vincent15000 I'm installing 8
1 like
Level 63
@Jarjis https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence
This should work. Can you show the relationship in your model ?
Level 4
public function user()
{
return $this->belongsTo(User::class);
}
1 like
Level 63
@Jarjis Can you try only this part of the query ?
$applications = Application::whereHas(['user'=>function($query) use ($request) {
$query->where('name', 'like' ,'%'.$request->name.'%');
}])->get();
Level 4
@vincent15000 sure...
1 like
Level 4
@vincent15000 showing Call to a member function getRelationExistenceQuery() on array
Level 63
@Jarjis If it doesn't work, you can also reverse the query like this.
$users = User::with('applications')->where('name', 'like', '%'.$request->name.'%')->get();
And then you can access the applications from each user.
Level 4
@vincent15000 but similarly I need application column filtering...
1 like
Level 63
@Jarjis Let me have a look by testing directly on an app and I come back with more precisions in a few minutes ;).
1 like
Level 4
@vincent15000 okay
1 like
Level 63
@Jarjis I have it ... you have to use whereHas() but with this syntax.
$applications = Application::whereHas('user' => function($query) use ($request) {
$query->where('name', 'like' ,'%'.$request->name.'%');
})->get();
You have to not use [ ... ].
whereHas([ ... ]) has to be changed to whereHas(...)
Level 63
@Jarjis Have you solved your problem ?
Level 4
@vincent15000 Yes thanks buddy 🌺
1 like
Level 63
@Jarjis Great ... so you can close the post by setting the best answer to the answer that allowed you to solve your problem ? ;)
Level 13
Can you explain a bit? as far as I understood the application table contains 1 user ie belongs to a user right? so why would you even filter that user? Do you want to get all the application belongs to a user with the name $request->name?
1 like
Level 63
@iftekhs No he wants to retrieve all applications that belong to a user for which the name is like $request->name, the filter can filter for several users at a time.
Level 13
@vincent15000 So it's basically filtering the application, not the user?
1 like
Level 63
@iftekhs I think that he wants the list of the applications, but only the application for which the user name is like $request->name. Example : $request->name = 'Sou so the applications for which the user name is Soulier and Souquier will be retrieved.
1 like
Please or to participate in this conversation.