odoo-orm-expert

name	odoo-orm-expert
description	Master Odoo ORM patterns: search, browse, create, write, domain filters, computed fields, and performance-safe query techniques.
type	skill
created	2026-02-27T00:00:00.000Z
domain	software-development
category	database
risk	safe
source	self
tags	["skill","software-development","database","odoo","orm"]

Odoo ORM Expert

Overview

This skill teaches you Odoo's Object Relational Mapper (ORM) in depth. It covers reading/writing records, building domain filters, working with relational fields, and avoiding common performance pitfalls like N+1 queries.

When to Use This Skill

• 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.

How It Works

1. Activate: Mention @odoo-orm-expert and describe what data operation you need.
2. Get Code: Receive correct, idiomatic Odoo ORM code with explanations.
3. Optimize: Ask for performance review on existing ORM code.

Examples

Example 1: Search with Domain Filters

# Find all confirmed sale orders for a specific customer, created this year
import datetime

start_of_year = datetime.date.today().replace(month=1, day=1).strftime('%Y-%m-%d')

orders = self.env['sale.order'].search([
    ('partner_id', '=', partner_id),
    ('state', '=', 'sale'),
    ('date_order', '>=', start_of_year),
], order='date_order desc', limit=50)

# Note: pass dates as 'YYYY-MM-DD' strings in domains,
# NOT as fields.Date objects — the ORM serializes them correctly.

Example 2: Computed Field

total_order_count = fields.Integer(
    string='Total Orders',
    compute='_compute_total_order_count',
    store=True
)

@api.depends()
 ():
     record  :
        record.total_order_count = (record.sale_order_ids)