Skip to Content
Menu
This question has been flagged
2 Replies
2600 Views

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 ???

Avatar
Discard
Unsubscribe 

On Wed, Feb 24, 2021 at 5:40 AM Cristina.J <mariemjallouli@gmail.com> wrote:

Une nouvelle question Odoov13 join two many2one fileds while setting query domain le Aide a été publiée. Cliquez ici pour accéder à la question :

Voir la question

Envoyé par Odoo S.A. utilisant Odoo.

Author Best Answer

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)

Avatar
Discard
Best Answer

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)

Avatar
Discard
Related Posts Replies Views Activity
1
Oct 22
2454
8
Feb 17
6978
0
Jan 17
4745
2
Feb 24
11079
4
May 24
15261