From 3cb5193b5e9fdbb38d387b99d88e51847aef34f7 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Thu, 16 Nov 2023 11:58:43 +0700
Subject: add import parent id in partner

---
 import_partner.ktr | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'import_partner.ktr')

diff --git a/import_partner.ktr b/import_partner.ktr
index 1ecc7ea..3dfa132 100644
--- a/import_partner.ktr
+++ b/import_partner.ktr
@@ -622,6 +622,11 @@
         <rename>is_potential</rename>
         <update>Y</update>
       </value>
+      <value>
+        <name>parent_id</name>
+        <rename>parent_id</rename>
+        <update>Y</update>
+      </value>
     </lookup>
     <attributes/>
     <cluster_schema/>
@@ -649,7 +654,7 @@
       <schema_name/>
     </partitioning>
     <connection>erp indoteknik production (localhost)</connection>
-    <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential
+    <sql>select id, name, display_name, active, email, industry_id, state_id, kota_id, kecamatan_id, kelurahan_id, is_potential, parent_id
 from res_partner where write_date >= (now() - '5 days'::interval)</sql>
     <limit>0</limit>
     <lookup/>
-- 
cgit v1.2.3