From b36b5e0d5642f5888912e14b8b5424406935769d Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Wed, 8 Nov 2023 16:11:53 +0700
Subject: add state, kota, kecamatan, kelurahan

---
 import_partner.ktr | 23 ++++++++++++++++++++++-
 1 file changed, 22 insertions(+), 1 deletion(-)

(limited to 'import_partner.ktr')

diff --git a/import_partner.ktr b/import_partner.ktr
index 6c425ba..e0afc98 100644
--- a/import_partner.ktr
+++ b/import_partner.ktr
@@ -597,6 +597,26 @@
         <rename>industry_id</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>state_id</name>
+        <rename>state_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>kota_id</name>
+        <rename>kota_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>kecamatan_id</name>
+        <rename>kecamatan_id</rename>
+        <update>Y</update>
+      </value>
+      <value>
+        <name>kelurahan_id</name>
+        <rename>kelurahan_id</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -624,7 +644,8 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select id, name, display_name, active, email, industry_id from res_partner where write_date >= (now() - '5 days'::interval)</sql>
+    <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id
+from res_partner where write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
     <execute_each_row>N</execute_each_row>
-- 
cgit v1.2.3