@api.multi def get_all_so(self, name=None): sql = "select * from sale_order where name like '%s%' order by name desc;" % name self.env.cr.execute(sql) res_all = self.env.cr.fetchall() #fetchall() will return an array of dictionaries return res_all @api.multi def get_so(self, name=None): sql = "select * from sale_order where name like '%s' order by name desc;" % name self.env.cr.execute(sql) #fetchone() … Continue reading Sql query in Odoo model