Filament•2mo ago

export modifyQuery with options

I have a custom page using ExportAction, now I'd like the user to have the possibility to select a custom date range. Now I'm wondering two thing: - How can I fill the options with a default value - How can I access the options in the modifyQuery function ? Thanks!

9 Replies

KeyMe•2mo ago

following this

Lukas Jankauskas•2mo ago

$action->getOptions() does the trick for me in modifyQueryString

KeyMe•2mo ago

modifyquerystring? one possible way tht i know is to define both option form and modifyquery on the export action itself, so we can call the array $data arg

Lukas Jankauskas•2mo ago

Yes https://filamentphp.com/docs/3.x/actions/prebuilt-actions/export#modifying-the-export-query

ExportAction::make()
    ->exporter(ProductExporter::class)
    ->modifyQueryUsing(fn (Builder $query) => $query->where('is_active', true))

ExportAction::make()
    ->exporter(ProductExporter::class)
    ->modifyQueryUsing(fn (Builder $query) => $query->where('is_active', true))

Export action - Actions - Filament

Lukas Jankauskas•2mo ago

in there you can also pass Action $action and do $action->getOptions() Ah, I see I mistyped originally - it's not modifyQueryString but modifyQueryUsing

kool•2mo ago

 ExportAction::make()
      ->exporter(OrderExporter::class)
      ->form([
          Fieldset::make('ordered_at') // ordered_at is a column in orders table
              ->label('Ordered At within Date Range')
              ->schema([
                  DateTimePicker::make('from')
                      ->placeholder('Start Date')
                      ->timezone(config('app.timezone_display')), // optional
                  DateTimePicker::make('to')
                      ->placeholder(__('End Date'))
                      ->timezone(config('app.timezone_display')), // optional
              ])->columns(1),
      ])
      ->modifyQueryUsing(
          fn(OrderBuilder $query, array $data) => $query
              ->whereOrderedAtWithin($data['from'], $data['to'])
      );

 ExportAction::make()
      ->exporter(OrderExporter::class)
      ->form([
          Fieldset::make('ordered_at') // ordered_at is a column in orders table
              ->label('Ordered At within Date Range')
              ->schema([
                  DateTimePicker::make('from')
                      ->placeholder('Start Date')
                      ->timezone(config('app.timezone_display')), // optional
                  DateTimePicker::make('to')
                      ->placeholder(__('End Date'))
                      ->timezone(config('app.timezone_display')), // optional
              ])->columns(1),
      ])
      ->modifyQueryUsing(
          fn(OrderBuilder $query, array $data) => $query
              ->whereOrderedAtWithin($data['from'], $data['to'])
      );

// OrderBuilder.php
public function whereOrderedAtWithin(?string $from, ?string $to): self
{
    return $this
          ->when($from, fn ($query) => $query->where('ordered_at', '>=', $from))
          ->when($to,   fn ($query) => $query->where('ordered_at', '<=', $to));
}

// OrderBuilder.php
public function whereOrderedAtWithin(?string $from, ?string $to): self
{
    return $this
          ->when($from, fn ($query) => $query->where('ordered_at', '>=', $from))
          ->when($to,   fn ($query) => $query->where('ordered_at', '<=', $to));
}

kool•2mo ago

kool•2mo ago

@Ray.nl check this out if it helps

Ray.nl•2mo ago

Thank you, I will try!

Gaming

Programming

export modifyQuery with options