Error exporting data

[diegoba73]

When I want to export filtered data, it throws me the following error:

[luanfreitasdev]

This could happen because of the way the join was assembled.

https://livewire-powergrid.docsforge.com/main/datasource/#join-tables

[diegoba73]

I made the change and it works perfect, it is seen that this is the problem with respect to the id. What if making that change now changes the fields of the booleans and does not make them toggleable, which can be the problem with the latter. If I remove the "primaryKey" thing it works again. Very rare

[luanfreitasdev]

Did this work on version 1.5.1 or on the alpine3 branch? Can you explain better about the primaryKey?

[diegoba73]

The export function works when I add these 2 lines:

public string $primaryKey = 'muestras.id';
public string $sortField = 'muestras.id';

But the toggleable buttons disappear:

[luanfreitasdev]

This is because it is not yet safe to update with this type of primary key. I'll investigate

[luanfreitasdev]

Unfortunately for now this is not possible because it handles the column dynamically, for example: column 'id' = $row->{$id} = $row->id. I haven't seen an output so far to use with joins. Example: $row->{$id} = $row->dishes.id

[pauleniz]

Is it possible to export filtered data without checkboxes? maybe there could be export options: all / filtered / selected(checked) filtered export could take the same query but without pagination or is it possible to assign an array to a variable like $this->exportData= $data;