Sunday, April 16, 2023
1 change · master
Miscellaneous changes
There were a few issues: * we didn't always take the last statement as a reference: if we had two statement the same day, we needed to take the last one. Adding the `id` in the ORDER BY actually also improves the performances (4s to 2.5s on the test database for all journals) * If there is no statement, we didn't display the balance at all because `statement.first_line_index` is NULL, therefore the `>=` operator returned NULL and the condition was falsy [opw-3268956](https://www.odoo.com/we
Original PR description
There were a few issues: * we didn't always take the last statement as a reference: if we had two statement the same day, we needed to take the last one. Adding the `id` in the ORDER BY actually also improves the performances (4s to 2.5s on the test database for all journals) * If there is no statement, we didn't display the balance at all because `statement.first_line_index` is NULL, therefore the `>=` operator returned NULL and the condition was falsy [opw-3268956](https://www.odoo.com/web#id=3268956&model=project.task) [opw-3269493](https://www.odoo.com/web#id=3269493&model=project.task) [opw-3268950](https://www.odoo.com/web#id=3268950&model=project.task) [opw-3270450](https://www.odoo.com/web#id=3270450&model=project.task) [opw-3270143](https://www.odoo.com/web#id=3270143&model=project.task) and many more... Forward-Port-Of: odoo/odoo#118312