Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

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

By
Anabela Damas
on 7/29/13, 3:24 PM 1,327 views

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

0
Oscar Cascante F
On 7/29/13, 7:55 PM

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] ;

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

Versão Integral, Anabela Damas
on 7/30/13, 7:45 AM

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

Oscar Cascante F
on 7/30/13, 11:48 AM

Hope that someone knows a better way =)

Versão Integral, Anabela Damas
on 7/30/13, 11:52 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 7/29/13, 3:24 PM
Seen: 1327 times
Last updated: 3/16/15, 8:10 AM