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

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Many2many field filtering based on selected contact id?

domain many2many odoo10

1 الرد

12015 أدوات العرض

Samo Arko

I'm trying to get projects where the selected contact is the follower. I need it so I can select for which projects I should generate the report. For this I'm using a wizard with a Many2One field for selecting the contact and a Many2many field I want to use for checkboxes in the view.

Is it possible to set a dynamic domain that will filter the Many2many field?

contact_id = fields.Many2one('res.partner', domain="[('customers_tic_id', '!=', False)]")
project_ids = fields.Many2many(comodel_name='project.project',
                                   relation='project_document_wizard_rel',
                                   column1='document_wizard_id',
                                   column2='project_id',
                                   string='Contacts following projects',
                                   domain="[('project_id', 'in', self.followers_search_to_list())]")




def followers_search_to_list(self):
        tmp_list = list()
        followers = self.env['mail.followers'].sudo().search([('partner_id', '=', contact_id.id), ('res_model', '=', 'project.project')])

        for follower in followers:
            tmp_list.append(follower.res_id)

        return tmp_list

So what I'm doing wrong?

Ibrahim Boudmir

أفضل إجابة

Hi,

Your question is : can we set a dynamic domain that will filter M2M field based on Another M2O field?

Answer : Yes you can.

First, remove the domain from the M2M declaration. Then add a onchange function like this:

@api.onchange('contact_id')
 _onchange_contact_id(self):
    if self.contact_id:
        domain = [('project_id', 'in', self.followers_search_to_list())]
        return {'domain': {'project_ids': domain}}

Upvote if this helps. If not, you can write back for further analysis.
Regards.

Samo Arko

الكاتب

Thanks! I only needed to change 'project_id' to 'id'. And you forgot to say that I needed to add compute='_on_change_contact_id' to M2M field. Is there a way to not show any M2M records until the contact is selected? Now I get all existing projects until I select the contact.

Samo Arko

الكاتب

I can't click on any of the checkboxes!?

Ibrahim Boudmir

Hi,

1- I did not forget to mention that the field should have compute attribute because simply it should not.

2- Not show M2M record until contact is selected : in onchange_contact_id, i only added the condition where contact is set. In this case, you can add 'else' then apply another domain that suits your need.

3- you can't click on any of the checkboxes because you made the field compute... compute field is readonly. Since that is not what i suggested, remove compute attribute.

but to enlighten you more, even if a field is computed, you can still add records manually by adding the attribute "inverse".

Hope this helps you.

Samo Arko

الكاتب

yeah I figured that about compute field out, so I removed it and it saves. But the problem that I've got now is when the record is saved and when I open it again (go to a different view and back) there are again displayed all projects. But at least the ones that were selected remain selected.

Vysakh B Thottarath

@Tabla : I also have the same problem while using onchange for domain.You got any other solutions ?

Samo Arko

الكاتب

You need to specify the problem a bit more. But mostly the solution suggested worked for me. If you created a post with the problem explained and some code then post me the link in the comment.

Yeison X

Hi.

Can I do this with Automated Actions?

I have a many2one field (res.partner) and a many2many field (account.move)

When I select the partner, I want only to show the account move documents related with the partner selected.

I'm wondering if it's possible to achieve this with a automated actions and a python code.

Thanks

ahmadsalih7

Thank you, it works !!

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Many2many domain works when click search more but wrong values in dropdown domain many2many	0 نوفمبر 22	80
[SOLVED] Create rule using many2many - how to? تم الحل domain many2many	1 يونيو 22	8152
Many2many domain not working تم الحل domain many2many	1 يوليو 21	3568
Many2many domain not working تم الحل domain many2many	1 يوليو 21	5075
How to Update Many2Many Relation Table Records in Odoo 10 تم الحل many2many odoo10	2 مايو 17	11904

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!