I have the next table in Odoo, named relationship , which comes from the relation between the table girl and the table boy : girl_id boy_id relationship_type 1 2 friends 1 3 siblings 2 7 lovers So: In the table girl there's a field relationships which is a one2many pointing to the table relationship . In the table boy there's a field relationships which is a one2many pointing to the table relationship . In the table relationship there are two fields, girl_id and boy_id , both pointing to the tab

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

CRM
e-Commerce
Kế toán
Tồn kho
PoS
Dự án
MRP

All apps

Tất cả bài viết Người Huy hiệu

Thẻ (Xem tất cả)

odoo accounting v14 pos v15

Về diễn đàn này

Hỗ trợ

How to set this specific domain in XML?

domain xml many2one odoo8.0

3 Trả lời

39867 Lượt xem

Juan Formoso Vasco

I have the next table in Odoo, named relationship, which comes from the relation between the table girl and the table boy:

girl_id	boy_id	relationship_type
1	2	friends
1	3	siblings
2	7	lovers

So:

In the table girl there's a field relationships which is a one2many pointing to the table relationship.

In the table boy there's a field relationships which is a one2many pointing to the table relationship.

In the table relationship there are two fields, girl_id and boy_id, both pointing to the tables girl and boy respectively.

Scenario:

In the forms of girl and boy there's the field relationships. When I add a new relationship for a girl or a boy, a form is opened to fill in the fields of the table relationship (girl_id, boy_id and relationship_type). Imagine I'm in the form of a girl, I click on add a new relationship and the form is opened. I implemented this in order not to see the girl_id (it's invisible but it contains the ID of the current girl). So I can see only two fields (boy_id and relationship_type).

What I want:

Keeping on with the example, if I open the dropdown of boy_id, I'll see all boys, even the ones who are already related to this girl, and that's what I don't want. For example, if I'm adding a relationship to the girl with id 1, I must not see boys with ids 2 and 3, if the girl is the one with id 2, I must not see the boy with id 7.

My code:

<field name="girl_id" invisible="1"/>
<field name="boy_id" domain="[('id', 'not in', girl_id.relationships.boy_id)]"/> <!-- Obviously this does not work -->
<field name="relationship_type"/>

Can anyone help me, please? Thank you!

Temur

1) wrong domain, it should not work... 2) why do not use many2many relations between girl and boy? many2many relation seems more convenient to use in your scenario and all this packet of technical problems will disappear with it

Juan Formoso Vasco

Tác giả

Because it's my understanding that it's not possible to store more fields than the IDs in a many2many relationship, is it?

Temur

you can use relation many2many...

use in girl's model:

relationships = fields.Many2many(comodel_name="boy.model.name", relation='relation_table_name', column1='boy_id', column2='girl_id', string="relationships of this girl")

use in boy's model:

relationships = fields.Many2many(comodel_name="girl.model.name", relation='relation_table_name', column1='girl_id', column2='boy_id', string="relationships of this boy")

note that in both cases relation table is the same ( relation='relation_table_name' )

but column1 and column2 are inversed (in case of girl column1='boy_id' and column2='girl_id' but in case of boy column1='girl_id' and column2='boy_id'

UPDATE:

apart of this two models, you can add new model and force it to have same table name as the relation table (using _table field):

_table = "relation_table_name"

and add the two fields representing ids:

boy_id = fields.Many2one(comodel_name="boy.model.name", string="Boy's ID")

girl_id = fields.Many2one(comodel_name="girl.model.name", string="Girl's ID")

also additional fields you like, as:

relationship_type = fields.Selection(.... (or fields.Char(... or something else...)

...

you can find useful the last model.

you can try to correct your domain as follows:

add "the_computed_one2many_field" computed field and add it as invisible to the view.

the 'compute' function of "the_computed_one2many_field" must return list of ids...

probably the_computed_one2many_field may be also related field to girl_id.relationships.boy_id (not computed one)

Juan Formoso Vasco

Tác giả

Thank you for your help @Temur, but I think that way a boy will have the same relationship with every girl and the other way around. Let's imagine that I create the relationship_type on the table boy: when I create a boy, I will have to set the relationship type of that boy? And that boy will always have that relationship type!

Temur

yes, I see. I updated the answer. it's more complicated then I thought.

Juan Formoso Vasco

Tác giả

Thank you @Temur, I thought the last suggestion (after the OR) was the best and would work, but I get the RuntimeError: maximum recursion depth exceeded while calling a Python object, because there's a model with a one2many pointing to other model which also has a one2many pointing to the first one.

Temur

you tried to add computed field or related field?

Temur

lets say we're adding the computed field to girls model, then

@api.depends('girl_id')
def _compute_boys(self):
   #... implement the function

girls_relations = fields.One2many(comodel_name="boys.model.name", compute='_compute_boys')

for @api.depends I just guess, adapt it to your model. then use in xml:

<field name="boy_id" domain="[('id', 'not in', girls_relations )]"/>

and you'll need same for boy's relations...

Temur

probably @api.depends('relationships') and not girl_id ? I don't know your model structure

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
[SOLVED] Is posible change a domain_force in security.xml through a function in Python? (odoo 8) Đã xử lý security domain xml odoo8.0	2 thg 3 15	10925
Domain with inherited field Đã xử lý domain many2one	1 thg 10 22	4531
How to get the current user in XML domain xml	2 thg 11 25	9975
Many2one field: 'id' instead of 'name' Đã xử lý many2one odoo8.0	1 thg 2 21	5616
Showing many2one fields in other modules Đã xử lý xml many2one	2 thg 2 18	13073

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!