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	Replies	Views
We need cross model pivot tables pivot Reporting pivotreport	0 Jun 24	386
Pivot report in sale order saleorder pivot pivotreport	2 Jan 20	3913
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 Sep 23	1061
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 Nov 21	2099
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 Jun 21	2980

This question has been flagged

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