onchange return domain for one2many product ID Field

domain one2many onchange

7 Odpowiedzi

21157 Widoki

Prakash

Using (Sale Order) onchange Function how to add return domain for (Sale Order Line) one2many table Product ID Field?..

In Default onchange domain return example available for same table and column.

Example: return {'domain': {'column_name': [('id', 'in', listids)]}}

But how to add domain in one2many table Field using onchange method ?..

Requirement:- Sale Order based on Partner selection dynamic add domain in Sale Order Line Product Field.

Code:

def onchange_partner_id(self, cr, uid, ids, part, context=None):
        res = super(sale_order, self).onchange_partner_id(cr, uid, ids, part, context=context)
       res['value'].update({'order_line': []})
       if part:
            product_obj = self.pool.get('product.product')
            matching_cust_ids = product_obj.search(cr, uid, [('x_cust_name','=',part)])
            res['value'].update({'custproduct_id': matching_cust_ids})
            domain = {'domain':{'order_line.product_id': [('order_line.id', '=', matching_cust_ids)]}}
            res['value']['order_line'].append(domain)
        return res

Issue: The above code return domain for one2many table product Field is not working.

Alex Gallien

For more background, what we were trying to do earlier (https://www.odoo.com/forum/help-1/question/limiting-customers-to-specific-products-58972) is link a customer and a product using a field on many2one field on the product page - 'x_cust_name': fields.many2one('res.partner', 'Customer', store=True). Ideally the module would only display the products that have the 'x_cust_name" equal to the name of the customer on the Sales Order.

Alex Gallien

Prakash - Janeesh's solution below worked! I think we were seriously overthinking things. Thanks again for your help, I really appreciate it.

Janeesh

Najlepsza odpowiedź

If field_id is a many2one field to partner, then you can simply give domain in xml for product_id field. Domain should be domain="[('field', '=', parent.partner_id)]"

Alex Gallien

Ah of course it is way simpler than we were trying to make it. This worked perfectly using 'edit form view' from dev mode, but I am having trouble figuring out how to declare the xpath in my module. I am adding an answer with my code - if you could take a look I would really appreciate it.

Alex Gallien

Actually, scratch that - I figured it out. Thanks for the help!!

John Daniel

If field_id is a many2one field to partner, then you can simply give domain in xml for product_id field. Domain should be domain="[('field_id', '=', parent.partner_id)]"

Alex Gallien

Janeesh - here is my attempt to implement your solution in a module. The domain isn't showing up for me right now, and I think it is because of my xpath declaration. Could someone help me figure out how to declare this domain correctly? Thanks!

EDIT: For anyone wondering the solution here, I think it had to do with the fact that the 'field' tag I was looking for was embedded past another field tag. The xpath that ended up working for me was:

<xpath expr="//field[@name='order_line']/tree/field[@name='product_id']"

which actually could be shortened to

xpath expr="//tree/field[@name='product_id']"

Here is my original (not functional) code.

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

<field name="name">sale.order.form</field>

<field name="model">sale.order</field>

<field name="inherit_id" ref="sale.view_order_form"/>

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

   <xpath expr="//field[@name='product_id']" position="replace">

<field name="product_id" context="{'partner_id':parent.partner_id, 'quantity':product_uom_qty, 'pricelist':parent.pricelist_id, 'shop':parent.shop_id, 'uom':product_uom}" groups="base.group_user" on_change="product_id_change(parent.pricelist_id, product_id, product_uom_qty, product_uom, product_uos_qty, product_uos, name, parent.partner_id, False, True, parent.date_order, False, parent.fiscal_position, False, context)" domain="[('x_cust_name', '=', parent.partner_id)]"/>

   </xpath>

</field>

   </record>

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How to return domain on one2many field so that seleted values are not shown in next line domain one2many onchange	1 kwi 23	7246
How to update two levels o2m fileds relation one2many onchange	0 wrz 20	5309
How i can Apply onchange method on one2many field ? domain onchange	1 wrz 19	6819
Several levels of One2many one2many onchange	0 kwi 16	5095
One2many onchange in ODOO Rozwiązane one2many onchange	3 mar 16	16736

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!