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
- Kirjanpito
- Varastointi
- PoS
- Projekti
- MRP
Tämä kysymys on merkitty
1
Vastaa
4558
Näkymät
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
Nautitko keskustelusta? Älä vain lue, vaan osallistu!
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
Data for relations table
Ratkaistu
|
|
1
huhtik. 24
|
3132 | |
|
1
elok. 22
|
3622 | ||
|
0
toukok. 17
|
8451 | ||
|
1
maalisk. 15
|
4795 | ||
|
2
maalisk. 15
|
5403 |
