for example; I want to do a search on sale.order model and get the records that the partner_id object's parent_id is equal to '1'. How can I achieve?
self.env['sale.order].search(['???' , '=', '1']) can ??? be partner_id.parent_id ???
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
for example; I want to do a search on sale.order model and get the records that the partner_id object's parent_id is equal to '1'. How can I achieve?
self.env['sale.order].search(['???' , '=', '1']) can ??? be partner_id.parent_id ???
self.env['sale.order].search(['partner_id.parent_id' , '=', '1']) works as well as sale_orders = self.env['sale.order].search([]).filtered(lambda so: so.partner_id.parent_id == 1)
You can not achieve this using domain on search method. However, you can grab all sale orders and then filter them like this:
sale_orders = self.env['sale.order].search([]).filtered(lambda so: so.partner_id.parent_id == 1)
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
Domain with inherited field
Solved
|
|
1
Oct 22
|
2454 | |
|
8
Feb 17
|
6978 | ||
|
0
Jan 17
|
4745 | ||
|
2
Feb 24
|
11079 | ||
|
4
May 24
|
15261 |