I have to load in a multiselect a lot of records (like 50000), so i need async loading

Async model querying with filter with api() about nova-multiselect-field HOT 2 OPEN

mattiaglacom commented on July 22, 2024

Async model querying with filter with api()

from nova-multiselect-field.

Comments (2)

Norgul commented on July 22, 2024

Probably answer you might not need anymore, and which should definitely be documented.

You are correct to assume that filtering can be done through api() method. The way to do it is to add it to Multiselect element and publish the route like this:

// In resource
Multiselect::make('Products')
    ->api('/api/multiselect/products', Product::class)
    ->singleSelect(), // <-- I am using single select for this, you don't need to.
    
// In api.php
Route::get('multiselect/products', MultiselectProductController::class);

And then this is what the controller should look like:

public function __invoke(Request $request): JsonResponse
{
    $search = $request->get('search'); // <--- you will get user input through this

    if (!$search) {
        return response()->json(); // <--- if you want empty result, you need to return empty json
    }

    $products = Product::query()
        ->where('allowed_for_purchase', true)
        ->where('title', 'LIKE', "%{$search}%")
        ->get();

    if ($products->isEmpty()) {
        return response()->json();
    }

    return response()->json($products->pluck('title', 'id')); // <--- pluck the results for showing them in the frontend correctly
}

Some notes:

If you return response()->json([]), you will get empty row back instead of "No results found"
Plucking needs to have id set as key so you can pick it up later
I found no value in api() third parameter ($keyName), as it didn't change a thing

Hope it helps

from nova-multiselect-field.