Level 6
what is the jobData relation name in your job Model ?
Nov 12, 2019
7
Level 5
eloquent query relations
I have a Job table that hasMany JobData i want to query Job::where('is_active', true)->JobData('title', 'LIKE', $query) (this is just pseudo code)
this is the code I wrote, but the problem is that it gets also Job items that don't satisfy the condition
$jobs = Job::where('is_active', 1)
->whereHas(['data' => function($query) use($keyword) {
$query->where('status', 'pending')
->where('title', 'LIKE', "%{$keyword}%");
}])->get();
the only way I could get the right data I want is with query builder but I can't use the relations in the Model
Level 5
it's "data"
Level 6
@imadev I think you have a syntax error in your whereHas parameters. It should be (relationName, function()) not array.
$jobs = Job::where('is_active', 1)
->whereHas('data' , function($query) use($keyword) {
$query->where('status', 'pending')
->where('title', 'LIKE', "%{$keyword}%");
})->get();
Level 5
No, that's the right syntax https://laravel.com/docs/6.x/eloquent-relationships#querying-relationship-existence This code is returning results, so it's working fine, it's just not returning the results I want
I want to get only the jobs that has jobData where title is like the keyword, but this code gets also the Job entities with jobData that doesn't satisfy the query
Level 6
@imadev This is from the Laravel docs, no array as param:
// Retrieve posts with at least one comment containing words like foo%...
$posts = App\Post::whereHas('comments', function (Builder $query) {
$query->where('content', 'like', 'foo%');
})->get();
Level 6
I'm not sure what your { and } are doing to your query?
"%{$keyword}%"
my code uses
"%$keyword%"
Level 5
thank you, it works now. Honestly I don't know where I got the the array syntax from, I think it's the 1AM effect
Please or to participate in this conversation.