i need to select data from the database..how this possible?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
8
Replies
15611
Views
@api.model_cr
def yourfunc(self):
self._cr.execute(""" Your MYSQL COmmand Here"")
data = self._cr.dictfetchall()
can u please give me the full example with fucnction defnition
If you're about direct queries to database, then cr.execute('select ....') is what you need, for details please refer to this page
BUT if it's not absolutelly necesary, you should prefer to use search() - browse() couple in Openerp 7.0 series and search() in Odoo 8.0.
plase give me one example?
You're asking for cr.execute() example or search() example?
Hi Aneesh,
You can use search function.
Search function takes a search domain, returns a recordset of matching records. Can return a subset of matching records (offset and limit parameters) and be ordered (order parameter):
EG:-
search([('is_company', '=', True), ('customer', '=', True)])
search([('is_company', '=', True)], limit=1) give one record
using api8,
self.env['tablename'].search_read([], []):
cr. execute
I need cr. execute() example for exporting serial number, Students Names, Father Names, Mobile Numbers, Emails, Course, Batch, invoice total, amounts paid with dates, due amount, etc. Any help plz?
