How do I format related fields?

[giles247]

So I need to format a field from a related table. I can display a column for this field with:

Column::make('Country', 'user.country.short_code')

Great, but how do I access the same field in say in a custom view or using format or label?

Neither of these work:

Column::make('Country')
    ->label(
        fn($row, Column $column)  => '<strong>' . $row->user->country->short_code . '</strong>'
    )
    ->html(),

or:

Column::make('Country')
    ->label(
        fn($row, Column $column) => view('my.other.view')->withRow($row)
    ),

and then for 'my.other.view'

<strong> {{ $row->user->country->short_code }} </strong>

Any help appreciated?

Note: In v1 with rowView everything was so much simpler - one single place where you could define the formatting for all your columns and add any custom conditions, AND you automatically had access to all fields from your query. Now in v2 seems you need to potentially define new views for every column with special formatting/conditions AND you don't have access to fields you need :(

[giles247]

Ok, so I've sort of got this working...

For first example syntax needs to be:

Column::make('Country')
    ->label(
        fn($row, Column $column)  => '<strong>' . $row['user.country.shortcode'] . '</strong>'
    )
    ->html(),

BUT that will only work if you create a hidden column before it:

            Column::make('Country', 'user.country.short_code')
                ->hideIf(true), // field included and hidden so can use in later

as stated on Slack, once again seems I'm being forced to create hidden columns just so that I have access to value elsewhere.