diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-18 13:32:00 +0700 |
| commit | 76a5f56f324986a18ced12d01214670fdc18663e (patch) | |
| tree | 77d73102aa001cdc78c2424db76509c9c58290e7 /update_count_trx_po_product.ktr | |
| parent | 9828160c003af8915fd837f2ae4d3271387ea8e3 (diff) | |
refactor again
Diffstat (limited to 'update_count_trx_po_product.ktr')
| -rw-r--r-- | update_count_trx_po_product.ktr | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/update_count_trx_po_product.ktr b/update_count_trx_po_product.ktr index c9839aa..515f468 100644 --- a/update_count_trx_po_product.ktr +++ b/update_count_trx_po_product.ktr @@ -436,14 +436,14 @@ <notepads> </notepads> <connection> - <name>dw bi indoteknik</name> - <server>192.168.23.5</server> + <name>dw bi indoteknik (localhost)</name> + <server>localhost</server> <type>POSTGRESQL</type> <access>Native</access> <database>dw_bi_indoteknik</database> <port>5432</port> <username>odoo</username> - <password>Encrypted 2be98afc86aa7f2e4cb79ce10d196a0d5</password> + <password>Encrypted 2be98afc82bdfd8dd9a2ca45acc83f6c3</password> <servername/> <data_tablespace/> <index_tablespace/> @@ -474,11 +474,11 @@ </attribute> <attribute> <code>SUPPORTS_BOOLEAN_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>SUPPORTS_TIMESTAMP_DATA_TYPE</code> - <attribute>Y</attribute> + <attribute>N</attribute> </attribute> <attribute> <code>USE_POOLING</code> @@ -509,7 +509,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <execute_each_row>N</execute_each_row> <single_statement>N</single_statement> <replace_variables>N</replace_variables> @@ -547,7 +547,7 @@ <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <sql>select pod.product_id, pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod where pod.state = 'done' group by pod.product_id, pod.partner_id</sql> @@ -653,7 +653,7 @@ group by pod.product_id, pod.partner_id</sql> <method>none</method> <schema_name/> </partitioning> - <connection>dw bi indoteknik</connection> + <connection>dw bi indoteknik (localhost)</connection> <skip_lookup>N</skip_lookup> <commit>100</commit> <use_batch>N</use_batch> |