summaryrefslogtreecommitdiff
path: root/update_count_trx_odoo.ktr
diff options
context:
space:
mode:
Diffstat (limited to 'update_count_trx_odoo.ktr')
-rw-r--r--update_count_trx_odoo.ktr8
1 files changed, 6 insertions, 2 deletions
diff --git a/update_count_trx_odoo.ktr b/update_count_trx_odoo.ktr
index 62f0d97..d212413 100644
--- a/update_count_trx_odoo.ktr
+++ b/update_count_trx_odoo.ktr
@@ -430,7 +430,7 @@
<created_date>2023/10/21 10:18:07.701</created_date>
<modified_user>-</modified_user>
<modified_date>2023/10/21 10:18:07.701</modified_date>
- <key_for_session_key/>
+ <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
<is_key_private>N</is_key_private>
</info>
<notepads>
@@ -556,7 +556,7 @@
<schema_name/>
</partitioning>
<connection>dw bi indoteknik (localhost)</connection>
- <sql>select id, count_trx_po, count_trx_po_vendor from purchase_pricelist_dw</sql>
+ <sql>select id, count_trx_po, count_trx_po_vendor, count_brand_vendor from purchase_pricelist_dw</sql>
<limit>0</limit>
<lookup/>
<execute_each_row>N</execute_each_row>
@@ -682,6 +682,10 @@
<name>count_trx_po_vendor</name>
<rename>count_trx_po_vendor</rename>
</value>
+ <value>
+ <name>count_brand_vendor</name>
+ <rename>count_brand_vendor</rename>
+ </value>
</lookup>
<attributes/>
<cluster_schema/>