Skip to Content
Menú
This question has been flagged
1076 Vistes

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)

Avatar
Descartar
Related Posts Respostes Vistes Activitat
0
de jul. 22
40
1
de març 21
10638
1
de maig 23
2295
2
de gen. 23
7381
1
de set. 24
6988