Get data from database odoo

0
votes

Which is the simplest way to show data in xml from res_users_log table in custom module?

SELECT id, create_uid, create_date, write_date, write_uid FROM res_users_log

1
openerpodoo-9
I don't know what you are trying to do. Could you explain with more details? – ChesuCR
@ChesuCR load data from databse in my .xml form, this data postimg.org/image/y9ye5iru5 show in xml in list view. – user_odoo
Just create a tree form with the fields you want to show. You can check examples in the source code of Odoo – ChesuCR
@ChesuCR any link example? – user_odoo
You should read the docs. odoo.com/documentation/9.0/howtos/backend.html – Nope

1 Answers

0
votes

I hope this can help you 

def _get_users_log(self):
    SQL = ('select * from res_users_log')
    self.env.cr.execute(SQL)
    for row in self.env.cr.fetchall():
            return row