lbar Comments - Answer Overflow

lbar

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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)

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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?

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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

16 replies

FFilament

•Created by lbar on 2/24/2025 in #❓┊help

Exporter duplicate rows for relations

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...

16 replies

FFilament