© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•3y ago•
14 replies
waleedGRT

Can we use collection or array in table query?

I am creating a custom table in Filament, and I want to use a collection of data in the table. However, it seems that the table query in Filament does not support collections. What should I do to work with collections in my custom table?

Error

Filament\Tables\Table::query(): Argument #1 ($query) must be of type Illuminate\Database\Eloquent\Builder|Closure|null, Illuminate\Support\Collection given, called in /var/www/html/app/Filament/Pages/Reports/AccountStatement.php on line 45

Code

    public function table(Table $table): Table
    {


        $record = Account::where('account_type', Account::BANK)->first();


        return $table
            ->query($record->transactionsQuery(Carbon::yesterday() ,Carbon::tomorrow())->get() )
            ->columns([
                TextColumn::make('name')
            ])
            ->filters([
                // ...
            ])
            ->actions([
                // ...
            ])
            ->bulkActions([
                // ...
            ]);
    }
    public function table(Table $table): Table
    {


        $record = Account::where('account_type', Account::BANK)->first();


        return $table
            ->query($record->transactionsQuery(Carbon::yesterday() ,Carbon::tomorrow())->get() )
            ->columns([
                TextColumn::make('name')
            ])
            ->filters([
                // ...
            ])
            ->actions([
                // ...
            ])
            ->bulkActions([
                // ...
            ]);
    }



Collection Data

Illuminate\Support\Collection {#2175 ▼ // app/Filament/Pages/Reports/AccountStatement.php:43
  #items: array:4 [▼
    0 => {#2205 ▼
      +"id": 1
      +"transaction_date": "2023-09-16 10:54:41"
      +"transaction_no": "CP01/0001"
      +"reference": null
      +"transaction_type": "CP"
      +"credited": 1
      +"narration": "Rent "
      +"rate": "1.0000"
    }
    1 => {#2168 ▼
      +"id": 2
      +"transaction_date": "2023-09-16 11:55:13"
      +"transaction_no": "CP01/0002"
      +"reference": null
      +"transaction_type": "CP"
      +"credited": 1
      +"narration": "Consectetur "
      +"rate": "1.0000"
    }
  ]
  #escapeWhenCastingToString: false
}
Illuminate\Support\Collection {#2175 ▼ // app/Filament/Pages/Reports/AccountStatement.php:43
  #items: array:4 [▼
    0 => {#2205 ▼
      +"id": 1
      +"transaction_date": "2023-09-16 10:54:41"
      +"transaction_no": "CP01/0001"
      +"reference": null
      +"transaction_type": "CP"
      +"credited": 1
      +"narration": "Rent "
      +"rate": "1.0000"
    }
    1 => {#2168 ▼
      +"id": 2
      +"transaction_date": "2023-09-16 11:55:13"
      +"transaction_no": "CP01/0002"
      +"reference": null
      +"transaction_type": "CP"
      +"credited": 1
      +"narration": "Consectetur "
      +"rate": "1.0000"
    }
  ]
  #escapeWhenCastingToString: false
}
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Use a collection in a table
FilamentFFilament / ❓┊help
3y ago
Use Array in Table Builder
FilamentFFilament / ❓┊help
16mo ago
Table with Custom Array/Collection Data
FilamentFFilament / ❓┊help
3y ago