read_group multiple fields

Question

Hello,

with this expression:
self.env['sale.order'].read_group([], fields=['partner_id','user_id'], groupby=['partner_id','user_id'])
how can i get the same result of SQL query:
SELECT partner_id,user_id
FROM sale_order
GROUP BY partner_id,user_id
In the first expression Odoo doens't group by "user_id" but only by "partner_id"

Odoo11 community

Vishnu Vanneri · Accepted Answer

hi,
Just noticed your case, Try below code
self.env['sale.order'].read_group([], fields=['partner_id','user_id'], groupby=['partner_id','user_id'], lazy = False )
By adding lazy = False will consider your user_id in group by

相關帖文	回覆	瀏覽次數
Calculated Measure in Pivot and Graph View 已解決 community odooV11	3 10月 23	21892
refresh screen save data automatically community	2 7月 24	2276
tax location community	2 5月 24	2387
can not do invoice in community version community	1 2月 24	1800
Access logs on Odoo Community 已解決 community	1 11月 22	5581

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！