© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
FilamentF
Filament•13mo ago•
32 replies
guiiz

How add a query to the table

In this table, I need to display only the users where is_super in the database is set to false.
I just started using Filament today. Can someone help me?
 public static function table(Table $table): Table
    {
        return $table
      
            ->columns([
                Tables\Columns\TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                Tables\Columns\TextColumn::make('email')
                    ->searchable()
                    ->sortable(),
                Tables\Columns\ToggleColumn::make('active')
                    ->label('Ativo')
                    ->sortable(),
                Tables\Columns\ToggleColumn::make('is_admin')
                    ->label('Admin')
                    ->sortable()
                    ->disabled(fn (?Model $record) => $record?->id === Auth::id()),
                Tables\Columns\TextColumn::make('created_at')
                    ->searchable()
                    ->sortable()
                    ->dateTime()
                    ->formatStateUsing(fn ($state) => \Carbon\Carbon::parse($state)->format('d/m/y H:i')),
            ])
            ->filters([
                //
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DeleteBulkAction::make(),
                ])  
           
                ,
                ]);
          
    }
 public static function table(Table $table): Table
    {
        return $table
      
            ->columns([
                Tables\Columns\TextColumn::make('name')
                    ->searchable()
                    ->sortable(),
                Tables\Columns\TextColumn::make('email')
                    ->searchable()
                    ->sortable(),
                Tables\Columns\ToggleColumn::make('active')
                    ->label('Ativo')
                    ->sortable(),
                Tables\Columns\ToggleColumn::make('is_admin')
                    ->label('Admin')
                    ->sortable()
                    ->disabled(fn (?Model $record) => $record?->id === Auth::id()),
                Tables\Columns\TextColumn::make('created_at')
                    ->searchable()
                    ->sortable()
                    ->dateTime()
                    ->formatStateUsing(fn ($state) => \Carbon\Carbon::parse($state)->format('d/m/y H:i')),
            ])
            ->filters([
                //
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DeleteBulkAction::make(),
                ])  
           
                ,
                ]);
          
    }
Filament banner
FilamentJoin
A powerful open source UI framework for Laravel • Build and ship admin panels & apps fast with Livewire
20,307Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

how do I add ->with statements to the table query?
FilamentFFilament / ❓┊help
15mo ago
How to use "tableSearch" query string in table builder?
FilamentFFilament / ❓┊help
3y ago
Get search value in table to add custom query to table query
FilamentFFilament / ❓┊help
3y ago
How to add a table in the form builder.
FilamentFFilament / ❓┊help
3y ago