Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
3 Trả lời
4991 Lượt xem

I want to update all company pricelists from one to another in a batch, but I don't see anywhere in the database that stores the pricelist id for the company.


Where is this information stored? 


http://goo.gl/jn0O7K

Ảnh đại diện
Huỷ bỏ

Hi Travis, by Database what do you mean?

Tác giả

Hello, by database, I mean the PostgreSQL database itself. My idea is to update them all with an update query from psql.

Tác giả Câu trả lời hay nhất

The Sales Pricelist's field name is actually property_product_pricelist, which indicates it is a field of type property (deprecated in v8).


Basically, the values for this field are not stored in the res_partner table as I expected.


Each record is stored in the ir.property table, as you can see if you view the database with the following query:

SELECT * FROM ir_property WHERE name = 'property_product_pricelist';


You can theoretically update the values by SQL commands, but I would recommend against it (maybe someone else has a good way of doing that safely?).


For some better understanding of property fields, check the following links:

V6 Documentation: https://doc.odoo.com/6.0/developer/2_5_Objects_Fields_Methods/field_type/

Beginner question about functional fields and property fields?: https://www.odoo.com/fr_FR/forum/aide-1/question/beginner-question-about-functional-fields-and-property-fields-77398#answer_77401

Can anyone clearly explain property fields?: https://www.odoo.com/fr_FR/forum/aide-1/question/can-anyone-clearly-explain-property-fields-42887

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 6 25
764
2
thg 4 25
1206
0
thg 7 25
1609
0
thg 1 25
1132
2
thg 11 24
6789