Deleting a child table row

[abrefael]

I have two child tables in on docType.
What I wish is to have a trigger that is activated when I want, so I have a check box. When the checkbox is ticked, it triggers my script.
What I want is the script to create a new line in the second child table with data from the first one (easy enough), and remove the row I just selected.
I don’t know how to delete the child table row. What function does this?
For the record: I can’t see an event for the “delete” button that becomes visable after selecting a row.
I do not want to use this button, but to be able to delete the row once the checkbox is active.
Anyone?
I tried doing this (in system console):

ff = frappe.db.sql("SELECT name FROM tablist_chld WHERE product='dsfgethdfymghm';")[0][0]
chld_doc = frappe.get_doc('list_chld', ff)
chld_doc.delete()

but the dsfgethdfymghm row is still there.

[Mohammadali]

Hi @abrefael

Use this code if you want to clear the child table. I hope it will help you

JS

frm.set_value('child_table', []);
frm.save()

Python

doc.child_table = []
doc.save()

Thank You!

[abrefael]

Thanks,

I don’t want to clear the child table, only to delete a specific row.

[Mohammadali]

Hi @abrefael
please read this post

How to delete a particular row from a child table?

Here is my shot at it. I strongly believe that the solution is to parse the array from the last to the first element. In this way, the array elements that get re-indexed will not affect the behavior: var tbl = doc.child_table || []; var i = tbl.length; while (i--) { if(tbl[i].field_name == '') { cur_frm.get_field("child_table").grid.grid_rows[i].remove(); } } cur_frm.refresh(); Give it a try

Thank You!

[abrefael]

Thank you!
Basically, what I was missing was:
frm.get_field("list_chld").grid.grid_rows[i].remove()