Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

How to get value from another model and use it in pivot table?

module models pivot pivotreport

1 الرد

5074 أدوات العرض

Ori J

Hello. I have 2 models, appointment.order and report.appointment.order. In appointment.order I have 1 field that I want to show or use in the pivot table (the model for the pivot table is report. appointment.order).

Here's my python code in appointment.order:

from odoo import api, fields, models, _

class AppointmentOrder(models.Model):
    _inherit = 'appointment.order'
    
    time= fields.Float('Time')

In the XML files, I use the float_time widget for the time field.

I need to use the time field in report. appointment.order so I can show the time field in pivot table, but I don't know how to do that since the model is different. Does anyone know how to do that?

Thank you.

Kanak Infosystems LLP

Hello @Ori J, You can try this code,

In report py file

# -- coding: utf-8 --

from odoo import models, fields, api

from functools import lru_cache

class ReportAppointmentOrder(models.Model):

_name = "report.appointment.order"

_description = "Appointment Analysis"

_auto = False

time= fields.Float('Time', readonly=True)

@property

def _table_query(self):

return '%s %s' % (self._select(), self._from())

@api.model

def _select(self):

return '''

SELECT

order.id,

order.time

'''

@api.model

def _from(self):

return '''

FROM appointment_order order

'''

In Report xml file,

report.appointment.order.pivot

report.appointment.order

Somehow, I am not able to add the complete code. Have a look at the screenshot:

https://prnt.sc/0C3AqTyCnYnd

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
We need cross model pivot tables pivot Reporting pivotreport	1 يوليو 25	2264
Pivot report in sale order saleorder pivot pivotreport	2 يناير 20	5485
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 مارس 25	3387
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 نوفمبر 21	3644
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 يونيو 21	4732

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!