How to get belongsToMany Relationship without soft deleted records

[nmp4817]

we have a DB relationship as follows:

Table A
Table B
Table C

where C is the relationship table between A and B

we wrote the relationship as follows inside Model A:
$this->belongsToMany(B::class, 'table_c', 'a_id', 'b_id')

the equivalent SQL of which is

select b.*, c.a_id as pivot_a_id, c.b_id as pivot_b_id 
from b
inner join c on c.b_id = b.id
where c.a_id=x and b.deleted = 0 

As you can see query do not include soft delete condition in inner join! How to achieve this?

• deleted is a soft delete column.

[dennisprudlo]

You can filter your relationship by its pivot table https://laravel.com/docs/8.x/eloquent-relationships#filtering-queries-via-intermediate-table-columns

[nmp4817]

Hi thanks for replying
can you please give me a statement, how would it look like for the above example?

[dennisprudlo]

Can't you use ->wherePivotNull('deleted_at') or however your soft delete column is called?

[nmp4817]

Ohh I see
I already did this
$this->belongsToMany(B::class, 'table_c', 'a_id', 'b_id')->where('b.deleted', '=', 0);

Thanks for introducing me to new where method