Monday, January 3, 2022
1 change · master
New functionality added to Odoo
Odoo can now sort records more flexibly when some values are empty, allowing those blank entries to appear last instead of first. This helps businesses present ranked lists, scores, and similar data in a more natural and useful order.
Original PR description
Description of the issue/feature this PR addresses: Allow more dynamic SQL searches on `_order` Current behavior before PR: You cannot order by `nulls last` since it is not required in the core from Odoo. Desired behavior after PR is merged: You can order by `nulls last` as it is supported. Example without `nulls last`: ``` name | score -------------------+---------------------- abc | def | 6.76 xxx | 5.8 ``` Example with `nulls last`: ``` name | score -------------------+---------------------- def | 6.76 xxx | 5.8 abc | ``` Fixes https://github.com/odoo/odoo/issues/51000 -- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr