Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
3 Trả lời
898 Lượt xem

Hello,


I have an issue with one2many field, please review this example code:


Model:

class ParentModel(models.Model):

    _name = 'parent.model'

    parent_field = fields.Char(compute='_compute_parent_field')

​ children_ids = fields.One2many('child.model', 'parent_id', string='Children')


    @api.depends('children_ids.child_field')

    def _compute_parent_field(self):

        for record in self:

            # Custom logic to compute parent_field based on child_field

            record.parent_field = 'Computed Value' if record.children_ids else 'Default Value'


class ChildModel(models.Model):

    _name = 'child.model'

    parent_id = fields.Many2one('parent.model', string='Parent')

    related_parent_field = fields.Char(related='parent_id.parent_field')


    child_field = fields.Char()



View:

<?xml version="1.0" encoding="utf-8"?>
<odoo>
    <data>
        <record id="parent_model_form" model="ir.ui.view">
            <field name="name">parent_model_form</field>
            <field name="model">parent.model</field>
            <field name="arch" type="xml">
                <form>
                    <sheet>
                        <group>
                            <field name="parent_field"/>
                        </group>
                    <notebook>
                        <page string="Children">
                            <field name="children_ids">
                                <tree>
                                    <field name="child_field"/>
                                    <field name="related_parent_field"/>
                                </tree>
                            </field>
                        </page>
                    </notebook>
                    </sheet>
                </form>
            </field>
        </record>
    </data>
</odoo>


The child_field change value is properly computed, parent_field is updated and displayed in the parent.

The related_parent_field is also updated and displayed for the current child record.


The problem is the other child records are not updated.

When I edit other child records, I see the old value of related_parent_field.


I have to save the parent record to see the changes in other child records.


Hope you can help me with this issue.

Thanks in advance.





Here's a more concrete example that clearly demonstrates the issue:


```python

# Models

class ProductCategory(models.Model):

    _name = 'product.category'

    _description = 'Product Category'

   

    name = fields.Char(string='Category Name', required=True)

    total_products = fields.Integer(string='Total Products', compute='_compute_total_products')

    product_ids = fields.One2many('product.product', 'category_id', string='Products')

   

    @api.depends('product_ids.active')

    def _compute_total_products(self):

        for category in self:

            category.total_products = len(category.product_ids.filtered(lambda p: p.active))



class Product(models.Model):

    _name = 'product.product'

    _description = 'Product'

   

    name = fields.Char(string='Product Name', required=True)

    active = fields.Boolean(string='Active', default=True)

    category_id = fields.Many2one('product.category', string='Category')

    category_total = fields.Integer(related='category_id.total_products', string='Products in Category')

```


```xml

<!-- Product Category Form View -->

<record id="product_category_form_view" model="ir.ui.view">

    <field name="name">product.category.form</field>

    <field name="model">product.category</field>

    <field name="arch" type="xml">

        <form>

            <sheet>

                <group>

                    <field name="name"/>

                    <field name="total_products"/>

                </group>

                <notebook>

                    <page string="Products">

                        <field name="product_ids">

                            <tree>

                                <field name="name"/>

                                <field name="active"/>

                                <field name="category_total"/>

                            </tree>

                        </field>

                    </page>

                </notebook>

            </sheet>

        </form>

    </field>

</record>

```


## Steps to Reproduce the Issue:


1. Create a new Product Category "Electronics"

2. Add three products to this category: "Laptop", "Phone", "Tablet"

3. Notice that `total_products` shows 3 and all products show `category_total = 3`

4. Edit the first product "Laptop" and uncheck the "Active" box

5. Notice that:

   - The `total_products` on the category updates correctly to 2

   - The `category_total` on the "Laptop" product updates correctly to 2

   - But the `category_total` on "Phone" and "Tablet" still shows 3 (incorrect)

6. Only after saving the form, the `category_total` value on all products updates correctly


This example clearly shows how field changes in one record (deactivating a product) correctly trigger computed fields in the parent (category.total_products), but the related fields in sibling records don't refresh automatically without saving.



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

I've added a clearer example to the original post to clarify the issue


I got it working now.


Thank you for your help.


Here are the changes that made it work:


Category model:

@api.depends('product_ids.active')

    def _compute_total_products(self):

        for category in self:

            category.total_products = len(category.product_ids.filtered(lambda p: p.active))

for product in category.product_ids:

​ product.category_total = category.total_products  # Update each product's category_total field


Product Model:


category_total = fields.Integer(store=False, string='Products in Category')


View:


<field name="product_ids" context="{'default_category_total': total_products}">



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

Hello Thach,

To ensure child records automatically update when the parent field changes, you can use the @api.depends decorator in the child model. This ensures that changes in the parent model trigger recomputations for the related child records.

Alternatively, you can manually trigger the recomputation using @api.onchange in the parent model, or update the child records using a method call within the parent model.

Both approaches are valid, but using @api.depends in the child model is a cleaner solution if the changes are based on specific computed fields.

Ảnh đại diện
Huỷ bỏ
Tác giả

Hello Darshan, thanks for your replay.

Tác giả

I tried your advice, but I'm still getting the same result.
I've added a clearer example to the original post to clarify the issue. Could you look again?

Câu trả lời hay nhất

Since the parent_field is not stored anyway, maybe it's better to remove the @api.depends. It's calculated everytime it is retrieved whether or not the children are changed.
Another approach is to override the save of the child models to trigger the calcuation of the parent (if you store the calculated value).

Ảnh đại diện
Huỷ bỏ
Tác giả

Thanks,
I tried your advices. It still required saving the parent for the changes to apply to all children.
I've added a clearer example to the OP. Could you look again?

Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 3 24
4214
4
thg 5 25
2586
2
thg 5 25
5966
1
thg 3 25
1719
4
thg 3 25
4574