F
Filament•6mo ago
Lietze

How to find the current query of the list page?

I have this page where i get 2236 results by default, but when i tinker with Model::count() i get 150 more results than my resource list.. to debug this i would like to see the query built to show the results, so i can figure out what i did wrong
4 Replies
Lietze
Lietze•6mo ago
For people wondering, I found a solution the non-filament way: Added to boot() in AppServiceProvider.php: 
\Event::listen('Illuminate\Database\Events\QueryExecuted', function ($query) {
    logger([$query->sql, $query->bindings, $query->time]);
});
\Event::listen('Illuminate\Database\Events\QueryExecuted', function ($query) {
    logger([$query->sql, $query->bindings, $query->time]);
});
You can find all queries per page logged in the laravel log files
DariusIII
DariusIII•6mo ago
You could add getTableQuery override on list page and dump the original query results or its raw query.
Lietze
Lietze•6mo ago
oh that's great! Will remember that one for next time 😄 TY!
DrByte
DrByte•6mo ago
Laravel DebugBar will also show you the queries.
Want results from more Discord servers?
Add your server
More Posts
Redirect User to Page Out Side Filament Panel After A Record is CreatedAm working on a solution that involves making payments so after a transaction is created or a paymeExtracting form submission data when there are repeaters and relationshipsHey everyone, appreciate it is getting close to Christmas / Holidays for many so I'll try and keep iAttach with dynamic fieldsHi, I'm trying to make a RelationManager attach, when a "Trigger" field is selected, show the fieldsHow to use Table sortable() with Translatable?I have a json column Translatable Model, how do set the order by/sortable()'```Tables\Columns\TextCNumeric format issueI have a problem displaying the total in numbers as "123" instead of "١٢٣" when supporting Arabic laSummarize Sum (quantity * price)I have an attribute in the Cart model and I want to display the sum of this column. How can I do thaRepeatableEntry on InfoList dont show any dataHi everyone (I'm a beginner)! I have a problem, perhaps trivial, when I try to use a "RepeatableEntrIssue with Non-Latin Character Search in Filament TableI am encountering an issue with the search functionality in Filament tables: the search does not yieRoute [filament.admin.auth.login] not defined.thisPrevent action modal from closing automaticallyHi, quick question, is it possible to disable the behavior of action modal closing automatically whe