Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
2 Antwoorden
17225 Weergaven

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?

Avatar
Annuleer
Beste antwoord

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) }

Avatar
Annuleer
Auteur

no value stored in the table on the field user_id !!!

ans edited... check it.. wrongly spelled _columns ans _column.

Auteur

the column user_id couldn't be updated, I droped it from the table & I tried it work fine now

Beste antwoord

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.

 

Avatar
Annuleer
Auteur

the column user_id couldn't be updated, I droped it from the table & I tried it work fine now

Gerelateerde posts Antwoorden Weergaven Activiteit
2
mrt. 24
1642
0
mrt. 23
2904
1
aug. 22
6684
1
jan. 22
3425
1
jan. 19
3506