[CLOSED] Relationship, can't delete related document even if on deleting: set null

I'm not sure if this suppose to happen, but if you select set null on document deletion it's not the behaviour I expected. I would expect when deleting the related document the attribute of the current document will be set null, but it prevent the deletion of the related document, and when you delete the current document it basically does nothing. I'm talking about one way relationship btw. I have a user collection, and a stats collection. There is a relationship in user, which point to stats as one to one one way relation. I want to be able to freely delete the documents in stats collection and it will automatically set null on the user collection's relationship attribute.

TL;DR

The user is experiencing issues with deleting related documents in a one-way relationship. They expected that when deleting a related document, the attribute in the current document would be set to null, but instead, the deletion is prevented. The user has tried removing the child element before the parent and has not had success. They do not want to manually loop through all documents to remove the relationship. Currently, there is no solution provided in the support thread.

It doesn't matter that much, but it's just unclear

I don't want to loop through all documents in user collection and remove the relationship for stats, that will just not be ideal

version 1.3.7

@joeyouss would you please troubleshoot this and try to reproduce the problem?

Any follow up?

Since it's the weekend, people aren't around. You'll have to wait until maybe Monday

Alright, now it is

Any progress?

@joeyouss would you please troubleshoot this and try to reproduce the problem?

@Bill.IHCha Have you tried removing the parent document first? I'm working with relationship too and sometimes I get an error when I first remove the child element instead of the parent

I have to remove the parent to be able to delete the child, which I don't want. I want to be able to delete the child and parent attribute auto set null

Thanks for the ping, missed the first one, looking into it

@Bill.IHCha this is what I did:

Made 2 collections one and two
one has a relationship attribute with two (one to one and set NULL selected on deletion
made documents in both collections
deleted the document in two

The result for me is: in one, two shows as n/a since it is deleted

I was able to delete it successfully though

Can you confirm once the reproduction steps are okay? Because, it could be possible there are other attributes present in your collection and not in mine that are giving different answers

Adding a related issue here https://github.com/appwrite/appwrite/issues/5558 (the error is different)

I'll try again once I get on. And I'll reply ping the message

sure, I'll be waiting

Sorry for the late reply, but when I tested it in version 1.3.8 everything seems fine for now. I'll be reopening the issue once something occurs.

thank you

[CLOSED] Relationship, can't delete related document even if on deleting: set null

Reply to this thread by joining our Discord

Reply on Discord