Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1 Antworten
13036 Ansichten

How to Retrive the data from postgres sql and fill that data into text field in openerp ..? ? ? ?? ??

Avatar
Verwerfen

Can you explain your requirement in detail.

Beste Antwort

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())

Avatar
Verwerfen
Autor

thanks shashank verma...!!!