Laravel query is not working properly

@jerodevs

When you have a group of orwhere's in combination with normal where's, you should put them in their own closure so the query builder knows these need to be seen together apart from the other where's.

$filtertext = $request->filter;
$data = Activity::select('activity_log.*', 'users.first_name', 'users.last_name', 'users.email')
    ->join('users', 'users.id', '=', 'activity_log.causer_id')
    ->where('subject_id', '=', $id)
    ->where('subject_type', '=', 'App\Models\Node')
    ->where(function ($query) use ($filtertext) {
        $query
            ->orWhere('first_name', 'like', '%' . $filtertext . '%')
            ->orWhere('last_name', 'like', '%' . $filtertext . '%')
            ->orWhere('email', 'like', '%' . $filtertext . '%');
    })
    ->with([
        'subject' => function ($q) {
            $q->whereNull('deleted_at');
        }
    ])
    ->orderBy('created_at', 'desc')
    ->paginate(12);

The where condition are not used correctly, https://get-shareit.com https://get-vidmateapk.com

The where condition are not used correctly, could you try this:

$career_solution = CareerSolution::with('user.role', 'user.privancy_setting', 'category', 'sub_category', 'country');

$career_solution = $career_solution->where(function ($query) { $query->where('expires_at', '>=', date('Y-m-d')) ->orWhere('expires_at', '=', '0000-00-00'); });

$career_solution = $career_solution->where(function ($query1) use ($id) { $query1->where(function ($query2) use ($id) { // assuming that the relation name in User model is name public function privacy_setting .. $query2->whereHas('user.privacy_setting', function ($query3) { $query3->where('career_solutions', '=', 0); // You don't need to specify the table here only the table field you want })->where('public', '=', 1); })->orWhere(function ($query4) use ($id) { // idem here the relation must be name contact $query4->whereHas('user.contact', function ($query5) use ($id) { $query5->where('user_id', '=', $id); // idem here })->orWhere('user_id', '=', $id); }); }); https://jiofilocalhtml.run https://forpc.onl

Hey i am also facing same issue if someone could help me with correct coding it will be a great help.

Thank you.!