diff options
Diffstat (limited to 'update_count_trx_po_vendor.ktr')
| -rw-r--r-- | update_count_trx_po_vendor.ktr | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/update_count_trx_po_vendor.ktr b/update_count_trx_po_vendor.ktr index 9191fea..ab116d9 100644 --- a/update_count_trx_po_vendor.ktr +++ b/update_count_trx_po_vendor.ktr @@ -430,7 +430,7 @@ <created_date>2023/08/21 13:18:06.915</created_date> <modified_user>-</modified_user> <modified_date>2023/08/21 13:18:06.915</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -549,7 +549,7 @@ </partitioning> <connection>dw bi indoteknik</connection> <sql>select pod.partner_id, count(pod.documentno) as counter from purchase_order_dw pod -where pod.state = 'done' and pod.po_date >= (now() - '365 days'::interval) +where pod.state = 'done' group by pod.partner_id</sql> <limit>0</limit> <lookup/> |