Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I have a field on stock_picking table I would like to relate it with stock_move
_inherit= 'stock.picking'
_column={
'user_id': fields.many2one('res.users', 'user', select=True),
}
I would like to relate the field user_id with stock_move
I tried this
_inherit= 'stock.move'
_column={
'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)
}
any Idea brothers?
I think model in inherit it should be as follows:
_inherit= 'stock.picking'
_columns={ 'user_id': fields.many2one('res.users', 'user', select=True), }
_inherit= 'stock.move'
_columns={ 'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True) }
no value stored in the table on the field user_id !!!
ans edited... check it.. wrongly spelled _columns ans _column.
the column user_id couldn't be updated, I droped it from the table & I tried it work fine now
Hello rachid,
you have added field in wrong model. try this,
_inherit= 'stock.move'
_columns={
'user_id': fields.related('picking_id', 'user_id', relation="res.users", type='many2one', string="user", store=True, readonly=True)
}
and yeah this code is correct.
_inherit= 'stock.picking'
_columns={
'user_id': fields.many2one('res.users', 'user', select=True),
}
Hope this will help you. for more details on related field check this.
the column user_id couldn't be updated, I droped it from the table & I tried it work fine now
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
