Skip to Content
This question has been flagged
dataretrive
1 Reply
2950 Views
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
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

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
Discard
Arjun Baidya
Author

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

Related Posts Replies Views Activity
Data for relations table Solved
data
Avatar
Avatar
1
Apr 24
924
Retrieve Existing Data from other model and Print it into the list view Solved
data
Avatar
Avatar
1
Aug 22
1695
Update data file
data
Avatar
0
May 17
6335
Move content of a field
data
Avatar
1
Mar 15
3096
How to manipulate data before its gets viewed?
data
Avatar
Avatar
Avatar
2
Mar 15
3383