OdooWiki OCA HUB

SQL Export (delta support)

sql_export_delta folder_open OCA/reporting-engine open_in_new
Extra Tools License: AGPL-3

This module extends the functionality of sql_export to allow you to only export changes between export runs.

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds a Delta option to SQL exports so each run only outputs rows that are new compared to the previous export, instead of the full query result.

This module extends the existing SQL Export feature. On the SQL export form, a new Delta checkbox appears after the file format field. It can only be changed while the export is still in draft state.

When Delta is enabled and you run the export, the full query result is first saved as a temporary table in the database. The generated file then contains only the rows that are not present in the previous export run. If there is no previous run, the file contains all rows.

  • The module keeps the most recent stored result table and removes older ones automatically after each export.
  • If you change the SQL query of an export, all previously stored result tables for that export are deleted, so the next run starts fresh.
  • When the module is uninstalled, all stored delta result tables are removed.

It works together with the SQL file wizard: when you use the wizard to generate the file, the delta logic is applied automatically if the Delta option is checked on the export record. The feature touches the sql.export model and the sql.file.wizard model.

Depends on

sql_export
Models and fields (2)
  • sql.export · extends an existing modelexport_delta (Delta)
  • sql.file.wizard · extends an existing model

Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 2 confirmed, 7 with no information of 9 versions.

Sources · Odoo 16.0

Confirmed on 2026-11-03 in branch 16.0 of OCA/reporting-engine.

terminal Installation and usage

OCA documentation · Odoo 18.0

Configuration

Source · Odoo 18.0

To configure this module, you need to:

  • Go to an export in draft mode
  • Check the flag 'Delta'

No verified information in OCA: Installation, Usage.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.