Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
3119 Näkymät

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
Hylkää
Paras vastaus

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
Hylkää
Tekijä

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?