Is there a logging configuration enabling the logging of all SQL queries issued by OpenERP to a file?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Projekte
- MRP
Diese Frage wurde gekennzeichnet
1
Antworten
41456
Ansichten
OpenERP does not provide a mechanism specifically to log SQL queries, but it has a generic logging feature. By adding --log-level=debug_sql to the command line used to launch OpenERP it will print the normal debugging messages + the sql commands. You can redirect that output to a file if you want.
You could also configure PostgreSQL to log the queries. I would personally prefer that solution if the goal is to optimize the database usage.
my immediate goat is tracing a change, without installing the audit_trail addon. But I left the question generic since there are many cases in which this can be useful.
You can use the new auto-track feature of v7. Check _track on the object or the track_visibility attribute on fields. Example on Opportunities; if you change the value of some fields: responsible, expected revenue... it's automatically logged in open chatter (and user can follow some actions)
but where is the _track or track_visibility attibute?how to set them?
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
Registrieren| Verknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
|---|---|---|---|---|
|
0
Apr. 15
|
4787 | ||
|
0
Juni 25
|
2 | ||
|
1
Juni 23
|
17016 | ||
|
1
Jan. 22
|
3547 | ||
|
0
Nov. 21
|
4198 |
Do you specifically not want to do this in the database?
good question... It sometimes happen that I have access to the openerp config, but not as easily to the postgresql config (need to file a request to a DBA...), so something on the openerp side is preferred.