How should I define the exportAction exporter class in order to export hasMany relation?

Use case: - I have a Product model, product has many prices.

    public function prices(): HasMany
    {
        return $this->hasMany(ProductPrice::class, 'product_id');
    }

    public function prices(): HasMany
    {
        return $this->hasMany(ProductPrice::class, 'product_id');
    }

3 Replies

awcodes•2mo ago

There’s no good way to dynamically create columns in a csv since you have no way of knowing the number of columns needed. Also makes importing more difficult too. I would recommend exporting the relationship in one column as a json or array string.

Roland BarkócziOP•2mo ago

Hello awcodes, thanks, finally I imploded the prices into one field separated by a pipe, and import back this way. The main problem here, that the getColumns function is static, and it's content can't be change based on options.

awcodes•2mo ago

You just need to make a custom exporter. https://filamentphp.com/docs/3.x/actions/prebuilt-actions/export

Export action - Actions - Filament

Gaming

Programming

How should I define the exportAction exporter class in order to export hasMany relation?