Skip ke Konten
Pertanyaan ini telah diberikan tanda
dataretrive
1 Balas
3929 Tampilan
Avatar
Arjun Baidya 
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()
Avatar
Buang
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Jawaban Terbai

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


Avatar
Buang
Arjun Baidya
Penulis

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

Post Terkait Replies Tampilan Aktivitas
Data for relations table Diselesaikan
data
Avatar
Avatar
1
Apr 24
2222
Retrieve Existing Data from other model and Print it into the list view Diselesaikan
data
Avatar
Avatar
1
Agu 22
3000
Update data file
data
Avatar
0
Mei 17
7656
Move content of a field
data
Avatar
1
Mar 15
4073
How to manipulate data before its gets viewed?
data
Avatar
Avatar
Avatar
2
Mar 15
4611