Get datas from relation table (with()) with a condition

Question

I have an 'implementation' table that contains relationships to retrieve projects and scores.

The scores table contains a" user_id "field.

I would like to collect all the implementations but with only the score which contains the user_id.

My original query.

public function getImplementations($id, $student)
{
    $data = Implementation::where('event_id', $id)->where('student_id', $student)->with('project', 'score')->get();

    return response()->json($data);
}

My test for get only the score from specific user (only one score per user per implementation, so no conflict possible)

$data = Implementation::where('event_id', $id)
           ->where('student_id', $student)->with('project', 'score')
           ->whereHas('score', function ($query) {
            $query->where('user_id', Auth::user()->id);
        })->get();

But that does not give the expected result. This is not the right method and I do not know the right one.

Thanks for your help

Mozammil · Accepted Answer · 2019-01-21 20:11:56Z

2

I am not sure if there's a need to eager-load and constrain a relationship simultaneously. Does the following provide you with the expected result?

$data = Implementation::where('event_id', $id)
    ->with([
        'project',
        'score' => function ($query) {
            $query->where('user_id', Auth::id());
        }
    ])
    ->where('student_id', $student)
    ->get();

edited Jan 21, 2019 at 20:11

answered Jan 21, 2019 at 20:00

Mozammil

8,77017 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get datas from relation table (with()) with a condition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related