Conditional Selectors take too long to load, or fail to load

Xe · 2023-09-18T06:18:39.681Z

Hello, I'll be providing the code that I'm using to load a selector based on another one, It's not generating errors, but it doesn't load sometimes, leading the second selection to always be raw,

X

XeOP•9/18/23, 6:18 AM

Forms\Components\Select::make('wilaya')
                ->options(
                    Wilaya::all()->pluck('designation', 'id')
                )
                ->required()
                ->afterStateUpdated(fn(callable $set) => $set('commune', null)),
            Forms\Components\Select::make('commune')
                ->options(
                    function (callable $get) {
                        $wilaya = Wilaya::find($get("wilaya"));
                        if (!$wilaya) {
                            return []; 
                        }
                        return $wilaya->commune->pluck('nomCommune', 'id');
                    }

Forms\Components\Select::make('wilaya')
                ->options(
                    Wilaya::all()->pluck('designation', 'id')
                )
                ->required()
                ->afterStateUpdated(fn(callable $set) => $set('commune', null)),
            Forms\Components\Select::make('commune')
                ->options(
                    function (callable $get) {
                        $wilaya = Wilaya::find($get("wilaya"));
                        if (!$wilaya) {
                            return []; 
                        }
                        return $wilaya->commune->pluck('nomCommune', 'id');
                    }

Forms\Components\Select::make('wilaya')
                ->options(
                    Wilaya::all()->pluck('designation', 'id')
                )
                ->required()
                ->afterStateUpdated(fn(callable $set) => $set('commune', null)),
            Forms\Components\Select::make('commune')
                ->options(
                    function (callable $get) {
                        $wilaya = Wilaya::find($get("wilaya"));
                        if (!$wilaya) {
                            return []; 
                        }
                        return $wilaya->commune->pluck('nomCommune', 'id');
                    }

Forms\Components\Select::make('wilaya')
                ->options(
                    Wilaya::all()->pluck('designation', 'id')
                )
                ->required()
                ->afterStateUpdated(fn(callable $set) => $set('commune', null)),
            Forms\Components\Select::make('commune')
                ->options(
                    function (callable $get) {
                        $wilaya = Wilaya::find($get("wilaya"));
                        if (!$wilaya) {
                            return []; 
                        }
                        return $wilaya->commune->pluck('nomCommune', 'id');
                    }

X

XeOP•9/18/23, 6:18 AM

here is the code

X

XeOP•9/18/23, 6:19 AM

second table contains too much rows in the db, defeats 3000

L

Lara Zeus•9/18/23, 6:26 AM

try adding

->searchable()

->searchable()

and

->preload()

->preload()

LLara Zeus try adding `->searchable()` and `->preload()`

X

XeOP•9/18/23, 6:28 AM

WORKED LIKE MAGIC

X

XeOP•9/18/23, 6:28 AM

is there anyway I also make it searchable on another attribuute?

X

XeOP•9/18/23, 6:29 AM

of that entity I mean

B

blakdronzer•9/18/23, 6:29 AM

just add it to the option

B

blakdronzer•9/18/23, 6:29 AM

to the child object

B

blakdronzer•9/18/23, 6:29 AM

should work

B

blakdronzer•9/18/23, 6:29 AM

thank you 2 magician @Lara Zeus

Bblakdronzer just add it to the option

X

XeOP•9/18/23, 6:29 AM

how is that?

B

blakdronzer•9/18/23, 6:30 AM

Forms\Components\Select::make('wilaya')
->options(
Wilaya::all()->pluck('designation', 'id')
)
->required()
->afterStateUpdated(fn(callable $set) => $set('commune', null)),
Forms\Components\Select::make('commune')
->options(
function (callable $get) {
$wilaya = Wilaya::find($get("wilaya"));
if (!$wilaya) {
return [];
}
return $wilaya->commune->pluck('nomCommune', 'id');
}
)->searchable()

B

blakdronzer•9/18/23, 6:30 AM

see if thqat works

X

XeOP•9/18/23, 6:31 AM

ahh, so thatt's gonna make it exist twice right?

B

blakdronzer•9/18/23, 6:31 AM

explore and see

Bblakdronzer explore and see 🙂

X

XeOP•9/18/23, 6:35 AM

what I meant was:
I'm only plucking the nomCommune, which is the name,
is there anyway I could make the search include the id, that is in the db

X

XeOP•9/18/23, 6:35 AM

but seeing how this is functionning, the logic seems wrong, this returns only names, so yeah,

L

Lara Zeus•9/18/23, 6:35 AM

pluck('name','id')

LLara Zeus pluck('name','id')

X

XeOP•9/18/23, 6:36 AM

works but makes it only for the id,

X

XeOP•9/18/23, 6:37 AM

well, I think it's already a weird idea,
to search on both, name, or the id if needed

B

blakdronzer•9/18/23, 6:38 AM

https://filamentphp.com/docs/3.x/forms/fields/select#searching-relationship-options-across-multiple-columns

Select - Form Builder - Filament

B

blakdronzer•9/18/23, 6:38 AM

Select::make('author_id')
->relationship(name: 'author', titleAttribute: 'name')
->searchable(['name', 'email'])

B

blakdronzer•9/18/23, 6:38 AM

this way you can .. across multiple fields

Bblakdronzer Select::make('author_id') ->relationship(name: 'author', titleAttribute: 'na...

X

XeOP•9/18/23, 6:58 AM

maybe it's me, but it somehow provoked something like: the search doesn't work
I mean it doesn't do what I needed it to do,
but also the search became global! which isn't somthI want
I'll look it up more later, maybe I just rushed it

Conditional Selectors take too long to load, or fail to load

Similar Threads

Similar Threads

Similar Threads