sum Colum of based on id

Question

Hello
I want to get the amount for a specific employee, here's my function when I print the result I get all the sum of the records.

def  get_sum ( self , ):
for  rec  in  self :
rec ._cr.execute( "SELECT sum(loan_amount) from hr_loan GROUP BY employee_id" )
results = rec .env.cr.fetchall()
result = float ( '' .join( map ( str , results[ 0 ])))
print ( "summmmmmmmmmmmm" , result)
return result

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
To fetch the total loan_amount group by employees, you can use the following query:
SELECT SUM(loan_amount)
FROM hr_loan
GROUP BY employee_id;
This will display the results in the following format:
Sum
4687.50
23963.00
750.00
2145.00
3325.00
If you want to fetch the loan_amount for a specific employee, you can add the employee ID in the WHERE condition like this:
SELECT SUM(loan_amount)
FROM hr_loan
WHERE employee_id = 10;
This will display the result like 2145.00.
Regards

İlgili Gönderiler	Cevaplar	Görünümler
The Missing required fields in Odoo 19 test odoo12.0	0 May 26	9
Expected singleton: hr.emp.travel.location(62, 63) odoo12.0	2 Eki 25	3894
How to write Record Rule with domain based on the company_dependent Fields Çözüldü odoo12.0	3 Eki 23	13034
loan request odoo12.0	1 Eyl 23	5563
How to make pagination that has a table in qweb odoo12.0	2 Nis 23	4838

Bu soru işaretlendi

Tartışma hoşunuza mı gidiyor? Sadece okumakla kalmayın, katılın!