Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi all,
I am trying to do a report.
The report fields are as follows :
CRM(partner name) - CRM (stage name) - INVOICES (invoice total sum )
The problem is that I cannot link CRM table (crm.lead) with table (crm.stage) directly and then to invoices related to the (partner_id)
Anyone knows how to solve this ?
Thanks
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
query = """
select * from table_1 t1, table_2 t2
where t1.field_1=t2.some_field
"""
self.env.cr.execute(query)
data = self.env.cr.fetchall()
in data you have all of your column which you need in the report.