F
Filament•5mo ago
c-monster

Select->relationship order

I've just found Filament and am loving it! Is it possible to specify a sort order when displaying a select with a relationship? Rather than have the options in alpha order by name? 
Select::make('category')
-> relationship('category','name')->orderby('category.id', 'DESC'),
Select::make('category')
-> relationship('category','name')->orderby('category.id', 'DESC'),
Thanks, c-monster
2 Replies
awcodes
awcodes•5mo ago
There’s a third parameter for relationship() where you can override the query.
c-monster
c-monster•5mo ago
Thanks for the clue and pushing me to work it out. 
Select::make('category')
                ->relationship(
name: 'category', 
titleAttribute:'name',                modifyQueryUsing:fn(Builder $query)=>$query->orderBy('id','asc')),
Select::make('category')
                ->relationship(
name: 'category', 
titleAttribute:'name',                modifyQueryUsing:fn(Builder $query)=>$query->orderBy('id','asc')),
Want results from more Discord servers?
Add your server
More Posts
Database notification slowing down the app performanceI've observed a performance issue while utilizing the database notification feature. When dealing wiPanel Nav Bar item focus when clickWhen I select the nav bar item, the scroll bar go back to the top. I want to remain the nav bar at tIs there a way to override vendor/filament/filament/routes/web.php?Is there a way to override vendor/filament/filament/routes/web.php?AdBlock makes filament super slowMore of an FYI than help required. But AdBlock plugin on chrome makes filament run very slow.Badge Color From RelationshipI have the following: ``` Tables\Columns\TextColumn::make('symptomLogs.symptom.name') Filtering Widget Data is Not WorkingHello Everyone, Regarding https://filamentphp.com/docs/3.x/panels/dashboard#filtering-widget-data Clicking 'view' on resource with hasMany relations manager should not open in modalI defined a relation mgr on a resource (master-detail structure) Whilst create and edit icons on eagetSearchResultsUsing() access other formdataHey, Is it possible to access order data from the resource besides the $search string? For Example