From 8881864d8489c1411ae6fa785690f64d31787aba Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Mon, 10 Jun 2024 16:30:19 +0700
Subject: add where condition

---
 import_link_po_to_inv.ktr | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

(limited to 'import_link_po_to_inv.ktr')

diff --git a/import_link_po_to_inv.ktr b/import_link_po_to_inv.ktr
index f4c5218..b45ef83 100644
--- a/import_link_po_to_inv.ktr
+++ b/import_link_po_to_inv.ktr
@@ -561,7 +561,9 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select * from account_move_purchase_order_rel</sql>
+    <sql>select * from account_move_purchase_order_rel r
+join purchase_order po on po.id = r.purchase_order_id
+where po.write_date >= (now() - '3 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
@@ -643,7 +645,9 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select * from purchase_order_stock_picking_rel</sql>
+    <sql>select * from purchase_order_stock_picking_rel
+join purchase_order po on po.id = r.purchase_order_id
+where po.write_date >= (now() - '3 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
-- 
cgit v1.2.3