Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
3108 Visualizzazioni

I have price1 in product.product, And I create new field price2 ,then I want to copy  price1 value to price2

There are thousands of price1 and I tried erppeek ,but it seems too slow

Avatar
Abbandona
Risposta migliore

Hi Chen Rong,

You just have to run following simple query in postgres that will save your time to either create a custom module or writting a code.

update your_table_table set new_field=old_field;

Where, 

new_field: Field in which you want to copy data.
old_field: Field from which you want to copy data.

Avatar
Abbandona
Autore

Hi ,I find old_field is property field,it is in ir_property,and res_id is 'product.template,XX', and new_field is in product_template,how to copy it?