Bỏ qua để đến Nội dung
Câu hỏi này đã bị gắn cờ
partnerdomainmany2onedomain_filterrelation
3 Trả lời
9723 Lượt xem
Ảnh đại diện
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?

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Julius Petraška
Tác giả Câu trả lời hay nhất

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')]}"/>

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Solanki Shamji
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Ảnh đại diện
Adil Akbar
Câu trả lời hay nhất

Hi, 

You can follow following link for this:

https://youtu.be/GPhgxxwprA4

Hope it helps,

Thanks

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
How can i use a field from 3th model for Domain ?
domain many2one domain_filter odoo v15
Ảnh đại diện
0
thg 3 23
2419
Many2one Domain (Filter by user security groups)
security domain many2one domain_filter domains
Ảnh đại diện
0
thg 8 16
4923
How to use domains for required fields of many2one when having multiple many2ones?
domain many2one models domain_filter odoo8.0
Ảnh đại diện
Ảnh đại diện
4
thg 4 15
7504
Condition Drop Down Items
domain domain_filter
Ảnh đại diện
0
thg 2 25
18
Domain with inherited field Đã xử lý
domain many2one
Ảnh đại diện
1
thg 10 22
4531