跳至內容
選單
此問題已被標幟
1042 瀏覽次數

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)

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
0
7月 22
40
1
3月 21
10591
1
5月 23
2264
2
1月 23
7334
1
9月 24
6935