Filament•16mo ago

Is it possible to make a table column unique on a per tenant basis?

I have implemented multi-tenancy into my application but I want to restrict the name attribute of my Project class to be unique BUT on a tenant by tenant basis. For example: I have $table->string('name')->unique(); which only allows a single, unique name but what I want to do is if Tenant A names it Project1 and then tries to create another called Project1 then that will not be allowed but if Tenant B called one Project1 then this would be fine. Is this possible using any helper or is this going to be a custom function I will need to build? Thanks for your help in advance.

8 Replies

krekas•16mo ago

Custom rule should do it

Brian Kidd•16mo ago

Yes, agree with @krekas , you create a custom rule or check if the unique rule supports multiple fields. Never done it with the standard unique rule but check the method signature before creating a custom rule.

krekas•16mo ago

unique accepts closure so maybe it could also be done there

MartinKnops•15mo ago

i'm also looking for a sollution, did you manage to fix it?

krekas•15mo ago

https://laraveldaily.com/post/filament-3-multi-tenancy-validation-unique-value-per-tenant

Laravel Daily

Filament 3 Multi-Tenancy: Validation - Unique Value Per Tenant

GDGOP•15mo ago

This is perfect, thanks

GDGOP•15mo ago

Just as an addition to this, I added a cross reference to my pivot table. Just posting here incase anybody had the same issue. There may be a lighter way to do this but wanted to share it all the same.

->rules([
                                    function () {
                                        return function (string $attribute, $value, Closure $fail) {
                                            $hasProject = auth()->user()->projects()
                                                ->where('name', $value)
                                                ->exists();
                                            if ($hasProject) {
                                                $fail('You already have a project called '.$value);
                                            }
                                        };
                                    },
                                ])

->rules([
                                    function () {
                                        return function (string $attribute, $value, Closure $fail) {
                                            $hasProject = auth()->user()->projects()
                                                ->where('name', $value)
                                                ->exists();
                                            if ($hasProject) {
                                                $fail('You already have a project called '.$value);
                                            }
                                        };
                                    },
                                ])

krekas•15mo ago

When posting code use three backticks. #✅┊rules 4

Gaming

Programming

Is it possible to make a table column unique on a per tenant basis?