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
- Contabilità
- Magazzino
- PoS
- Project
- MRP
La domanda è stata contrassegnata
1
Rispondi
3926
Visualizzazioni
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
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
Data for relations table
Risolto
|
|
1
apr 24
|
2222 | |
|
1
ago 22
|
3000 | ||
|
0
mag 17
|
7652 | ||
|
1
mar 15
|
4070 | ||
|
2
mar 15
|
4609 |
