Select a MultiTable Select with DB doesn't Work

Frappe Cloud
, ,
1

Hi,

I am using FrappeCloud.

I have a MultiTable Select field in my CRM form. When I try to fetch it in a server script, it fails.

fields = ["first_name", "last_name", "email", "mobile_no", "custom_kids_list"]
    frappe.response["message"] = frappe.db.get_value('CRM Lead', lead_id, fields,  as_dict=1)

Error:

500 - "{\"exception\":\"pymysql.err.OperationalError: (1054, \\\"Unknown column 'custom_kids_list' in 'SELECT'\\\")\

CRM Fields:

image

and the CRM Lead Kids List is a child table with this field:

image
image1633×195 14.1 KB

Lastly, the CRM Lead Kids is a regular DocType with these fields:

image
image1608×461 39 KB

Is there a way to get the list of kids from CRM lead DocType in the server script?

Best