Hi! If multiple tables are created and referenced, by deleting an entry in the parent table, shouldnโt the child-tablesโ relevent referred details get deleted automatically? In my app, this doesnโt happen and the child-tables retain data pertaining to the parent tableโs entry (all tables have UniqueIDs and referenced accordingly)
Do you mean you would like to automatically delete child records when a referenced parent record is deleted?
If so,
could you please explore
the setting
โIsAPartOfโ
option to โTrueโ in referenced column in child table?
plus.google.com - Cascading deletes : IsAPartOf references We recently introduced the concept โฆ
@Suvrutt_Gurjar Hi, thanks, I donโt know why but all of a sudden app didnโt delete the child tableโs rows, but now it works again. Yes, Iโve made the โIsAPartOfโ option โTrueโ already, I guess thatโs what makes a child tableโs Referenced Virtual Column appear at the end of the parent table in the first place isnโt it? Anyhow, it works now. Thank you for the help!
Hi @Malaka_Jayawardene, we currently do not support โcascading deleteโ of children records. It is something that is on the todo list.
@praveen You mean to say that if I delete a parent record, child records will persist without getting deleted? Because shortly after I made this post here, I checked back by making two more records and deleted the parent records, first by selecting it from โAllโ (table) view, and the second record by going in to the parent record and selecting the delete option there. Both times, both parent and child records did get removed (which is what I wanted to happen). I do not know why it didnโt work before (which is why I made the post here), but then now it works. What do you mean by โcascading deleteโ?
Hi @praveen, Thank you for guidance and clarification. Even when I tested, the children records got deleted when parent record was deleted. But there must be some
related aspect that we missed.
Will request your further guidance.
It looks like I misspoke :]
I checked with others on the team. It does look like we delete the child records when the parent is deleted.
This happens in our backend when a sync happens (rather than instantly in the app itself).
Hi @praveen , thank you for your update.
Thank you Praveen! Thanks Suvrutt!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |