Odoo Changelog — 2024-05-23

Thursday, May 23, 2024

1 change

Refactoring(1)

Code cleanup and technical improvements

[REF] account: bye bye _query_get

Enterprisemasteraccount_assetaccount_disallowed_expenses_fleetaccount_intrastataccount_reportsaccount_reports_cash_basisaccount_saftl10n_ar_reportsl10n_au_reports

This update modernizes internal accounting report query handling by replacing older query-building logic with a newer, safer SQL object approach. It should not change day-to-day user workflows, but it improves maintainability and consistency across accounting, tax, asset, and localization reports.

Original PR description

Gist: 
- Rename  `_get_table_expression` to `_get_sql_table_expression`
This clarifies that the function returns an SQL expression
and not a `account.report.expression`.
- Remove `_query_get`: use `_get_sql_table_expression` instead.
This makes use of the new `odoo.tools.SQL` object.
- Some related functions / queries were adapted to use the new SQL object too:
I.e. `_get_query_tax_details` and `_get_query_currency_table` (see related community PR)

community PR: https://github.com/odoo/odoo/pull/158880

task-3791228

#accounting#reporting#technical-cleanup#sql