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

Publications associées	Réponses	Vues
We need cross model pivot tables pivot Reporting pivotreport	1 juil. 25	2289
Pivot report in sale order saleorder pivot pivotreport	2 janv. 20	5512
Pivot table call in Dashboards crm pivot dashboards pivotreport	0 mars 25	3403
override pivot view _render function in custom module odoo 11 odoo pivot odoo11 pivotreport	0 nov. 21	3661
Add custom button in pivot view odoo10 button pivot odoo10 pivotreport	0 juin 21	4754

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !