From 2ba3784ab11ab3e4d81d60c05c393c1401bcf16a Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Thu, 6 Jun 2024 14:04:31 +0700
Subject: add to job for account payment ktr

---
 import_account_payment.ktr | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'import_account_payment.ktr')

diff --git a/import_account_payment.ktr b/import_account_payment.ktr
index df47412..a8f9adb 100644
--- a/import_account_payment.ktr
+++ b/import_account_payment.ktr
@@ -556,7 +556,9 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select * from account_payment</sql>
+    <sql>select * from account_payment
+where 1=1
+and am.write_date >= (now() - '3 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
-- 
cgit v1.2.3