#How to access attributes of a selected record, without duplicate queries?

6 messages · Page 1 of 1 (latest)

drifting cobalt
#

Hi, I want to display additional information of the selected company using Placeholders. But each time I use Company::find($get('company_id')) an additonal query will be fired. How can I prevent this?

                        Forms\Components\Repeater::make('excursionsCompanies')
                            ->label(__('excursion.excursionsCompanies'))
                            ->addActionLabel(__('excursion.add_company'))
                            ->relationship()
                            ->itemLabel(fn (array $state): ?string => Company::find($state['company_id'])?->name)
                            ->orderColumn('sort')
                            ->schema([
Forms\Components\Select::make('company_id')
                                    ->label(__('company.singular'))
                                    ->live()
                                    ->searchable()
                                    ->relationship('company', 'name')
                                    ->required(),

                                Forms\Components\Placeholder::make('company_address')
                                    ->label(__('company.address'))
                                    ->hidden(fn (Get $get) => ! $get('company_id'))
                                    ->content(fn (Get $get) =>     Company::find($get('company_id'))?->fullAddress),
];

In the example above, 2 duplicate queries are created.

Thank you!

pastel knotBOT
#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution

lilac heart
#

You can't access the record directly. I usually add a function to cache the response for a short period.

drifting cobalt
lilac heart
#

->content(fn (Get $get) => static::getCompany($get('id'))

static function getCompany(int|string $id) {
   return once(fn () => Company::find($get('company_id'))?->fullAddress));
}
drifting cobalt