How i retrieve data from total field and summation of total field value will show?
def get_data(self):
query = """select total(this is field name)from cashin_balance(database model name)"""
self.env.cr.execute(query)
query_result = self.env.cr.dictfetchall()
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Project
- MRP
Diese Frage wurde gekennzeichnet
1
Antworten
3924
Ansichten
I think you want to fetch the sum of the total field form the database table.
Try the following query:
SELECT SUM(total) FROM cashin_balance
Sir where i write query and what is the code to get data and how to view
.py file
from odoo import api, models, fields
class CashinBalance(models.Model):
_name = 'cashin.balance'
# _inherit = 'mail.thread'
_description = 'Cash-in Details'
a = fields.Integer('TK.1000')
b = fields.Integer('TK.500')
c = fields.Integer('TK.100')
d = fields.Integer('TK.50')
e = fields.Integer('TK.20')
f = fields.Integer('TK.10')
g = fields.Integer('TK.5')
h = fields.Integer('TK.2')
date = fields.Date()
total = fields.Integer(compute='total_cash', store=True)
# cash = fields.Integer(compute='_get_users', store=True)
@api.depends('a','b','c','d','e','f','g','h')
def total_cash(self):
for expense in self:
expense.total = expense.a * 1000 + expense.b*500 + expense.c*100 + expense.d*50 +expense.e*20 + expense.f*10 + expense.g*5 + expense.h*2
please give the code which will be right
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
Data for relations table
Gelöst
|
|
1
Apr. 24
|
2221 | |
|
1
Aug. 22
|
3000 | ||
|
0
Mai 17
|
7652 | ||
|
1
März 15
|
4070 | ||
|
2
März 15
|
4609 |
