Canot access relationships inside map collection

@Snapey i get same error message

Property [template_name] does not exist on this collection instance.

i can get the relation like this

public function map($jobsExport): array
    {
        dd($jobsExport->templates);

//but i cant get the template_name
public function map($jobsExport): array
    {
        dd($jobsExport->templates->template_name);

@Leon012 I assume that templates means that there are more than 1. So you cannot just get a property like that

here I get the first, but you could do a foreach() instead

dd($jobsExport->templates->first()->template_name);

@Sinnbeck Yes like that i can get the first template name

@Leon012 Exactly. But you need them all? How do should be be added in the excel file? Just comma separated inside a cell?

dd($jobsExport->templates->pluck('template_name')->implode(', '));

Edit: Sorry didnt see @silencebringer has just answered the same :)

@Sinnbeck It is okay now i understand the implode method. But another problem is all record are exported, and i sent just selcted record form front

@Leon012 looks like you have wrong relationship type for templates, because it returns you the collection

So, your job hasMany templates. This way you can't use it like $jobsExport->templates->template_name, it may be something like https://laravel.com/docs/9.x/collections#method-implode

$jobsExport->templates->implode('template_name', ', ')

to join all templates names in a line

@SilenceBringer This is working perfect i can export template_name with implode method.

But there is still a problem, from the front i send only selected record from table but anyway this methos exports all records

@Leon012 because here

public function jobsExport(){
        return Job::with(['templates', 'teams'])->get();
    }

you returns all the records (not filtered). Apply required where conditions to select the records you need, like https://laravel.com/docs/9.x/queries#conditional-clauses

	public function jobsExport(){
        return Job::with(['templates', 'teams'])
			->when(request('ids'), fn ($query) => $query->whereIn('id, request('ids')))
			->get();
    }

@SilenceBringer this does not work , it export all records again. If i dd this method return me all record

@Leon012 it means you did filtering wrong. Please, provide me with the dump of request data

	public function jobsExport(){
		dd(request()->all());
        return Job::with(['templates', 'teams'])->get();
    }

@SilenceBringer dd(request()->all()); return empty array []

@Leon012 which means you do not send and data for filtering. What do you expect this way? All the data is corrrect result

@SilenceBringer i see , and i send data from front using vue js like this

watch: {
//get all selected record and pass on `/export/jobs/` route
            selected: function(){
                this.url = '/export/jobs/' + this.selected;
            }
        },

route

Route::any('export/jobs/{jobs}', [JobController::class, 'export']);

@SilenceBringer I tryed this method with $jobs and $request but i have got this error

Too few arguments to function App\Models\Job::jobsExport(), 0 passed in 
...app\Exports\JobsExport.php on line 26 and exactly 1 expected

@Leon012

public function export(Job $jobs)
    {
		dd($jobs);
        return Excel::download(new JobsExport($jobs), 'jobs.xlsx');
    }

@SilenceBringer

App\Models\Job {#1399 ▼
  #fillable: array:6 [▶]
  #connection: "mysql"
  #table: "jobs"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  +preventsLazyLoading: false
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #escapeWhenCastingToString: false
  #attributes: array:9 [▶]
  #original: array:9 [▶]
  #changes: []
  #casts: []
  #classCastCache: []
  #attributeCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #guarded: array:1 [▶]
}

this is the result from controller

@leon012

class JobsExport implements FromCollection, WithMapping, WithHeadings
{
	// ...

    public function collection()
    {
        return $this->jobs->jobsExport($this->jobs);
    }

	// ... 
}

@SilenceBringer Okay but i don see where is the difference here, on modal still i get empty array

@aosdev i have many to many relationships. but if i try this

$job = $jobs->id;

return Job::with([ 'templates', 'teams'])
            ->when($job, function ($query, $job) {
                $query->where('id', $job);
            })
            ->get();

i get only first record i select