export relations value about laravel-nova-excel HOT 9 CLOSED

Hey!

You can follow this example: https://laravel-excel.maatwebsite.nl/nova/1.0/exports/customizations.html#concerns

Inside the map() function, return something like

return [
    $post->user->name,
];

I'd recommend enabling eager loading for the user relation though!

Maybe in the future I'll add automatic support for BelongsTo fields. I'll have to see if that's possible.

from laravel-nova-excel.

@patrickbrouwers was just coming to ask for the same thing! :)

Export BelongsTo using the $title would be very intuitive as exporting the currently viewed table

from laravel-nova-excel.

WIP for BelongsTo fields with using the $title: #26, feel free to give it a test.

from laravel-nova-excel.

@patrickbrouwers

if you do the following, It will display in nova & export but not in the expected order

$with = ['user'];

Text::make('Name', 'users.name'),
Text::make('Created', 'created_at')

Created | Name vs Name | Created

from laravel-nova-excel.

@dillingham hm, I'm not sure where/how Nova orders the columns. Results currently end-up in the export based on the order of columns the query returns.
I haven't tested it, but do you have this both on resource and lens exports?

from laravel-nova-excel.

Perhaps I should rewrite protected function replaceFieldValuesWhenOnResource(Model $model, array $only = []): array to loop through the fields (so use that order) instead of using the $only array as order.

from laravel-nova-excel.

@dillingham field order is now respected.

Released as 1.1

from laravel-nova-excel.

Hi Patrick,
Is there any way I can turn this "Respect the field order determined in the resource when exporting (#22)" Off as I want it to follow the order as given in the only().

from laravel-nova-excel.

@sonalmahajan01 currently not. I'm happy to accept a PR that offers a way of doing that. If you need it on priority you can consider checking our commercial support: https://laravel-excel.com/commercial-support

from laravel-nova-excel.