How to Implement filtered() with lambda, mapped in Odoo?
1. filtered_domain()
✅ What is it?
📌 Realistic Example
Suppose you want to process only confirmed sale orders (state = ‘sale’):
confirmed_orders = self.filtered_domain([(‘state’, ‘=’, ‘sale’)])
for order in confirmed_orders:
order.message_post(body=”Processed confirmed order.“)
✅ When to use?
- When filtering based on record field values using Odoo’s standard domain logic.
- Cleaner and more readable than Python-based filtering.
2. filtered() with lambda
✅ What is it?
✅ Syntax
Filter sale orders where total amount is greater than 1000:
high_value_orders = self.filtered(lambda order: order.amount_total > 1000)
for order in high_value_orders:
order.message_post(body=”High-value order processed.“)
- When filtering logic is too complex for a domain.
- Useful for conditions like: order.partner_id.is_company and order.amount_total > 1000
✅ What is it?
Filter sale orders where total amount is greater than 1000:
Get all customer names from a list of sale orders:
partner_names = self.mapped(‘partner_id.name’)
You can also chain fields:
emails = self.mapped(‘partner_id.email’)
- When filtering logic is too complex for a domain.
- Useful for conditions like: order.partner_id.is_company and order.amount_total > 1000
✅ Combined Example
class SaleOrder(models.Model):
_inherit = ‘sale.order’
def action_notify_high_value_customers(self):
high_value_orders = self.filtered(lambda o: o.amount_total > 1000)
confirmed_orders = high_value_orders.filtered_domain([(‘state’, ‘=’, ‘sale’)])
partner_emails = confirmed_orders.mapped(‘partner_id.email’)
for email in partner_emails:
# Imagine sending email (this is just a placeholder)
_logger.info(f“Notification sent to: {email}”)
✅ Summary Table
| Feature | Purpose | Example Use Case |
|---|---|---|
| filtered_domain() | Filter records using domain logic | state == ‘sale’ |
| filtered() | Filter using Python function/lambda | amount_total > 1000 |
| mapped() | Extract field values from records | Get all customer names or emails from orders |
