I'm wondering how to use cr.execute and fetch...? I'm getting only values. Is there a way to get values in a dict?
self.env.cr.execute("SELECT SUM(p.value) AS value, SUM(p.payed) AS payed.....") # few inner joins and where conditions
result = self.env.cr.fetchall()
In the result I get (4.66, 2.0), but is there a way to get {'value': 4.66, 'payed': 2.0}?
On only 2 returned values it isn't such a problem but for 5 or more it becomes inconvenient.
(sorry I don't know how to get out of code mode)
See: https://www.youtube.com/watch?v=IK3OiceJKds