Odoo Studio: Filtering a field depending on its parent

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

Take the tour

3 Replies

8111 Views

I'm currently setting up odoo for our company. I'm working with odoo Online (v12) (using odoo Studio).

I created new model Estates (x_estate) that contains many2many field called x_partners (relation: res.partner).

In our workflow, we'd like to assign an estate to every Sale Order Line, so I added a new field "Estate" to the list view of the Sale Order Lines.

As a lot of estates have the same name, I'd like to filter the choices depending on the Customer that is selected in the Sales Order.

I tried to achieve this using domain and context but didn't come to the expected result.

Context: {"parent_partner_id":parent.partner_id}

Domain: [["x_partners","ilike","parent_partner_id"]]

I guess I lack some technical comprehension of how this works and I'll be happy for any help. Is it even possible to achieve this with odoo Studio?

Best Answer

If I understood the problem well, try it:
Domain: [('x_partners','=','parent.partner_id')]

try to add this in the XML: domain="[('x_partners','=',parent.partner_id)]"

Author

@Zbik

Thanks for your response. I just tried applying Domain: [('x_partners','=','parent.partner_id')]

There's no error but the estates dropdown in Sales Order Line doesn't show any values.

Sorry, my mistake. Remove quote characters in parent.partner_id. [('x_partners','=',parent.partner_id)]

Author

It seems that this is not possible in odoo Studio. When I try to save the domain, it says: "The domain you entered is not properly formed"..

Hi, I got the same problem with Studio. I don't know how to remove the quotes :-(

I also have this issue.

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
How to set up a dynamic date filter with studio ? filtering studio quickstart	5 Oct 24	9764
Filtering and selecting with Studio in Order Line ManyToone Field filtering studio filter_domain	1 May 21	4347
Smartbutton for showing offers which contains active product order context filtering	0 May 21	1512
Filter individuals based on parent company field domain filtering studio	3 Oct 18	2920
Odoo15 - How To Compare Filter - Purchase Order - Quantity Ordered >= Quantity Received? purchase_order filtering studio v15	0 Jan 23	1021