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
- Contabilitate
- Inventar
- PoS
- Project
- MRP
Această întrebare a fost marcată
3167
Vizualizări
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-teRelated Posts | Răspunsuri | Vizualizări | Activitate | |
---|---|---|---|---|
|
1
feb. 24
|
1616 | ||
|
1
mai 23
|
2890 | ||
|
1
apr. 15
|
6327 | ||
|
1
mar. 15
|
5296 | ||
|
0
sept. 24
|
691 |