From 644d994308d095e36c41dbf9f9834abbdecf49fe Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 23 Aug 2023 16:43:30 +0700
Subject: remove interval 365 days

---
 update_count_trx_po_vendor.ktr | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'update_count_trx_po_vendor.ktr')

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/>
-- 
cgit v1.2.3