Daily updates from Odoo
Tuesday, February 13, 2024
5 changes
1 change
Enhancements to existing features
Helpdesk ticket rating requests now send different messages depending on the recipient. Customers receive the rating request, while followers are only notified that the request was sent, reducing confusion and keeping internal or copied recipients better informed.
Original PR description
**With this PR**, followers and customers will get different ticket rating mail, followers will get only such information in mail that a ticket rating request has been sent to the customer. Task-2896614
4 changes
Enhancements to existing features
The Gantt view progress bars now display time durations more accurately and clearly. Previously, partial hours were rounded (showing '4h' instead of '4h30'), and the format included spaces ('4 h / 38 h'). This update shows exact durations and uses a cleaner format ('4h30 / 38h'), making it easier for users to understand task progress and time allocations at a glance.
Original PR description
* = hr_attendance_gantt, planning, mrp_workorder, project_enterprise, web_gantt backport of this PR : https://github.com/odoo/enterprise/commit/46a85677e6d5dad434271280a5afd97d0b2034c8 In this commit, we enhanced the Gantt view progress bar by modifying the display format. Previously, when the hours were not rounded, it would show as '4h' instead of '4h30'. We have now updated it to accurately represent the exact duration. Additionally, we changed the format from '4 h / 38 h' to '4h / 38h' for improved clarity. task: 3695852
This update improves the performance of account report queries by simplifying how the system retrieves related record IDs. Previously, the system was using inefficient database queries to fetch IDs from related tables. Now it retrieves them directly from the main table when safe to do so, resulting in faster report generation and reduced database load.
Original PR description
## Description
Domains of the form
```python
[('stored_Many2X.id', '=/!=/in/not in', list_of_ids)]
```
will force the ORM to generate a sub-`SELECT` (or `LEFT JOIN` in case of `auto_join=True`), which is inefficient, as the `id` can be retrieved directly from the current `model` table, instead of going to fetch it from the `PKey` of the `comodel` table.
There is just one *important* detail - in the sub-select, the `ir.rule` of the `comodel` is applied, which is not the case when directly referencing the `field` from the `model`. So in some cases using an explicit `.id` would be a wanted, if the intention was to apply the `ir.rule`.
## Fix
Remove the `.id` from left leafs of domains that if the field is stored, and the `comodel` doesn't have `ir.rule` associated with it, or the `ir.rule` application is redundant/not needed.
task-3735923
---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-prThis update improves the performance of price calculations in the product module by eliminating unnecessary database searches when no pricelist is being used. The change also ensures that internal system settings used during price lookups don't inadvertently affect other parts of the system, making the pricing logic more reliable and efficient.
Original PR description
Rules always have a pricelist, so we can avoid an useless database query when we are computing the prices without any pricelist. Also makes sure that the modified context used for the pricelist items search is not propagated by enforcing the same context in the returned rules. --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
The project task list view now loads significantly faster when displaying large lists of tasks. Previously, the system was recalculating which tasks were selected for every single cell in the table, causing slowdowns of about 1 second for just 80 records. This fix calculates the selection once for the entire table, dramatically improving performance.
Original PR description
Before this commit, the project task list view computed the list of selected records once for each cell, when rendering the list. As a consequence, this slowed down a lot the rendering on large tables (~1s for 80 records). With this commit, we compute the selection only once to render the whole table. Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr