diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-03-20 13:19:14 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-03-20 13:19:14 +0700 |
| commit | 777684cd8c82576b0cbb9c445ecc029e340c732c (patch) | |
| tree | 1260f2cf0d027306e2b7cb1db4ce9e1907bf14f5 /update_count_trx_odoo.ktr | |
| parent | 4edb1c664a3716a6c153200c9d788819e5f0d070 (diff) | |
update pricelist
Diffstat (limited to 'update_count_trx_odoo.ktr')
| -rw-r--r-- | update_count_trx_odoo.ktr | 8 |
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/> |