CSV/Excel Export Action Error

The chunkById operation was aborted because the [controls.id] column is not present in the query result.
No description
6 Replies
Dennis Koch
Dennis Koch7mo ago
Seems like it's chunking by ID and your data doesn't have an ID?
Alnuaimi
Alnuaimi7mo ago
I have Id in my table
toeknee
toeknee7mo ago
if id fillable?
Sourabh
Sourabh6mo ago
@Dennis Koch I really need your help. while exporting the excel with queue it's not working . Please find screen shot . ExportAction::make()->tooltip('CSV Export (Unexported and Unredeemed)') ->exports([ ExcelExport::make() ->fromTable()->queue() ->except(['redeemed', 'exported']) ->withFilename('couponcodes' . time()) ->withWriterType(Excel::CSV) ->withoutHeadings() ->modifyQueryUsing(fn($query) => $query->where('exported', false)->where('redeemed', false)) ]) ->before(function (Actions\Action $action, CouponCode $couponCode) { $couponCodes = $couponCode->where('exported', false)->where('redeemed', false)->pluck('id')->toArray(); if (empty($couponCodes)) { Notification::make() ->info() ->title('Oops! There is no coupon codes available to export.') ->send(); $action->cancel(); } })
No description
No description
Dennis Koch
Dennis Koch6mo ago
Not sure why you post this here and tag me? The post is unrelated to your question, there are plugin channels for each plugin ( #pxlrbt-excel ) and you shouldn't tag people ( #✅┊rules )
Sourabh
Sourabh6mo ago
I am extremely sorry for this . I don't about it . I will re-post this question in the #pxlrbt-excel channels.