Ariel MejiaFilament Resources allow to create quickly tables by mapping objects, it allows to add easily pretty common features like:
- sortable
- searchable
- and more features
in this case to debug the search query we can check the List class that is created by default when a user creates a filament resource, eg:
User Resource
class UserResource extends Resource
{
protected static ?string $model = User::class;
public static function getPages(): array
{
return [
'index' => ListUsers::route('/'),
// ... more pages
];
}
}
ListUsers
Here we can override a getFilteredTableQuery method to check the raw sql and debug the query
protected function getFilteredTableQuery(): Builder
{
dd(parent::getFilteredTableQuery()->toRawSql());
}
Hope it is useful & Happy Coding!
