Odoo Help


4 Answers


| 6 4 11
Pondicherry, India

Passionate coder in Python/OpenERP. Knows Django/Flask MVC frameworks.


9/3/14, 4:37 AM

Hi, Operations on recordset are

record in recset1           # include
record not in recset1       # not include
recset1 + recset2           # extend
recset1 | recset2           # union
recset1 & recset2           # intersect
recset1 - recset2           # difference

1 Comment
Atte Isopuro
9/3/14, 4:55 AM

Thank you for the prompt answer. I was also wondering if there are list-like operations available for single recordsets, like recordset[3:7] to get records 3 through 7 from the recordset?


Akhil P Sivan

--Akhil P Sivan--

| 6 4 9
Kochi, India
--Akhil P Sivan--

Odoo Developer

email-id : akhilpsivan01@gmail.com

Akhil P Sivan
10/29/15, 11:36 PM


Other recordset operations:

1. sorted(): To sort a recordset

# sort records by name
recset.sorted(key=lambda r: r.name)

2. filtered(): To filter a recordset:

# only keep records whose company is the current user's
records.filtered(lambda r: r.company_id == user.company_id)

# only keep records whose partner is a company

3. mapped(): To map a recordset by applying the provided function to each record in the recordset and returns a recordset if the results are recordsets.

recordset.mapped(lambda record: record.amount + record.tax_amount)

# returns a list of name

# returns a recordset of partners

Osval Reyes
10/29/15, 7:35 PM

Is there anyway to apply a .search([]) call in a recordset?

1 Comment
Atte Isopuro
9/16/16, 6:03 AM

I'm not aware of being able to do this directly. What you need to do is explicitly narrow your domain to that recordset using the recordset's 'ids' attribute. So say you have a recordset partners, and you want to find out which of those partners are suppliers. Then you would do:

self.env['res.partner'].search([ ( 'id', 'in', partners.ids ), ( 'supplier', '=', True ) ])

Ask a Question
Keep Informed
1 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now