diff options
| -rw-r--r-- | import_odoo_14_to_data_warehouse_manual.ktr | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/import_odoo_14_to_data_warehouse_manual.ktr b/import_odoo_14_to_data_warehouse_manual.ktr index 1519800..00a0f1c 100644 --- a/import_odoo_14_to_data_warehouse_manual.ktr +++ b/import_odoo_14_to_data_warehouse_manual.ktr @@ -443,8 +443,8 @@ <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> - <username>pdi</username> - <password>Encrypted 2be989bb20084ca95810197629d9ea18e</password> + <username>odoo</username> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -749,7 +749,8 @@ JOIN product p ON p.product_id = ml.product_id LEFT JOIN brand mf ON mf.id = p.brand_id LEFT JOIN res_partner_industry i ON i.id = rp.industry_id - WHERE m.move_type::text = 'out_invoice'::text AND m.state::text = 'posted'::text + WHERE m.move_type::text = 'out_invoice'::text AND m.state::text = 'posted'::text +AND ml.write_date between '2025-01-01' and '2025-07-12' --AND ml.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> |