Hi everyone,

I have a technical question about how Odoo handles indexes during search operations, and I’m hoping someone can clarify. Here’s the scenario:

• In the stock.move model:
  • There’s a date field that is indexed.
• In the stock.move.line model:
  • There’s a move_id field (Many2one relation to stock.move) that is indexed.
  • There’s a scheduled_date field that is a related field (related=move_id.date) and not stored in the database

My question is:

If I perform a search on the stock.move.line model using the scheduled_date field, will Odoo utilize the indexes on move_id and date, or will the search bypass these indexes due to the virtual nature of the scheduled_date field?

Thanks in advance for any insights!