Use find() and with() together in Laravel query

With goes before find()

$employees = Employee::with('employees.employee_locations')->find([1]);

Or if you need to alter the with query

$employees = Employee::with(['employees.employee_locations' => function($query) {
    $query->latest()->limit(1);
})->find([1]);

Hi @afoysal

Edit: @sinnbeck was faster :D

Try this

Employee::with('employees.employee_locations')->find(1);

I am getting Call to undefined relationship [employees] on model [App\Employee]. error.

@afoysal this is what you need - https://laravel.com/docs/6.x/eloquent-relationships

Well the error tells you whats wrong. You dont have a relationship called employees. Can you show the relationship you are trying to use?

@sinnbeck

Here is Employee Model

<?php

    namespace App;

    use Illuminate\Database\Eloquent\Model;
   use App\Employee_location;

    class Employee extends Model
   {
        protected $fillable = ['name', 'emi_number', 'account_id'];

       public function employee_locations()
        {
           return $this->hasMany(Employee_location::class);
       }
   }

@afoysal you don't have to specify the current table in with, so just this should work:

$employee = Employee::with('employee_locations')->find([1]);

The problem is that is is just employee_locations not employees.employee_locations

$employees = Employee::with('employee_locations')->find([1]);
or
$employees = Employee::with(['employee_locations' => function($query) {
    $query->latest()->limit(1);
})->find([1]);

Thanks @sinnbeck your solution is working. Could you please explain when should I use => function($query) {..... ? Thanks

Sure..

Lets say you just want to get all data that the default query would get, then you just do this

$employees = Employee::with('employee_locations')->find([1]);

But now lets say that you want to change some part of relation.. That could be sorting, amount or something else. Then you would use a function to specify that. Notice how the function is linked to the 'employee_locations'

$employees = Employee::with(['employee_locations' => function($query) {
    $query->where('status', 1)->latest()->limit(5); //here we say that status of locations must be 1, that we want them order by latest and to only get 5.
})->find([1]);