How do I figure out to correct the Requested unknown parameter from my datatable?

pickorea

I am joining tables using a leftjoin as follows

public function query(Detail $model)
{
return $model->newQuery()->leftjoin('fishers','fishers.id', '=','details.fisher_id')
->leftjoin('species','species.id', '=', 'details.species_id')
->leftjoin('purposes','purposes.id', '=', 'details.purpose_id')
->leftjoin('islands','islands.id', '=', 'fishers.island_id')
->leftjoin('preservations','preservations.id', '=', 'details.preservation_id')
->select('fishers.','details.','islands.island_name','fishers.fisher_first_name','fishers.fisher_last_name','details.weight','species.species_name','purposes.purpose_name','preservations.preservation_name');
}

and then I want to display in a datatable using
protected function getColumns()
{
return [
'purpose_id'=>['title'=>'Purpose'],
// 'fisher_id'=>['title'=>'Fisher Name'],
'fisher_first_name' => new \Yajra\DataTables\Html\Column(['title' => 'Fisher Name', 'data' => 'fisher.fisher_first_name', 'name' => 'fisher.fisher_first_name']),
'preservation_id'=>['title'=>'Preservation Methods'],
'species_id'=>['title'=>'Species Name'],
'weight'
];
}

but this error pop up like this
DataTables warning: table id=dataTableBuilder - Requested unknown parameter 'fisher.fisher_first_name' for row 0, column 1. For more information about this error, please see http://datatables.net/tn/4

tangerine

The link provided in the error message has the necessary diagnostic steps.

pickorea

Hi
I changed my getColumns() methods like this and the issued solved

  protected function getColumns()
      {

    return [
        [ 'data' => 'purpose_name', 'name' => 'purposes.purpose_name', 'title' => 'Purpose' ],
        [ 'data' => 'fisher_first_name', 'name' => 'fishers.fisher_first_name', 'title' => 'Fisher Name' ],
        [ 'data' => 'preservation_name', 'name' => 'preservations.preservation_name', 'title' => 'Preservation Methods' ],
        [ 'data' => 'species_name', 'name' => 'species.species_name', 'title' => 'Species Name' ],
        [ 'data' => 'island_name', 'name' => 'islands.island_name', 'title' => 'Island Name' ],
        [ 'data' => 'weight', 'name' => 'details.weight', 'title' => 'Weight' ],

    ];
  }

and work so well