How do you make something like this:
qty_prod_orders = frappe.db.sql('select sum(qty), parent, sales_order, IFNULL(fg_warehouse, "None"), IFNULL(wip_warehouse, "None") from
tabProduction Order where docstatus = 1 group by sales_order, production_item')
into using frappe.db.get_values
? On that note is there any advantages of converting a frappe.db.sql
to frappe.db.get_values
?