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

Question

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

Kanak Infosystems LLP · Answer

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 [1] ,
order.time
'''

@api.mode

Related Posts	Odgovori	Prikazi
We need cross model pivot tables pivot Reporting pivotreport	1 jul. 25	2253
Pivot report in sale order saleorder pivot pivotreport	2 jan. 20	5482
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 mar. 25	3385
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 nov. 21	3630
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 jun. 21	4716

This question has been flagged

Enjoying the discussion? Don't just read, join in!