Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
partnerdomainmany2onedomain_filterrelation
3 Vastaukset
9726 Näkymät
Avatar
Julius Petraška

What I need:

I want to make one field for user to select a category of partners. After he made that I want to let him to select a partner from a selected category. How could I achieve that?


What I did:

I have the fallowing fields:

  • partner_categories = fields.Many2one('res.partner.category', string="Partners Categories")

  • partner_category_name = fields.Char(related='partner_categories.name', string="Choosen category name")

  • partner_adress = fields.Many2one('res.partner', string="Partner from selected category")

In the xml i have these lines:

  • <field name="partner_categories"/>

  • <field name="partner_category_name"/>

  • <field name="partner_adress" domain="[('res.partner.category','=', 'partner_category_name')]" attrs="{'invisible': [('partner_category_name', '=', 'False')]}"/>

But that doesn't work. I'm getting error:

  • ValueError: Invalid field 'res.partner.category' in leaf "&lt;osv.ExtendedLeaf: ('res.partner.category', 'ilike', 'partner_category_name') on res_partner (ctx: )>"

Afcourse it is normal because I can't inherit res.partner module so that I could access all its fields, so res.partner.category is unknown field for my module. But how could I achieve what I need?

Avatar
Hylkää
Avatar
Julius Petraška
Tekijä Paras vastaus

I found a solution. It was to use

  • 'category_id'

in a place of

  • 'res.partner.category'

So now my field line looks like

  • <field name="partner_adress" domain="[('category_id','=', 'partner_category_name')]" attrs="{'invisible': [('partner_category_name', '=', 'False')]}"/>

Avatar
Hylkää
Avatar
Solanki Shamji
Paras vastaus

I think your domain syntax is wrong.

It should be [('partner_categories.name', '=' ,partner_category_name)]

Each tuple in the domain needs to have 3 elements, in the form: ('field_name', 'operator', value), where:

field_name must be a valid name of field of the object model, possibly following many-to-one relationships using dot-notation, e.g 'name' or 'partner_id.name' are valid values.

operator must be a string with a valid comparison operator from this list: =, !=, >, >=, <, <=, like, ilike, in, not in, child_of, parent_left, parent_right The semantics of most of these operators are obvious. The child_of operator will look for records who are children or grand-children of a given record, according to the semantics of this model (i.e following the relationship field named by self._parent_name, by default parent_id.

value must be a valid value to compare with the values of field_name, depending on its type.

May be this will helpful you.

Avatar
Hylkää
Avatar
Adil Akbar
Paras vastaus

Hi, 

You can follow following link for this:

https://youtu.be/GPhgxxwprA4

Hope it helps,

Thanks

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
How can i use a field from 3th model for Domain ?
domain many2one domain_filter odoo v15
Avatar
0
maalisk. 23
2421
Many2one Domain (Filter by user security groups)
security domain many2one domain_filter domains
Avatar
0
elok. 16
4925
How to use domains for required fields of many2one when having multiple many2ones?
domain many2one models domain_filter odoo8.0
Avatar
Avatar
4
huhtik. 15
7504
Condition Drop Down Items
domain domain_filter
Avatar
0
helmik. 25
18
Domain with inherited field Ratkaistu
domain many2one
Avatar
1
lokak. 22
4531