How to Retrive the data from postgres sql and fill that data into text field in openerp ..? ? ? ?? ??
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Бухгалтерия
- Склад
- PoS
- Project
- MRP
Этот вопрос был отмечен
1
Ответить
13032
Представления
Hi dasadiya
You can fetch records form postgresql table in 2ways 1. ORM methods 2. SQL queries
1.ORM method
prod_obj=self.pool.get(product.product) prod_name=prod_obj.browse(cr,uid,ids)[0].name
#this will return your product name
note=fields.text('Note')
note_create=prod_obj.write(cr,uid,[ids],{'note','=',prod_name})
#this will insert product name into your text field.
2.using sql queries
cr.execute("select * from product_product where id =%s",ids) result=result = map(lambda x: x[0], cr.fetchall())
thanks shashank verma...!!!
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Регистрация
Can you explain your requirement in detail.