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	21844
refresh screen save data automatically community	2 7月 24	2219
tax location community	2 5月 24	2094
can not do invoice in community version community	1 2月 24	1755
Access logs on Odoo Community 已解决 community	1 11月 22	5522

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！