domains / families / software-engineering / odoo-orm-expert

odoo-orm-expert

authentic

Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.

When to use

• Writing `search()`, `browse()`, `create()`, `write()`, or `unlink()` calls.
• Building complex domain filters for views or server actions.
• Implementing computed, stored, and related fields.
• Debugging slow queries or optimizing bulk operations.

When not to use

• Does not cover **`cr.execute()` raw SQL** patterns in depth — use the Odoo performance tuner skill for SQL-level optimization.
• **Stored computed fields** can cause significant write overhead at scale; this skill does not cover partitioning strategies.
• Does not cover **transient models** (`models.TransientModel`) or wizard patterns.
• ORM behavior can differ slightly between Odoo SaaS and On-Premise due to config overrides.

Skill page

Source