project=# select id,fields_id,res_id,name,value,company_id from ir_property; id | fields_id | res_id | name | value | company_id ----+-----------+--------+-------------------------------------+---------------------+------------ 1 | 811 | | property_product_pricelist | product.pricelist,1 | 2 | 1164 | | property_account_receivable | account.account,2 | 1
above is the ir_property table contents. you will find value of field from value field and the record id will be in res_id. you have to split value by ',' so you will get id. fetch value using query is bit complex. :( ------------------------ OpenERP=Easier, Adaptable, Affordable, Modular -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=49789#49789 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
