Form Select - Search Across Relationship

I have 3 resources.
- OfficeResource (Model: Office)
- OfficeAddressResource (Model: OfficeAddress)
- CountryResource (Model: Country)

I have a form on the OfficeResource with a select field. This select field searches the OfficeAddress table and allows for the selection of an address. The OfficeAddress model has a

hasone

hasone

relationship with the model Country.

Problem: On my OfficeResource form, I want to search by the address, city, and country.common_name in the address select form element. How would I accomplish this?

(I would love to add something like

->searchable(['street_address', 'city', 'country.common_name'])

->searchable(['street_address', 'city', 'country.common_name'])

But I know that's not possible.

Here is the select element on the OfficeResource form:

Select::make('office_physical_address_id')
    ->label('Physical Address')
    ->relationship(name: 'physicalAddress', titleAttribute: 'street_address')
    ->getOptionLabelFromRecordUsing(fn(OfficeAddress $record) => $record->full_address)
    ->searchable(['street_address', 'city'])
    ->createOptionForm(OfficeAddressForm::getForm())
    ->editOptionForm(OfficeAddressForm::getForm())
    ->helperText('Click the + button to add a new address, or choose from the dropdown.')
    ->preload(),

Select::make('office_physical_address_id')
    ->label('Physical Address')
    ->relationship(name: 'physicalAddress', titleAttribute: 'street_address')
    ->getOptionLabelFromRecordUsing(fn(OfficeAddress $record) => $record->full_address)
    ->searchable(['street_address', 'city'])
    ->createOptionForm(OfficeAddressForm::getForm())
    ->editOptionForm(OfficeAddressForm::getForm())
    ->helperText('Click the + button to add a new address, or choose from the dropdown.')
    ->preload(),

Solution

Modify the return options?

    ->getSearchResultsUsing(fn (string $search): array => OfficeAddress::where('street_address', 'like', "%{$search}%")->orWhere('city', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')->toArray())

    ->getSearchResultsUsing(fn (string $search): array => OfficeAddress::where('street_address', 'like', "%{$search}%")->orWhere('city', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')->toArray())

Jump to solution

Form Select - Search Across Relationship

hasone

hasone

->searchable(['street_address', 'city', 'country.common_name'])

->searchable(['street_address', 'city', 'country.common_name'])

But I know that's not possible.

Here is the select element on the OfficeResource form:

Select::make('office_physical_address_id')
    ->label('Physical Address')
    ->relationship(name: 'physicalAddress', titleAttribute: 'street_address')
    ->getOptionLabelFromRecordUsing(fn(OfficeAddress $record) => $record->full_address)
    ->searchable(['street_address', 'city'])
    ->createOptionForm(OfficeAddressForm::getForm())
    ->editOptionForm(OfficeAddressForm::getForm())
    ->helperText('Click the + button to add a new address, or choose from the dropdown.')
    ->preload(),

Select::make('office_physical_address_id')
    ->label('Physical Address')
    ->relationship(name: 'physicalAddress', titleAttribute: 'street_address')
    ->getOptionLabelFromRecordUsing(fn(OfficeAddress $record) => $record->full_address)
    ->searchable(['street_address', 'city'])
    ->createOptionForm(OfficeAddressForm::getForm())
    ->editOptionForm(OfficeAddressForm::getForm())
    ->helperText('Click the + button to add a new address, or choose from the dropdown.')
    ->preload(),

Solution

Modify the return options?

    ->getSearchResultsUsing(fn (string $search): array => OfficeAddress::where('street_address', 'like', "%{$search}%")->orWhere('city', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')->toArray())

    ->getSearchResultsUsing(fn (string $search): array => OfficeAddress::where('street_address', 'like', "%{$search}%")->orWhere('city', 'like', "%{$search}%")->limit(50)->pluck('name', 'id')->toArray())

Jump to solution

Form Select - Search Across Relationship

Form Select - Search Across Relationship

Similar Threads

Similar Threads

Similar Threads