Budibase DB: Delete rows in connected table

[matclou]

Dear all,

in budibase I have two datatables, "personen" and "kontaktdaten" (translation "persons" and "contactdata") which have a "one-to-many" relationship one person can have multiple contact data.

Now I am trying to figure out a way to delete all rows corresponding roles in "contactdata" if a row in "persons" got deleted. In a way this problem is identifical to the problem described by harmkroog in May 2023: #10461

However I tried to realise the solution of @andz-bb provided there and did not proceed: #10461 (comment)

I did the following:

1. I created a column in "personen" called "alle_kontaktdaten" which included the row ids of all contactdata related to this person:
   ["ro_ta_66ce6264fa784061b54df3ac5d07c456_47477cff14c9467eb7247aaf3f2b4c4a","ro_ta_66ce6264fa784061b54df3ac5d07c456_bbd0aa53f43d4e41b8acf17cdd398d06","ro_ta_66ce6264fa784061b54df3ac5d07c456_bca7a7156dd24f328c14f8f35a6754bd"] The JavaScript function for this was: return $("kontaktdaten") ? $("kontaktdaten").map(x => x._id) : ""``

2. I created an automation as follows:
   

However, if I know delete a person, the contact data rows connected to this person remain.

i have tried it now on a published app and I get the following output with a person with two contact data points:

{

    "success": true,
    "items": [
        {
            "success": false,
            "response": "Error: CouchDB error: missing" 
        },
        {
            "success": false,
            "response": "Error: CouchDB error: missing" 
        } 
    ],
    "iterations": 2 

}

[matclou]

I found a solution to this myself:

The javascript codefor the alle_kontaktdaten should be separated by commas and not by this array structure with [, " and ] - so I used this code...

return $("kontaktdaten") ? $("kontaktdaten").map(x => x._id).join(",") : "";

.. and it worked!