Hi! I have a category model, and a subcategory model. Subcategories have a single parent category ( x_parent_category_id ), and categories can have many child subcategories. Companies Small Medium-sized Large Associations Regular non-profit NGOs Fund Investment fund Pension … I have two many-to-one relationships on my customers to know their category ( x_category_id ) and their subcategory ( x_subcategory_id ) . I'd like to be able to set a domain on the x_subcategory_id relationship

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

Odoo Online: using field in domain

domain many2one field odooonline v18

2 Odpowiedzi

1834 Widoki

kll

Hi!

I have a category model, and a subcategory model. Subcategories have a single parent category (x_parent_category_id), and categories can have many child subcategories.

Companies
- Small
- Medium-sized
- Large
Associations
- Regular non-profit
- NGOs
Fund
- Investment fund
- Pension
…

I have two many-to-one relationships on my customers to know their category (x_category_id) and their subcategory (x_subcategory_id) .

I'd like to be able to set a domain on the x_subcategory_idrelationship so that subcategories are always a child of the parent category.

So, I have trouble using a domain like [('x_parent_category_id', '=', x_category_id)].

It seems both Odoo Studio and the debug mode forms hate x_category_id as a floating value here, raising a NameError. I also naively tried self.x_category_id unsuccessfully.

Is there any way to achieve this domain setup?

Right now, I'm checking that the field is properly set using an automation. It's a bit cumbersome and surely there's a fancier way to achieve this!

I use Odoo Online, so version 18.

Accurate | www.accurates.com.sa

Hi,
To set a domain filter on x_subcategory_id based on the selected x_category_id in Odoo Online v18, you need to use a special syntax since direct field references don't work in static domains. Here's how you can achieve this:
You need to use the parent prefix to reference the current record's field value in your domain. Try this domain on your x_subcategory_id field:

[('x_parent_category_id', '=', parent.x_category_id)]

This tells Odoo to filter subcategories where their parent category matches the currently selected category on the form.
The parent keyword in domains refers to the current record being edited

parent.x_category_id dynamically accesses the value of the x_category_id field on the current record

This creates a dynamic filter that changes based on what category is selected

Regards,

Jishna

Accurates

kll

Autor

@Accurate I tried to comment on the reply unsuccessfully.

Trying to plug this into Odoo via the debug form yields the following error:

NameError: name 'parent' is not defined

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to set readonly based on a many2one fields value with domain? Rozwiązane domain many2one field readonly openerp7	2 mar 15	10175
Domain with inherited field Rozwiązane domain many2one	1 paź 22	4684
Error in Creating Dynamic Domain for many2one field from onchange method in OpernErp v7 ??? domain many2one	8 lut 17	9330
Domain One2many filter domain many2one	0 sty 17	6506
many2one can't display tablename and id instead of name many2one field	2 mar 15	10356

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!