Remove item from child table Python

aldoblack · January 22, 2018, 6:33pm

I want to remove an item from child table. I have searched but I can not find any sample code.

saurabh-bhosale · January 22, 2018, 8:53pm

To delete a line item from a childtable in Python you will have to use frappe.delete_doc(“Doctype”,“Docname”). In this case, it will be the child Doctype and its name(line-item that you wish to delete) and a refresh_field(‘childtables_name’) would do wonders in case if it is done using a frappe.call from js

netchampfaris · January 23, 2018, 5:36am

Use

doc.remove(row)

Example usage:

github.com

frappe/frappe/blob/develop/frappe/core/doctype/user/user.py#L700


      
          	        logout_all_sessions (int, optional): If set to 1, all other sessions will be logged out. Defaults to 0.
          	        key (str, optional): Password reset key. Defaults to None.
          	        old_password (str, optional): Old password. Defaults to None.
          	"""
          
          
	result = test_password_strength(new_password)
          	feedback = result.get("feedback", None)
          
          
	if feedback and not feedback.get("password_policy_validation_passed", False):
          		handle_password_test_fail(feedback)
          
          
	res = _get_user_for_update_password(key, old_password)
          	if res.get("message"):
          		frappe.local.response.http_status_code = 410
          		return res["message"]
          	else:
          		user = res["user"]
          
          
	logout_all_sessions = cint(logout_all_sessions) or frappe.db.get_single_value(
          		"System Settings", "logout_on_password_reset"
          	)

tmatteson · April 3, 2018, 5:09pm

What is the expected input for row? A document or an index?

netchampfaris · April 4, 2018, 1:05pm

It should be the child doc

Lewinta · August 11, 2020, 5:24am

Your response works fine removing the child, however that method doesn’t rearrange (update idx) on the table causing this (see picture)

which method can i call to fix the idxs as well.

Thanks

tmatteson · September 9, 2020, 9:58pm

You’ll need to set the idx column explicitly.

for row, index in enumerate(doc.items):
    row.idx = index