laravel 5.4 yajra datatable cant query table by url id says Missing required parameters

Question

I want to query table by url id from yajra datatable but I can't query missing parameter.

controller

public function getpostshow($id,request $request)
{   
   $medrep = Medrep::find($id);
   $req = $request->segment(2);
    $users = DB::table('itinerarys')
    ->select('doctors.*','medreps.*','itinerarys.*')
    ->join('doctors', 'itinerarys.doctor', '=', 'doctors.doctor_id')
    ->join('medreps', 'itinerarys.medrep', '=', 'medreps.medrep_id')
    ->where('itinerarys.medrep', '=', $req);
    return Datatables::of($users)
    ->editColumn('EmployeeLastName', '{!! str_limit($EmployeeLastName, 60) !!}')
    ->editColumn('CustomerCode', '{!! str_limit($CustomerCode, 60) !!}')
    ->editColumn('CustomerLastName', '{!! str_limit($CustomerLastName, 60) !!}')

    ->make(true);
}

route

Route::get('medrep/{id}/getpostshow', 
['as'=>'medrep.getpostshow','uses'=>'MedrepController@getpostshow']);

Answer 1

You have to pass a value when you call route

{{ route('medrep.getposts', ['id' => 1]) }}