F
Filament•16mo ago
HL

Set multiple columns in protected function getDefaultTableSortColumn()

Is it possible to order a table by multiple columns, just like: 
 $query->orderBy('col1', 'asc')->orderBy->('col2', 'asc')
 $query->orderBy('col1', 'asc')->orderBy->('col2', 'asc')
?
3 Replies
HL
HL•16mo ago
I've tried it based on this
HL
HL•16mo ago
I managed to do it with the getTableQuery() function overwrite in the resource list: 
protected function getTableQuery(): Builder
    {
        return static::getResource()::getEloquentQuery()->orderBy('col1', 'asc')->orderBy->('col2', 'desc');
    }
protected function getTableQuery(): Builder
    {
        return static::getResource()::getEloquentQuery()->orderBy('col1', 'asc')->orderBy->('col2', 'desc');
    }
The only issue with this is that I cannot use the ->sortable() on any of the columns, since this will overwire it anyways I found a github issue where you guys mentioned you'll introduce this featue in v3, looking forward to it! Let me know if there is a better solution though in v2
Dan Harrin
Dan Harrin•16mo ago
i dont think there is a better solution atm
Want results from more Discord servers?
Add your server
More Posts
How do I change the modal text of a custom Action?I have a simple custom Action and I'm using `->requiresConfirmation()`. All that I want is to changeForm validationOn registration or login screen (or when using "Filamament Form Builder" standalone on for frontend MorphToSelect in Repeater (Mdue to MorphMany)Hi all ! I'm trying to develop a planning tool where I've Tasks (or Milestones) and each may have dResource policy issueFrom the docs, edit route should only check the `update()` policy method. Now, I have this weird issSet MarkdownEditor max heightI want to set a max-height for the Markdown editor field I tried this: ``` MarkdownEditor::make('seCan you edit a relation from within a relation? I have pages > questions > answersHey, I want to be able to edit a page. Then see the questions which are related to that page and ediModalAction`->action()` not working inside `->modalActions([]),` showing error like closure not supported....beforeFormFilledHello, With the SpatieMediaLibraryFileUpload i can upload, the media is place in the disk, the recoCreate/Repeater translationsHello, where can I find how to translate the buttons for "New ...label" or the repeater button "Add Having in Table FiltersI am trying to filter a calculated field in a table. It is not finding the calculated field, which i