Delete Joined data - What Gets Deleted

[leeburstroghm]

In the list join parameters there is a "Delete Joined Data" setting.

When this is selected.. What joined data gets deleted..?
Is it the entry in the normalization table "a_to_b"? or in the far table "B"?

A | A_to_B | B

where A_to_B is the normalization table containing the many-to-many relationships.. if I delete record from A. then all associations in the A_to_B table where A.id is present, should be deleted.. is this as far as it goes, or does it fall over into B and delete those records also?

 

[rob]

Hi

What happens internally is that we load up all joins related to the main list (A) which are not element joins (e.g. joins created by database join elements)
Then we loop over the records being delete in list A and delete the records in the joined lists whose foreign key matches that of table A's primary key.

So if in your you have table A joined to A_B and you've set A_B.b_id to be a database join element, then deleting a record in A will delete the reference in A_B but leave B records in place.

 

[leeburstroghm]

yes, just making sure I had my head wrapped around it correctly.. thanks