This update cleans up an automated test for the Helpdesk live chat chatbot ticket creation flow. It helps keep quality checks easier to maintain, reducing the risk of future regressions without changing customer-facing behavior.

Enterprise counter-part.

task-4354325

https://github.com/odoo/odoo/pull/191076

This update improves how Odoo retrieves multiple internal references, reducing unnecessary database queries in accounting, payroll, helpdesk, delivery, field service, localization, and marketing areas. It also standardizes how missing references are handled, making the system more consistent and less prone to hidden errors.

The update removes a duplicated company-switching flag from the user session and relies on the existing company service instead. This reduces duplicated data and helps keep company access behavior consistent without changing the visible workflow for users.

This commit removes the display_switch_company_menu from the session, and uses the company service. Note that, the company service already has the information about the allowed companies.

part-of task-id 2224776

Spreadsheet autocomplete suggestions now show the pivot or list name alongside its ID before selection. This makes it easier for users to identify the correct spreadsheet data source and reduces confusion when multiple pivots or lists exist.

Unless the auto complete suggestion is selected, it only shows the id of the pivot/list and not the name. This commit changes that to always show the name of the pivot/list is addition to its id.

Task: [3953742](https://www.odoo.com/web#id=3953742&cids=1&menu_id=4720&action=333&active_id=2328&model=project.task&view_type=form)

This update strengthens automated testing around helpdesk, timesheet tracking, and live chat support flows. It helps reduce the risk of regressions in customer support and time logging features without introducing direct user-facing changes.

_*=helpdesk,website_helpdesk_livechat

task-4354287

Website routes that only read information now use read-only database resources instead of the main write database. This helps improve performance and scalability for common website traffic without changing what users see or do.

Since [1], the readonly parameter was added to ensure that these endpoints open a cursor on the read-only replica instead of the primary read/write database, enhancing performance and scalability for read-intensive operations.

This commit adds 'readonly=True' to routes handling non-modifying requests.

task-4357885

[1] https://github.com/odoo/odoo/commit/584a172274caefb23e5d91b609fc893160535416