hello, please help me,
The code below does not give its childs.
query = ("""
SELECT
ROW_NUMBER() OVER (ORDER BY mw.id)as id,
mp.customer_code as partner_code,
mp.name as ordername,
mp.origin as origin,
mwc.name as workcenter,
mp.product_qty_with_tolerance
from
sale_order AS so
INNER JOIN mrp_production AS mp ON so.name = mp.origin
LEFT JOIN mrp_workorder AS mw ON mw.production_id = mp.id
LEFT JOIN mrp_workcenter AS mwc ON mw.workcenter_id = mwc.id
where so.state != 'cancel' and so.partner_id = %d """% docs.partner_id[0].id)