Pass context to many2many and filter domain

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

CRM
e-Commerce
Бухоблік
Склад
PoS
Project
MRP

All apps

All Posts Люди Значки

Мітки (View all)

odoo accounting v14 pos v15

Про цей форум

Допомога

Pass context to many2many and filter domain

domain context odooV9

3 Відповіді

24357 Переглядів

Eliseo Tehuitzil

Set context depending on many2many ids to domain or filter other many2many.

In model

batch_id = fields.Many2one('ae.batch', 'Batch')
subject_ids = fields.Many2many('ae.subject', string="Subjects")
topic_ids = fields.Many2many('ae.topic', string="Topics")
subtopic_ids = fields.Many2many('ae.subtopic', string="Subtopics")

The goal is to pass context in order to filter(domain), picking a Batch filters Subjects, choose Subjects, could be one or more, to filter Topics, and filter Subtopics.

Check view:

<group col="4" name="plan_detail" String='Choose t'>
<field name="batch_id" 
    context="{'batch_id':batch_id}"/>

<field name="subject_ids" 
    domain="[('batch_id', '=', batch_id)]" 
    context="{'subject_ids': subject_ids}"/>

<field name="topic_ids" 
    domain="[('subject_id', 'in', 'subject_ids')]"
    context="{'topic_ids': topic_ids}" />

<field name="subtopic_ids" widget="many2many_checkboxes" 
    domain="[('topic_id', 'in', topic_ids)]" />

What is working, picking the Batch filters correctly all Subjects. Stucked between Subjects to Topics, I think is a context or domain problem, I've tested changing the domain manually like so:

<field name="topic_ids" 
    domain="[('subject_id', 'in', '[1, 2]')]"
    context="{'topic_ids': topic_ids}" />

And successfully gets Topic list. I guess I am wrong passing context or getting domain.

Sarga

Найкраща відповідь

Hi,

Is the current scenario like ,you need to filter subjects based on batches and topics based on the subjects and sub topics based on topics plus subjects ,topics and sub topics are manytomany fields. If yes then i hope passing domain via .py file could solve your issue.i have provided an example below.Hope this could help you :)

@api.onchange('subject_ids')
def onchange_subject_ids(self):
    listids=[]
    if self.subject_ids:
        for each in self.subject_ids:
            listids.append(each.id)
            domain = {'topic_ids': [('id', 'in', listids)]}
            return {'domain': domain, 'value': {'topic_ids': []}}

Hilar Andikkadavath

Good

Eliseo Tehuitzil

Автор

I just found another way to achieve this, very simple actually.

Since the context for many2many-one2many is a recordset (little changes in bold):

<field name="batch_id" 
    context="{'batch_id': 'batch_id'}"/>

<field name="subject_ids" 
    domain="[('batch_id', '=', batch_id)]" 
    context="{'subject_ids': 'subject_ids'}"/>

<field name="topic_ids" 
    domain="[('subject_id', 'in', subject_ids[0][2])]"
    context="{'topic_ids': 'topic_ids'}" />

<field name="subtopic_ids" widget="many2many_checkboxes" 
    domain="[('topic_id', 'in', topic_ids[0][2])]" />

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Реєстрація

Related Posts	Відповіді	Переглядів
Help me write this domain and context. Вирішено domain context	1 лист. 24	4878
How to return a domain on field on onchange action ? Вирішено domain onchange context	3 лист. 24	45410
How to update the context on the new api ? Вирішено context odooV9 newAPI	4 вер. 24	47465
Any ways to pass context from controller and get it in odoo view or act_window? domain context controller	0 лип. 24	9291
odoo14 inherit view extend context & domain domain context extend	0 січ. 21	4703

Це запитання позначене

Enjoying the discussion? Don't just read, join in!