Odoo 7:Copy property value to new product_template field

Question

I want copy property filed list_price value to product_template list_price2

res_id  is product.template,id

insert into product_template (id, list_price2)
select cast(substring(res_id from 18) as int) as id, value_float
from ir_property where name='list_price';
ERROR:  null value in column "uom_id" violates not-null constraint
DETAIL:  Failing row contains (32645, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,

chen rong · Answer

I solved it.

UPDATE product_template p2
SET list_price2 = p1.value_float
FROM ir_property p1
WHERE p2.id  = cast(substring(p1.res_id from 18) as int) and p1.name='list_price'
AND p2.list_price2 IS DISTINCT FROM p1.value_float;

İlgili Gönderiler	Cevaplar	Görünümler
Usage Of SQl Queries In odoo sql	1 Kas 22	5903
sql constraints aren't being detected in my model sql	1 Eki 21	3438
Odoo on microsoft sql server instead postgres sql? sql	2 Kas 18	10338
Openerp with MS-SQL sql	4 Mar 15	5395
how can i get the date in dd mm yyyy format please help me? sql	1 Mar 15	6143

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!