FilamentF
Filament•2y ago
ericmp

How to share resource table to relation manager without modifying the query

SongResource:
i have a table

then, in ArtistResource, i have a SongsRelationManager
(artist n n song)

so i found out that in the SongsRelationManager i can do this:
public function table(Form $table): Form
{
    return SongResource::table($table);
}


but i see all the songs, not the artist's ones.

then, to solve it i modified the query:
public function table(Form $table): Form
{
    return SongResource::table($table)->query(Song::query()->whereHas('artists', fn ($q) => $q->where('artists.id', $this->ownerRecord->id)));
}


so its done. but no! cuz songs have genres. in this case im assuming a song has only 1 genre and 1 genre has many songs. this being said, now i have an issue with the modified query. now i dont know if i have to search for artists relationship or if i have to search in the genre_id field :/

what would u do?
Was this page helpful?