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.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Comptabilitat
- Inventari
- PoS
- Project
- MRP
This question has been flagged
3170
Vistes
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Registrar-seRelated Posts | Respostes | Vistes | Activitat | |
---|---|---|---|---|
|
1
de febr. 24
|
1617 | ||
|
1
de maig 23
|
2894 | ||
|
1
d’abr. 15
|
6328 | ||
|
1
de març 15
|
5298 | ||
|
0
de set. 24
|
692 |