How can I run a sql query after clicking a button in Odoo?

Question

I am using Odoo8 and I am trying to create a custom module to generate a report after adding a date to the date field.

So my question is: how can I run a SQL query in a python class after clicking a button in a form?

+4

Andry vononka Jul 27 '15 at 13:49

1 answer

Chesucr · Answer 1 · 2015-07-27T14:59:50+0000

XML representation:

<button name="open_something" string="Name of button" type="object" />

Python Code:

@api.multi
def open_something(self):
    self.ensure_one()

    self.env.cr.execute("SQL query")
    result = cr.fetchall()

    ...

Keep in mind that you must use ORM methods because some restrictions are not contained in the database.