diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2025-07-11 18:57:24 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2025-07-11 18:57:24 +0700 |
| commit | 5973582807d21d4b8b7591e008ef7b34e1fe4e16 (patch) | |
| tree | 2dc344e5dad94d5ba8e4dd2865577ff1770bc703 | |
| parent | d0749d998c9ce432e3378425e54bfa8a0fa86cff (diff) | |
uodate manual
| -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/> |