Select query for odoo

Question

i need to select data from the database..how this possible?

DHA Medic · Accepted Answer

@ api.model_cr
def yourfunc( self ):
self ._cr.execute( """ Your MYSQL COmmand Here"")
data = self._cr.dictfetchall()

aneesh ATEES Infomedia Pvt Ltd · Answer

can u please give me the full example with fucnction defnition

Temur · Answer

If you're about direct queries to database, then *cr.execute('select ....')* is what you need, for details please refer to this page [1]

*BUT* if it's not absolutelly necesary, you should prefer to use search() [2] - browse() [3] couple in Openerp 7.0 series and search() [4] in Odoo 8.0.

[1] https://doc.odoo.com/contribute/15_guidelines/coding_guidelines_framework/
[2] https://doc.odoo.com/v6.0/developer/2_5_Objects_Fields_Methods/methods.html/#osv.osv.osv.search
[3] https://doc.odoo.com/v6.0

Baiju KS · Answer

Hi Aneesh,

You can use search function.

Search function takes a None [1]/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

[1] https://www.odoo.com/documentation/8.0/reference/orm.html#reference-orm-domains

Abderrahmen · Answer

using api8,

self.env['tablename'].search_read([], []):

Javed Shoukat · Answer

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?

This question has been flagged

Enjoying the discussion? Don't just read, join in!