Feature Request: Performant disableOptionWhen to Avoid N+1 Queries

[andrewdwallo]

Issue

When using disableOptionWhen with a Select component, it's highly probable to create an N+1 query problem:

$this->disableOptionWhen(function (string $value) {
    $adjustment = Adjustment::find($value); // Separate query for EACH option
    return $adjustment?->status !== AdjustmentStatus::Active;
});

This becomes highly inefficient with many options.

Proposed Solution

Add a more efficient way to disable options based on model attributes without triggering separate queries if using a relationship(), or add some type of bulk behavior.

[Cepairda]

@andrewdwallo Hi. Have you found any solution to this problem?

[andrewdwallo]

Nope