Thursday, May 23, 2024
1 change · saas-17.1
Resolved issues and error corrections
Applying an analytic filter in the General Ledger no longer causes an error after lines are unfolded. This helps accounting users continue analysis without being interrupted by a system traceback.
Original PR description
Currently, applying an analytic filter on the general ledger results in a traceback. ### Steps to reproduce * Install `account_reports` * Open the General Ledger * Unfold all the lines * Attempt to apply an analytic filter You will encounter a traceback: `psycopg2.ProgrammingError: can't adapt type 'SQL'` ### Cause Commit odoo/odoo@467cabacc49893c433e69ca7a2cd65add068098b introduced new SQL queries using the `SQL()` wrapper. However, these `SQL()` wrapped queries are being mixed with regular string queries and end up being used as parameters for `cr.execute()`, which produces the error. opw-3910410