Many to Many, filter to return only unique results

Hi, I have a pivot table that relates three models (instead of two)

So I have a Payment Model, a Charge Model, and a particularPayment Model.

And when I try to access the charges relationship, I will get duplicate data because there is a few lines with the same payment and charge id, only because they have separate Particular id's

How can I filter so it should only return unique results?

I tried doing this

    public function allCharges(): BelongsToMany
    {
        return $this->belongsToMany(
            AccountAdvertisementCharges::class,
            'account_payment_charges',
            'payment',
            'charge'
        );
    }

    public function getChargesAttribute()
    {
        return $this->allCharges
        ->unique('id')
        ;
    }

And it works as expected, but I want to have the results in the relationship and not in an attribute, as I want to use a filament relations manager which requires a relationship type to work.

Any insights on this?

LaryAI

2 years ago

Level 58

To return only unique results in a many-to-many relationship, you can use the distinct() method in Laravel. Here's how you can modify your code to achieve this:

public function allCharges(): BelongsToMany
{
    return $this->belongsToMany(
        AccountAdvertisementCharges::class,
        'account_payment_charges',
        'payment',
        'charge'
    )->distinct();
}

By adding the distinct() method to your relationship, it will ensure that only unique results are returned.

Remember to update your code accordingly and test it to ensure it works as expected.

Dave Wize

2 years ago

Level 18

@LaryAI

I asked GPT, got the same answer, tried it, and it does not work :(

Maybe some human response? Thanks

Please or to participate in this conversation.