Filament•3mo ago

Exporter duplicate rows for relations

Hi, i'm working with the exporter. I need to to duplicate the record of the table exported, one for every relation of the record (it's a registration->members relation so 1 registration with N members, with a pivot table). It's there a way to duplicate the exported record in that way? Example (pseudo code):

registration_id, registration_transaction_id, member_firstname, member_lastname 
1, 123, john, doe
1, 123, jane, doe
2, 345, may, jane
2, 345, july, crockett
...
...
...

registration_id, registration_transaction_id, member_firstname, member_lastname 
1, 123, john, doe
1, 123, jane, doe
2, 345, may, jane
2, 345, july, crockett
...
...
...

can't find anything online, and LLM goes crazy very bad with that one... 😕 ty

Solution:

```php public static function modifyQuery(Builder $query): Builder { $query->join('registration_member', 'registrations.id', '=', 'registration_member.registration_id') ->join('members', 'registration_member.member_id', '=', 'members.id')...

Jump to solution

9 Replies

lbarOP•2mo ago

ok maybe solved with a raw query with join. But to me looks pretty strange that is not possible (or at least i haven't found a way) to do it in a clean eloquent way... nope. Still problem here. Basically i'm trying something very simple like:

ExportAction::make()
   ->exporter(RegistrationExporter::class)
   ->modifyQueryUsing(function (Builder $query, array $options) {
        $query->join('registration_member as rm', 'rm.registration_id', '=', 'registrations.id')
              ->select(
                       'registrations.id as registration_id',
                       'registrations.transaction_id as transaction_id',
                       'rm.id as member_id'
              );
              return $query;
        })

ExportAction::make()
   ->exporter(RegistrationExporter::class)
   ->modifyQueryUsing(function (Builder $query, array $options) {
        $query->join('registration_member as rm', 'rm.registration_id', '=', 'registrations.id')
              ->select(
                       'registrations.id as registration_id',
                       'registrations.transaction_id as transaction_id',
                       'rm.id as member_id'
              );
              return $query;
        })

and in the exporter i have:

class RegistrationExporter extends Exporter
{
    protected static ?string $model = Registration::class;
    ...
    public static function getColumns(): array
    {
        return [
            ExportColumn::make('registration_id'),
            ExportColumn::make('transaction_id'),
            ExportColumn::make('member_id')
        ];
    ...

class RegistrationExporter extends Exporter
{
    protected static ?string $model = Registration::class;
    ...
    public static function getColumns(): array
    {
        return [
            ExportColumn::make('registration_id'),
            ExportColumn::make('transaction_id'),
            ExportColumn::make('member_id')
        ];
    ...

Printing the rawquery above is working correctly and the number of rows exported is fine. But for some reason that I can't get, the exporter does not export anything:

Export completed
Your registration export has completed and 0 rows exported. 5 rows failed to export. <== 5 is  the correct number of row, but 0 exported.

Export completed
Your registration export has completed and 0 rows exported. 5 rows failed to export. <== 5 is  the correct number of row, but 0 exported.

There is some additional stuff to do in order to make the exporter able to retrieve the joined fields? Or there is better way to join fields on the query (eg using the eloquent relations. for example...) ty probably i'm nearer. With this exporter query:

    public static function modifyQuery(Builder $query): Builder
    {
        $query->with(['registrationMembers']);
        return $query;
    }

    public static function modifyQuery(Builder $query): Builder
    {
        $query->with(['registrationMembers']);
        return $query;
    }

i get the result required but condensed on the same row, like:

id,competition_name,transaction_id,firstname,lastname
5186,,reg_67d984fc555f8,"Nome11, Nome22, john","Cognome11, Cognome22, doe"
5185,,reg_67cad42db759b,John4,Doe4
5184,,reg_67c9bdcd9b7cf,Nome3,Cognome3

id,competition_name,transaction_id,firstname,lastname
5186,,reg_67d984fc555f8,"Nome11, Nome22, john","Cognome11, Cognome22, doe"
5185,,reg_67cad42db759b,John4,Doe4
5184,,reg_67c9bdcd9b7cf,Nome3,Cognome3

when what i like to have is:

id,competition_name,transaction_id,firstname,lastname
5186,,reg_67d984fc555f8,"Nome11","Cognome11"
5186,,reg_67d984fc555f8,"Nome22","Cognome22"
5186,,reg_67d984fc555f8,"john","doe"
5185,,reg_67cad42db759b,John4,Doe4
5184,,reg_67c9bdcd9b7cf,Nome3,Cognome3

id,competition_name,transaction_id,firstname,lastname
5186,,reg_67d984fc555f8,"Nome11","Cognome11"
5186,,reg_67d984fc555f8,"Nome22","Cognome22"
5186,,reg_67d984fc555f8,"john","doe"
5185,,reg_67cad42db759b,John4,Doe4
5184,,reg_67c9bdcd9b7cf,Nome3,Cognome3

any clue or hint? thank you

toeknee•2mo ago

try

public static function modifyQuery(Builder $query): Builder
{
    $query->join('registration_members', 'registrations.id', '=', 'registration_members.registration_id')
          ->select(
              'registrations.id',
              'registrations.competition_name',
              'registrations.transaction_id',
              'registration_members.firstname',
              'registration_members.lastname'
          );

    return $query;
}

public static function modifyQuery(Builder $query): Builder
{
    $query->join('registration_members', 'registrations.id', '=', 'registration_members.registration_id')
          ->select(
              'registrations.id',
              'registrations.competition_name',
              'registrations.transaction_id',
              'registration_members.firstname',
              'registration_members.lastname'
          );

    return $query;
}

lbarOP•2mo ago

thanks but already tried this. registration_member is a pivot table, like:

lbarOP•2mo ago

and also doing something like:

    public static function modifyQuery(Builder $query): Builder
    {
        $query->join('registration_member', 'registrations.id', '=', 'registration_member.registration_id')
            ->select(
                'registrations.id',
                'registrations.competition_name',
                'registrations.transaction_id',
                'registration_member.member_certificate_id',
                'registration_member.member_card_id',
                'registration_member.member_idcard_id',
            );

        return $query;
    }

    public static function modifyQuery(Builder $query): Builder
    {
        $query->join('registration_member', 'registrations.id', '=', 'registration_member.registration_id')
            ->select(
                'registrations.id',
                'registrations.competition_name',
                'registrations.transaction_id',
                'registration_member.member_certificate_id',
                'registration_member.member_card_id',
                'registration_member.member_idcard_id',
            );

        return $query;
    }

still the exported does not get the rows correctly

lbarOP•2mo ago

and this error happens also if I print the raw query, and it's correct...

Solution

toeknee•2mo ago

public static function modifyQuery(Builder $query): Builder
{
    $query->join('registration_member', 'registrations.id', '=', 'registration_member.registration_id')
          ->join('members', 'registration_member.member_id', '=', 'members.id')
          ->select(
              'registrations.id',
              'registrations.competition_name',
              'registrations.transaction_id',
              'members.firstname',
              'members.lastname'
          );

    return $query;
}

public static function modifyQuery(Builder $query): Builder
{
    $query->join('registration_member', 'registrations.id', '=', 'registration_member.registration_id')
          ->join('members', 'registration_member.member_id', '=', 'members.id')
          ->select(
              'registrations.id',
              'registrations.competition_name',
              'registrations.transaction_id',
              'members.firstname',
              'members.lastname'
          );

    return $query;
}

lbarOP•2mo ago

yes the query is still correct (also that one) but for some reason I still get 0 rows exported from the exported. It's possible that is due that exporter has: class RegistrationExporter extends Exporter { protected static ?string $model = Registration::class; and he can't read others fields from joined table? no ok now fixed, a syntax error on the last one that i have found now. But this is the only way to do that? There is no way to use the eloquent relations? Because on them I have already all the required relationship (thank you for the support man)

toeknee•2mo ago

Welcome dude

Gaming

Programming

Exporter duplicate rows for relations

Did you find this page helpful?