Passing Query Builder instance into Excel class

[ManojKiranA]

Lets say that i have already build a query something like this.

$filteredUser = User::query()
->createdWithinDays(10)
->filters([
//filtered records using external package
])
->doMoreStuff()

Now my question is is there any way to pass the instance of Illuminate\Database\Eloquent\Builder or Illuminate\Database\Schema\Builder into excel class and do the excel export.

I already read about exports/from-query But it doesn't allow me to pass the actual query builder instance.

[patrickbrouwers]

As long as you don't use queuing, you can pass the query builder instance via the constructor of the excel class.

Or just make a new query class that you use in both places.

[ManojKiranA]

can you provide me an example or something

[patrickbrouwers]

new YourExport($filteredUsers)

[ManojKiranA]

thanks its works fine.

[albertoelias123]

@patrickbrouwers
I am trying to do the same, but I'm working with a massive amount of data (around 40k records). When trying to use the new YourExport($filteredUsers)->queue('users.csv') method, I encounter a runtime error, essentially saying that a closure cannot be serialized.

Do you happen to know how I could use a Builder instance with multiple filters and use fromQuery so that it runs in chunks?

[patrickbrouwers]

Don't pass the query builder itself through the constructor, but pass paramaters and build the query in query()