Request for lens support about laravel-nova-excel HOT 4 CLOSED

Can you please open a new issue for that, so we won't loose track of it.

from laravel-nova-excel.

Lenses are supported. You have to call ->onlyIndexFields() to let it select all index fields that are defined on that lens (https://laravel-excel.maatwebsite.nl/nova/1.0/exports/customizations.html#exporting-all-index-columns)

from laravel-nova-excel.

Next release will do onlyIndexFields() be default. Possible to customize with only or except (or allFields)

from laravel-nova-excel.

@patrickbrouwers oh awesome! Completely overlooked that haha :)

That would be so great if it were the default! That was my initial expectation, feels natural.

Related issue, I made some dynamic columns like so

public static function query(LensRequest $request, $query)
{
    return $request->withOrdering($request->withFilters(
        $query->select([
            'id',
            \DB::raw('YEAR(`created_at`) AS `year`'),
            \DB::raw('QUARTER(`created_at`) AS `quarter`'),
            \DB::raw('MONTHNAME(`created_at`) AS `month`'),
        ])
    ));
}

and it threw the following sql related error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'year' in 'field list' (SQL: select `id`, `year`, `quarter`, `month` ...etc

Although it displays as intended, the query for excel seems to be using fields vs query or something

from laravel-nova-excel.