Skip to Content
This question has been flagged
domainOdoo13.0
1 Reply
2349 Views
Avatar
himaOdoo

i had added two fields to the stock.picking model, 

sales_order_id = fields.Many2one('sale.order', 'Order')
client_ref = fields.Char(related='sales_order_id.client_order_ref')

i want to get the value of the client_order_ref from sale.order in an automatically manner, 

so that i tired this domai

 <record id="xxxxxxxx" model="ir.ui.view">
<field name="name">xxxxxxxxx</field>
<field name="model">stock.picking</field>
<field name="inherit_id" ref="stock.view_picking_form"/>
<field name="sales_order_id"/>
<field name="arch" type="xml">
 <xpath expr="//field[@name='user_id']" position="after">
    <field name="sales_order_id"/>
    <field name="client_ref" domain="[('sales_order_id', '=', 'origin')]"/>
but i still have to manually give a value to sales_order_id in order to get the client_ref

appropriate value 

Avatar
Discard
Avatar
Rakesh Vadeghar
Best Answer 

1) Domain doesn't work for char fields
2) As the sale_id field already exists in stock.picking  table
    change your fields as below

    client_ref = fields.Char(related='sale_id.client_order_ref')
    sales_order_id = fields.Many2one('sale.order', 'Order') # No need to add this field
Avatar
Discard
himaOdoo
Author

thanks, i didn't give attention to the sale_id field, you save my day

Related Posts Replies Views Activity
One2many field domain not working Solved
domain fields Odoo13.0
Avatar
Avatar
2
Dec 21
4523
display list of product based on domain Solved
domain domain_filter Odoo13.0
Avatar
Avatar
Avatar
6
Aug 20
6101
How to get current user in attrs? Solved
attrs domain Odoo13.0
Avatar
Avatar
1
Dec 19
11827
Odoo 13. Don't close a wizard when Click a button Solved
Odoo13.0
Avatar
Avatar
Avatar
Avatar
4
May 24
10074
Permission error while user printing excel sheet report in odoo 13 Solved
Odoo13.0
Avatar
Avatar
1
Apr 24
1564