Please add ability to use wherePivot with Tag

[vedmant]

I'm using Tag field to attach contributors to my board object, however my pivot table has a role attribute, which can be contributor or admin, AI helper offered to use BelongsToMany instead, but this is pretty inconvenient.

Would be nice to have ability to specify wherePivot for a Tag field as well. I was able to use Tag field as read only (which is also useful), since updating doesn't work, it ignores wherePivot.

Another of my project actually have tag types, like "tag, character, parody, ...` so this is pretty much applicable for more flexible tags functionality as well.

Here is AI response

The Tag field in Laravel Nova is designed to work with BelongsToMany relationships, but it doesn't directly support the wherePivot clause you're using in your relationship definition. The Tag field will display all related users, regardless of the wherePivot condition.

To work around this limitation, you have a few options:

Create a custom field that extends the Tag field and overrides the necessary methods to apply the wherePivot condition.

Use a BelongsToMany field instead of a Tag field, and apply the condition in the field definition:

use Laravel\Nova\Fields\BelongsToMany;

BelongsToMany::make('Admin Users')
    ->resolveUsing(function ($value) {
        return $value->wherePivot('role', 'admin');
    });

Create a separate relationship method in your model specifically for admin users, and use that with the Tag field:
public function adminUsers()

{
    return $this->belongsToMany(User::class, 'contributors', 'board_id', 'user_id')
                ->wherePivot('role', 'admin');
}

// In your Nova resource
Tag::make('Admin Users', 'adminUsers');