odoodata-warehouse

How to track invoice/journal/lead status changes in Odoo for storing in data warehouse


I am about to build a data warehouse from an Odoo instance, I am not sure how to track the previous status of the invoices, journals, or leads. I am pulling data from the account.move but it has only the current state. I am looking for another model(table) which has the status change information.


Solution

  • account.move and crm.lead has column named message_ids which contains ids of records to mail.messenger. Each id contains state change related information and other information related to messaging.