Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
partnerdomainmany2onedomain_filterrelation
3 Svar
10757 Vyer
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
Avbryt
Avatar
Julius Petraška
Författare Bästa svar

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
Avbryt
Avatar
Solanki Shamji
Bästa svar

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
Avbryt
Avatar
Adil Akbar
Bästa svar

Hi, 

You can follow following link for this:

https://youtu.be/GPhgxxwprA4

Hope it helps,

Thanks

Avatar
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
How can i use a field from 3th model for Domain ?
domain many2one domain_filter odoo v15
Avatar
0
mars 23
3222
Many2one Domain (Filter by user security groups)
security domain many2one domain_filter domains
Avatar
0
aug. 16
5614
How to use domains for required fields of many2one when having multiple many2ones?
domain many2one models domain_filter odoo8.0
Avatar
Avatar
4
apr. 15
8362
Condition Drop Down Items
domain domain_filter
Avatar
0
feb. 25
18
Domain with inherited field Löst
domain many2one
Avatar
1
okt. 22
5601