Joining DB tables into single Filament table | Filament | Page 1

drowsy coral Jul 31, 2024, 6:01 PM

#

what about a db view? You could use this view as a Model
https://stackoverflow.com/questions/26593270/how-to-access-db-views-using-laravel-models

Stack Overflow

How to access db views using Laravel models?

I am porting a Postgres-backed web app to Laravel 4.2, and I can't see a way to utilize the existing eight or so summation views which are built in the psql db. These views preform various aggrega...

rocky furnace Jul 31, 2024, 6:20 PM

#

Yes, I saw your comment on GitHub here https://github.com/filamentphp/filament/discussions/10228 and I actually did the same question there. The problem is that I would need one view for each date, because this table would only show records for a specific day.

GitHub

How To Use Filament Table Builder with Laravel Database Query Build...

Occasionally, in tables, we employ multiple table joins to fetch and display data. In certain scenarios, using Query Builder instead of Eloquent Builder may be necessary. Are there any ways to impl...

#

The $table value would need to be something like $table = "appointments_view_<date-filter-value>", e.g.: $table = "appointments_view_2024-05-05"

rocky furnace Jul 31, 2024, 7:01 PM

#

Maybe every time the filter changes I truncate the view and re-add according to the filter's value?

#

I'm saying truncate and re-add so there's always updated data

drowsy coral Jul 31, 2024, 7:15 PM

#

Honestly, I don’t understand why different view names are necessary when you can use a query to filter what you need..

#Joining DB tables into single Filament table