Linking Between Table Views with a Filter Value

Dave Mack · 2023-09-27T06:09:41.496Z

I am relatively new to Filament. I am wanting to create an action that will link from one Table Resource to another in filament, but I want to pass through a filter value in the link so the 2nd table resource is only showing the records that I want shown based on the filter I pass through. I can't see anywhere in the documentation about this.

P

Patrick Boivin•9/27/23, 1:54 PM

Are are you creating the link from one table to the other?

D

Dave MackOP•9/27/23, 9:03 PM

Yes - trying to…

P

Patrick Boivin•9/27/23, 9:03 PM

Sorry, I meant

How are you creating the link

How are you creating the link

How are you creating the link

How are you creating the link, lol

D

Dave MackOP•9/27/23, 9:04 PM

Using an Action with a URL - I can create the route, but I cannot add the parameter with the filter value

P

Patrick Boivin•9/27/23, 9:04 PM

Can you share the code you are trying?

D

Dave MackOP•9/27/23, 9:06 PM

Action::make('Show Survey Sections')
->url(fn(EventSurvey $record): string => route('filament.admin.resources.event-survey-sections.index', ['event_survey_id' => $record->id])),

D

Dave MackOP•9/27/23, 9:09 PM

The URL I need to end up with is admin/event-survey-sections?tableFilters[event_survey_id][value]=1 which is what I get when I manually filter the data - but I want to be able to create this link from an action in the "Event Survey" table rows...

Solution

P

Patrick Boivin•9/27/23, 9:13 PM

I think this should work:

route('filament.admin.resources.event-survey-sections.index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

route('filament.admin.resources.event-survey-sections.index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

route('filament.admin.resources.event-survey-sections.index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

route('filament.admin.resources.event-survey-sections.index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

P

Patrick Boivin•9/27/23, 9:14 PM

Or through the resource class:

EventSurveySectionsResource::getUrl('index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

EventSurveySectionsResource::getUrl('index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

EventSurveySectionsResource::getUrl('index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

EventSurveySectionsResource::getUrl('index', [
    'tableFilters' => [
        'event_survey_id' => [
            'value' => $record->id,
        ],
    ],
])

D

Dave MackOP•9/27/23, 9:24 PM

You're a legend! i am almost certain that I tried the first option (which I am going to use), however clearly, I had something not hooked up correctly... Thankyou so much for your help...

B

BuddhaNature•11/16/23, 8:35 PM

I tried this, but ended up with an encoded URL that did not cause the trigger to work. Is this solution still working for you all?

B

BuddhaNature•11/16/23, 8:36 PM

This is what I get:

/company?tableFilters%5Bcompany%5D%5Bname%5D%5Bvalue%5D=01hfafyrgq166fqr022yrjyyax

/company?tableFilters%5Bcompany%5D%5Bname%5D%5Bvalue%5D=01hfafyrgq166fqr022yrjyyax

/company?tableFilters%5Bcompany%5D%5Bname%5D%5Bvalue%5D=01hfafyrgq166fqr022yrjyyax

/company?tableFilters%5Bcompany%5D%5Bname%5D%5Bvalue%5D=01hfafyrgq166fqr022yrjyyax

B

BuddhaNature•11/16/23, 8:41 PM

Action::make('company')
    ->url(
        fn($record): string => CompanyResource::getUrl(
            'index',
            [
                'tableFilters' => [
                    'company' => [
                        'name' => [
                            'value' => $record->id,
                        ],
                    ],
                ],
            ]
        )
    ),

Action::make('company')
    ->url(
        fn($record): string => CompanyResource::getUrl(
            'index',
            [
                'tableFilters' => [
                    'company' => [
                        'name' => [
                            'value' => $record->id,
                        ],
                    ],
                ],
            ]
        )
    ),

Action::make('company')
    ->url(
        fn($record): string => CompanyResource::getUrl(
            'index',
            [
                'tableFilters' => [
                    'company' => [
                        'name' => [
                            'value' => $record->id,
                        ],
                    ],
                ],
            ]
        )
    ),

Action::make('company')
    ->url(
        fn($record): string => CompanyResource::getUrl(
            'index',
            [
                'tableFilters' => [
                    'company' => [
                        'name' => [
                            'value' => $record->id,
                        ],
                    ],
                ],
            ]
        )
    ),

BBuddhaNature I tried this, but ended up with an encoded URL that did not cause the trigger to...

B

bernhard•1/30/24, 9:59 AM

The encoded url isn't the problem. You should change

value

value

value

value to

search

search

. This should work

B

bernhard•1/30/24, 9:59 AM

So

Action::make('company')
  ->url(
      fn($record): string => CompanyResource::getUrl(
          'index',
          [
              'tableFilters' => [
                  'company' => [
                      'name' => [
                          'search' => $record->id,
                      ],
                  ],
              ],
          ]
      )
  ),

Action::make('company')
  ->url(
      fn($record): string => CompanyResource::getUrl(
          'index',
          [
              'tableFilters' => [
                  'company' => [
                      'name' => [
                          'search' => $record->id,
                      ],
                  ],
              ],
          ]
      )
  ),

Action::make('company')
  ->url(
      fn($record): string => CompanyResource::getUrl(
          'index',
          [
              'tableFilters' => [
                  'company' => [
                      'name' => [
                          'search' => $record->id,
                      ],
                  ],
              ],
          ]
      )
  ),

Action::make('company')
  ->url(
      fn($record): string => CompanyResource::getUrl(
          'index',
          [
              'tableFilters' => [
                  'company' => [
                      'name' => [
                          'search' => $record->id,
                      ],
                  ],
              ],
          ]
      )
  ),

Linking Between Table Views with a Filter Value

Similar Threads

Similar Threads

Similar Threads