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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 1/27/14, 9:04 AM|
|Seen: 633 times|
|Last updated: 3/16/15, 8:10 AM|