How to set a default value to a new field to existing records?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客户关系管理
e-Commerce
会计
库存
PoS
Project
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

How to set a default value to a new field to existing records?

fields default record set

1 回复

8807 查看

Anabela Damas

Hi,

I created a new module that add a new field "user_last_change_state" to the object "account.invouce", and I've done some code with this field.

I needed that older records to have this field equal to 1 (admin id ).

Someone knows how to set the new data field with a default value to existent records?

Thanks

Oscar Cascante F

The simplest form is to do it from a sql script in postgresql. If you have linux, you could do it using pgadmin3 software. The script will be like this: UPDATE [file] SET [field] = 'value' WHERE [condition] ;

Anabela Damas

编写者

I did that... but it this the best way ?

Oscar Cascante F

I my experience yes.... but maybe there's something better.

Anabela Damas

编写者

Hope that someone knows a better way =)

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Show value from ir.default in a form view 已解决 fields default	1 5月 22	3941
Default value editable on field 已解决 fields default	1 8月 19	3899
Fields Default Active ID fields default active_id	1 12月 21	6369
Why does one field not reach the other field as the default value? fields default compute	0 10月 21	2938
How to set the default value without a related field? fields default related	1 10月 21	3733

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！