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
- Comptabilité
- Inventaire
- PoS
- Project
- MRP
Cette question a été signalée
3198
Vues
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrirePublications associées | Réponses | Vues | Activité | |
---|---|---|---|---|
|
1
févr. 24
|
1688 | ||
|
1
mai 23
|
2978 | ||
|
1
avr. 15
|
6441 | ||
|
1
mars 15
|
5356 | ||
|
0
sept. 24
|
729 |