Skip to Content
This question has been flagged
odoo12.0
1 Reply
1525 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
How to write Record Rule with domain based on the company_dependent Fields Solved
odoo12.0
Avatar
Avatar
Avatar
3
Oct 23
7139
loan request
odoo12.0
Avatar
Avatar
1
Sep 23
2482
How to make pagination that has a table in qweb
odoo12.0
Avatar
Avatar
2
Apr 23
1912
Inherit Element form kanban View Solved
odoo12.0
Avatar
Avatar
1
Mar 23
1499
Feedback activity notification
odoo12.0
Avatar
0
Mar 23
913