Add BelongsToMany related object more than once

[8-gluttony-8]

Hi !
I'd like to add a field BelongsToMany, it works perfectly, except I'd like to be able to add twice or more the same related object. I have indeed a unique key on product_id, supplier_id & effective_date on my pivot table. I've tried by setting the query in asyncSearch without succes. How should I proceed? Thank you very much for your input !

BelongsToMany::make(
        __('Search suppliers'),
        'suppliers',
        resource: SupplierResource::class
    )->fields([
        Number::make(__('fields.purchase_cost'), 'purchase_cost')->step(2),
        Select::make(__('fields.currency'), 'currency')
            ->options(
                Currency::query()
                    ->pluck('name', 'id')
                    ->toArray()
            ),
        Switcher::make(__('fields.is_primary'), 'is_primary'),
        Date::make(__('fields.effective_date'), 'effective_date'),
        Date::make(__('fields.end_date'), 'end_date'),
    ])->asyncSearch(
        'name'
    ),

[lee-to]

I didn't quite understand the question! Please tell me in more detail the case when you need to use this field with the same relation twice and what error you get when using asyncsearch

[lee-to]

Example that might me useful for you

use App\MoonShine\Resources\CountryResource;
use Illuminate\Contracts\Database\Eloquent\Builder;
use Illuminate\Http\Request;
use MoonShine\Laravel\Fields\Relationships\BelongsToMany;
use MoonShine\UI\Fields\Field;

BelongsToMany::make('Countries', 'countries', resource: CountryResource::class)
    ->asyncSearch(
        'title',
        searchQuery: function (Builder $query, Request $request, Field $field) {
            return $query->where('id', '!=', 2);
        },
        formatted: function ($country, Field $field) {
            return $country->id . ' | ' . $country->title;
        },
    )

[8-gluttony-8]

He @lee-to !

Thanks for taking the time! A picture might help explain my issue more clearly

Here, I've already added "toto" supplier. I'd like to add it again, but with a different effective_date. But when I search, I have no result since it already has been added. I've tried defining the searchQuery, but with not luck

BelongsToMany::make(
    __('Search suppliers'),
    'suppliers',
    resource: SupplierResource::class
)->fields([
    Number::make(__('fields.purchase_cost'), 'purchase_cost')->step(2),
    Select::make(__('fields.currency'), 'currency')
        ->options(
            Currency::query()
                ->pluck('name', 'id')
                ->toArray()
        ),
    Switcher::make(__('fields.is_primary'), 'is_primary'),
    Date::make(__('fields.effective_date'), 'effective_date'),
    Date::make(__('fields.end_date'), 'end_date'),
])->asyncSearch(
    'name',
    searchQuery: function (Builder $query, Request $request, $field) {
        return $query->where('name', 'like', '%'.$field.'%');
    },
),

Thx again !

[lee-to]

Unfortunately, we have keys in the request and then we synchronize them, but I solved the problem like you did on another project, I just created my own field

[lee-to]

I also created a task, I think when I have time we will make such an opportunity in the box