Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1055 Ansichten

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
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
0
Juli 22
40
1
März 21
10605
1
Mai 23
2278
2
Jan. 23
7338
1
Sept. 24
6942