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
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Odoo Online: using field in domain

domain many2one field odooonline v18

2 Vastaukset

1868 Näkymät

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

Tekijä

@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

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to set readonly based on a many2one fields value with domain? Ratkaistu domain many2one field readonly openerp7	2 maalisk. 15	10213
Domain with inherited field Ratkaistu domain many2one	1 lokak. 22	4692
Error in Creating Dynamic Domain for many2one field from onchange method in OpernErp v7 ??? domain many2one	8 helmik. 17	9336
Domain One2many filter domain many2one	0 tammik. 17	6518
many2one can't display tablename and id instead of name many2one field	2 maalisk. 15	10362

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!