T
HHTTTTHT
HTHTH
@TallyT
Select::make('categories')
->label('Category')
->relationship('categories')
->multiple()
->searchable()->preload()->required(),SQLSTATE[42S22]: Column not found: 1054 Unknown column 'post_categories.' in 'field list' public function categories(): HasMany
{
return $this->hasMany(PostCategory::class, 'post_id');
}<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Relations\Pivot;
class PostCategory extends Pivot
{
use HasFactory;
protected $table = 'post_categories';
public $timestamps = false;
protected $fillable = ['post_id', 'category_id'];
public function post(): BelongsTo
{
return $this->belongsTo(Post::class);
}
public function category(): BelongsTo
{
return $this->belongsTo(Category::class);
}
} ->relationship('categories', 'title'), public function categories(): BelongsToMany
{
return $this->belongsToMany(Category::class, 'post_categories', 'post_id', 'category_id');
}Tables\Columns\TextColumn::make('categories.name')
->label('Categories')
->badge(),