Unique Multiple Columns

Hi everyone, I'm using this code to validate multiple columns, but I'm not sure how to handle the exception.

2 Replies

This solution in my job work, check please

Forms\Components\Select::make('warehouse_id')
    ->relationship('warehouse', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->live(),

Forms\Components\Select::make('product_id')
    ->relationship('product', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->unique(ignoreRecord: true, modifyRuleUsing: function (Unique $rule, Get $get) {
        return $rule
            ->where('warehouse_id', $get('warehouse_id'));
    }),

Forms\Components\Select::make('warehouse_id')
    ->relationship('warehouse', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->live(),

Forms\Components\Select::make('product_id')
    ->relationship('product', 'name')
    ->searchable()
    ->preload()
    ->required()
    ->unique(ignoreRecord: true, modifyRuleUsing: function (Unique $rule, Get $get) {
        return $rule
            ->where('warehouse_id', $get('warehouse_id'));
    }),

Dennis Koch•7mo ago

If it throws an exception your rule isn’t working. Otherwise it would return a validation exception.

Gaming

Programming

Unique Multiple Columns