F
Filament•2w ago
Stormageddon, Dark Lord of All

Modify Query Using nested relationship

Hi, I have an institution resource, every institution belongs to a state and every state belongs to an admin. admin ----has many---> states ---has many----> institutions I want to only show the institutions that belong indirecly to the currently logged in admin, this is what I attempted but it didn't work: 
            ->modifyQueryUsing(function (Builder $query) {
                return $query->withWhereHas('state.admin', function (Builder $filter) {
                    $filter->where('id', auth()->id());
                });
            ->modifyQueryUsing(function (Builder $query) {
                return $query->withWhereHas('state.admin', function (Builder $filter) {
                    $filter->where('id', auth()->id());
                });
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server
More Posts
Exporting a sorted sum column with ExportActionIm trying to export a list of users with a sum column. im my table for users i added this: ```phpSelectFilter by 2 level relationshipI want to make a SelectFilter by country in a table where I show vehicles. The data model is as folRelationship manager - Issues when using a union relationI am building an application for tracking chess games. I want to be able to look at a player and seI'm using Select::make('manager_id') - but I need to do some conditional if statementsIs there a way to retrieve my created Select::make('manager_id') so I can add additional parameters