how to retive datafrom the table?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- إدارة علاقات العملاء
- e-Commerce
- المحاسبة
- المخزون
- PoS
- Project
- MRP
لقد تم الإبلاغ عن هذا السؤال
2
الردود
2687
أدوات العرض
This is the example to retreive information from database for a table.
Here [('user_id', '=', uid)] --> Here we can include the condition we put in WHERE clause
emp_obj = self.pool.get('hr.employee')
emp_ids = emp_obj.search(cr, uid, [('user_id', '=', uid)], context=context)
if emp_ids:
for employee in emp_obj.browse(cr, uid, emp_ids, context=context):
return {'name': employee.name}
--->Hope this helps you
It is recomandable to use object model to read data from the database, however some times it is more efficient to read data with SQL. If you want to read data with direct SQL, you can use the cr (cursor) that is passed to your methods as follows:
cr.execute(""" SELECT name FROM res_partner""")
result = cr.fetchall()
for partner in result:
print partner[0]
هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!
أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!
تسجيل