Permission to ask friends, I made a table like this =
Table adjustment = ‘id’,’adjustment_number’, ‘status’.
Then the adjustment table has a relationship which I named materialloc, then another relationship to sbin.
Then I created a query program like this using Laravel 10
$query = Adjustment::with('materialloc.sbin');
if ($request->has('search') && $request->input('search')) {
$searchTerm = $request->input('search');
$query->whereHas('materialloc.sbin', function ($query) use ($searchTerm) {
$query->where('name', 'like', '%' . $searchTerm . '%');
});
$query->orWhere('adjustment_number', 'like', '%' . $searchTerm . '%');
}
Why search using adjustment_number doesn’t work ?
But when I search by name in materialloc.sbin it works, is there something wrong with my use of whereHas, where or orWhere?
Please help friends