Odoo Help


Reporting from audittrail data?

Andrius Laukavičius
on 1/27/14, 9:04 AM 998 views

I want to make reporting for crm opportuniy from audittrail data. Specifically I need to track how many times stages were changed at any particular time. So I figured I could use audittrail module, which tracks this information. But there I need to use object_id. How can I get object id using sql query (when making repor)? If I would use static id that I got from ir_model table I got (for crm.lead), then if someone would use in another database, that object id may be different and report would stop working.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 1/27/14, 9:04 AM
Seen: 998 times
Last updated: 3/16/15, 8:10 AM