Core: Model relationships do not follow softdeletes on intersect tables

[mikehhhhhhh]

I was unsure whether this should go in lucid or here, so please forgive me if I got it wrong.

I have a belongsToMany that has an intersect table.

It associates a User as an admin of an Organisation through an intersect table "organisation_admins"

That intersect table has softdeletes enabled, but the relationship returns all results regardless of whether they have been deleted

return this.belongsToMany('App/Model/Organisation','organisation_admins','user_id','organisation_id')

It is easily fixed with the following, but I feel like this should be implicit in the behaviour of belongsToMany?

    return this.belongsToMany('App/Model/Organisation','organisation_admins','user_id','organisation_id').where('deleted_at',null)

[thetutlage]

Should be good with 4.0

[RomainLanz]

Closing since no answer from issue reporter.

[dustinboss]

HI @thetutlage - you said that this should be good to go with 4.0, but i don't see soft deletes in the docs for 4.0. Has it been removed?

[shinobiwarrior]

Hi, are there news about soft deletes?
@dusbuss could you find anything?

[dustinboss]

@shinobiwarrior - haven't found anything about it yet

[webdevian]

Still waiting for it, there’s an open issue on the Adonis lucid repo that has been assigned so any updates will be there

[webdevian]

https://github.com/adonisjs/adonis-lucid/issues/257

[shinobiwarrior]

Thanks to both of you, I'll subscribe to that issue

[lock[bot]]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.