Export Ignores Applied Filters and Scans Entire Table

[umar-zealtouch]

I am experiencing an issue with the export functionality where applied filters (from query string livewire component params or otherwise) are not respected during data export. While the page correctly shows filtered records, exporting those records results in the full dataset being scanned, causing performance issues.

✅ Expected Behavior:
When filters are applied (e.g., filtering transactions by user_id), the export should only include and query the filtered records. For example:

• Total records in the table: 1000
• Records after filtering by user: 100
• Export should only fetch and export those 100 filtered records

❌ Current Behavior:
Even when filters are applied, exporting records triggers a full table scan. It applies the record limit correctly (e.g., exports 100 rows), but the query does not include the filters, so it's essentially scanning all 1000 rows and then slicing the result. As a result we never get the actual results that were in the filtered table.

This results in extremely slow exports for large datasets, even though only a small portion of data is visible/filtered.

🧪 Reproduction Steps:

• Use a model like Transaction that has thousands of rows.
• Add a conditional filter in the datasource() method using when():

public function datasource(): Builder
{
    return Transaction::query()
        ->when(!empty($this->user_id), function ($q) {
            $q->where('transactions.user_id', $this->user_id);
        });
}

• Pass user_id via query string (or any filter condition).
• Table correctly shows only filtered results (e.g., 100 records).
• Click "Export All" – this triggers a full table scan and takes a long time and the exported results are not the ones visible in the filtered table.

[umar-zealtouch]

I believe this should be a top priority since the export feature currently fails to include the desired filtered results.

[h4or]

Had the same issue.. I fixed it by writing my own export which aswell, handles the filters.. I could also not find any fixes for the problem with the inbuilt export

[umar-zealtouch]

Give me your email and I will send you the credentials

[luanfreitasdev]

luanfreitas10@protonmail.com

[umar-zealtouch]

Credentials sent to your email. Please check. Thanks

[umar-zealtouch]

@luanfreitasdev Were you able to look into this? I am waiting for your much awaited update on this..

[luanfreitasdev]

Sorry for not getting back to you sooner, but I couldn't reproduce it based on your file because I need something simpler to run. Can you create a simple repository with a table that has this problem? powergrid-demo could be the basis

[umar-zealtouch]

[umar-zealtouch]

@luanfreitasdev Looking for a workable solution and your response is highly appreciable,

[umar-zealtouch]

@luanfreitasdev I am waiting for your kind response on this..

[luanfreitasdev]

All component properties are available in $parameters. Therefore, you should pass all filters by accessing $parameters['name'], $parameters['age'], etc.
Do using dd($parameters) to check

[umar-zealtouch]

@luanfreitasdev What is the right place to pass these properties?
I tried the way mentioned in https://livewire-powergrid.com/table-features/exporting-data.html#passing-attributes but that did not work.

[luanfreitasdev]

It's working for me