Many to Many scoping pivot table

[magdicom]

Hello,

I've the following database structure, almost identical to Laravel docs:

posts
    id - integer
    name - string
 
videos
    id - integer
    name - string
 
tags
    id - integer
    name - string
 
taggables
    tag_id - integer
    taggable_id - integer
    taggable_type - string
    published - boolean    <<< 

and here is my models:

<?php
 
namespace App\Models;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    /**
     * Get all of the tags for the post.
     */
    public function tags()
    {
        return $this->morphToMany(Tag::class, 'taggable')
            ->using(Taggable::class);
    }
}

<?php
 
namespace App\Models;
 
use Illuminate\Database\Eloquent\Model;
 
class Tag extends Model
{
    /**
     * Get all of the posts that are assigned this tag.
     */
    public function posts()
    {
        return $this->morphedByMany(Post::class, 'taggable')
            ->using(Taggable::class);
    }
 
}

<?php

use Illuminate\Database\Eloquent\Relations\MorphPivot;

class Taggable extends MorphPivot
{
    protected $table = 'taggables';
}

The problem

I'm trying to scope pivot table inside Tags model but no way I can get it to work, the example provided in Laravel docs doesn't work.

this example is based on the docs, it fires the following exception:

call to undefined method App\Models\Post::taggable()

// App\Models\Tag

public function scopeWherePublished($query){
    return $query->whereHasMorph('taggable', 
            [Post::class, Video::class], 
            function($query){
                    $query->where('published', true);
    });
}

but if I wrote it this way it works:

// App\Models\Tag

public function scopeWherePublished($query){
    return $query->whereHasMorph('posts', 
            [Post::class, Video::class], 
            function($query){
                    $query->where('published', true);
    });
}

but this is not how it should work, I should be able to query using pivot table not the main.

I've tried many other things and searched, but no succeed, any help/ideas really appreciated.

[magdicom]

I was thinking that in all cases the pivot table will always be included in query, so why not deal with it this way:

\\App\Models\Tag

public function scopeWherePublished(Builder $query){
    return $query->where('taggables.published', true);
}

and it works as expected, but my question remains, is this the right way to do it?