How to execute query in Odoo


@api.onchange('attachments')
def filter_document(self):
self.env.cr.execute("SELECT a.datas_fname FROM ir_attachment a,hr_employee e where a.res_id =3")
self.attachments = self.env.cr.fetchone()[0]
cr.execute('select id from account_invoice  where number =%s',(invnumber,))
        print cr.fetchone()[0]
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s