Skip to Content
This question has been flagged
domainmany2onesalejoinodooV13
2 Respostes
3415 Vistes
Avatar
Arian Shariat

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
Descartar
Travis Waelbroeck
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.

Avatar
Arian Shariat
Autor 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
Descartar
Avatar
Thicham
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
Descartar
Related Posts Respostes Vistes Activitat
Domain with inherited field Solved
domain many2one
Avatar
1
d’oct. 22
4474
Error in Creating Dynamic Domain for many2one field from onchange method in OpernErp v7 ???
domain many2one
Avatar
Avatar
Avatar
8
de febr. 17
9060
Domain One2many filter
domain many2one
Avatar
0
de gen. 17
6364
[solved] domain restriction and clear the previously selected value of a many2one field Solved
domain many2one
Avatar
Avatar
2
de febr. 24
13306
Set dynamic domain on fields based on other fields value Solved
domain many2one edit
Avatar
Avatar
Avatar
Avatar
4
de maig 24
19360