We need cross model pivot tables

Question

We really need to be able to do cross model pivots. The ability to pull referenced fields from another model. Right now it seems pivot tables cannot access related fields in other models. This is a HUGE limitation and makes adding custom fields much less useful.
The export tool can access data cross model just fine...

Example:
Sales Order pivot table that shows QTY of items sold by month, by *x_studio_PRODUCT_CUSTOM*, by part number
*x_studio_PRODUCT_CUSTOM*
Part # QTY Sold
May Transmitter
A123

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

To enable cross-model pivot reporting in Odoo:

Inherit the existing pivot view and add stored related fields (store=True); refer this blog: https://www.cybrosys.com/blog/how-to-inherit-an-existing-pivot-view-report-in-odoo-18 [1]

Create a custom pivot report using an SQL view that joins multiple models; refer this blog: https://www.cybrosys.com/blog/how-to-create-pivot-report-using-query-in-odoo-18 [2]

This
effectively overcomes the limitation of Odoo core pivot views not
supporting rela

	x_studio_PRODUCT_CUSTOM	Part #	QTY Sold
May	Transmitter
		A123	33
		B123	785
	Lock
		G456	12
		E456	58
June	Transmitter
		A123	12
		B123	434
	Lock
		G456	34
		E456	464

相關帖文	回覆	瀏覽次數
Pivot report in sale order saleorder pivot pivotreport	2 1月 20	4916
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 3月 25	2534
How to get value from another model and use it in pivot table? module models pivot pivotreport	1 11月 22	4313
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 11月 21	3086
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 6月 21	4094

此問題已被標幟

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