Skip to Content
This question has been flagged
odoo12.0
1 Respondre
2177 Vistes
Avatar
jenan soliman

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

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best 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

Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to write Record Rule with domain based on the company_dependent Fields Solved
odoo12.0
Avatar
Avatar
Avatar
3
d’oct. 23
8534
loan request
odoo12.0
Avatar
Avatar
1
de set. 23
3213
How to make pagination that has a table in qweb
odoo12.0
Avatar
Avatar
2
d’abr. 23
2690
Inherit Element form kanban View Solved
odoo12.0
Avatar
Avatar
1
de març 23
2105
Feedback activity notification
odoo12.0
Avatar
0
de març 23
1308