F
Filament•5mo ago
thyk123

What query to select from date now and see between 2 column

What query to select from date now and see between 2 column, like i want to check is today still more than startDate and less than dueDate, if still in that period of time, get the data of it and add it to select option
Solution:
you want to get options for a select input, based on a query? If yes you can use the ->->options like that: ``` use Filament\Forms\Components\Select;...
Jump to solution
2 Replies
Solution
sandofgods
sandofgods•5mo ago
you want to get options for a select input, based on a query? If yes you can use the ->->options like that: 
use Filament\Forms\Components\Select;
 
Select::make('tasks_name')
    ->label('Task to do')
    ->options(Tasks::where([
        ['colum_start_date','<',$now],
        ['column_due_date','>',$now]
        ])->get()->pluck('option_colum_to_select', 'id'))
use Filament\Forms\Components\Select;
 
Select::make('tasks_name')
    ->label('Task to do')
    ->options(Tasks::where([
        ['colum_start_date','<',$now],
        ['column_due_date','>',$now]
        ])->get()->pluck('option_colum_to_select', 'id'))
thyk123
thyk123•5mo ago
Thank you so much for helping! You're so awesome!
Want results from more Discord servers?
Add your server
More Posts
Closure Upload Folder dynamicHow to use dynamic id based on select? Case: upload multiple pictures to one gallery. PS: i need saCan we modify the dd tag that contains custom infolist entries?Hello all, I was working on creating a custom infolist entry for my app (basically a scrollable `prSubfroms /sections with individual actionsI am structuring my complex form using sections and I would like to do separate updates, section by translate badge columnHow can I translate a badge Column in Filament3?Conditionally show relation managerMy items model, if a condition is met, will be able to have users or not. This condition can be calExport Button has no export option on a custom table in livewireI created a custom export table and added an export action but it seems I cannot exportHow to specify ignoreRecord in unique rule in Import?I've added an import action to a model with option to update existing record via `firstOrNew` methodSelect Field Component State: Injecting Title along with IDHey all, Wondering if this is possible at all without formatting the state with ->formatStateUsing(Filament Fabricator dynamic route challengeHow to create #filament-fabricator pages with dynamic routes like list pages, search pages where youImportPolicyI wish to authorize imports of models based on model specific permissions. How can I control it usin