summaryrefslogtreecommitdiff
path: root/import_partner_one_time.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2024-05-07 17:41:57 +0700
committerstephanchrst <stephanchrst@gmail.com>2024-05-07 17:41:57 +0700
commit19aaa36b90c75a1f3cc77b55f7f8ab97648f0a61 (patch)
treee94af3a9ec0d03a74a803a8a60f3feeb9ba156d9 /import_partner_one_time.ktr
parent99e091580ddeb927685b0b9b9b80bfbdd54a45f8 (diff)
import partner with pareto status
Diffstat (limited to 'import_partner_one_time.ktr')
-rw-r--r--import_partner_one_time.ktr7
1 files changed, 6 insertions, 1 deletions
diff --git a/import_partner_one_time.ktr b/import_partner_one_time.ktr
index 31d5bfb..7cfe0e2 100644
--- a/import_partner_one_time.ktr
+++ b/import_partner_one_time.ktr
@@ -638,6 +638,11 @@
<rename>mobile</rename>
<update>Y</update>
</value>
+ <value>
+ <name>pareto_status</name>
+ <rename>pareto_status</rename>
+ <update>Y</update>
+ </value>
</lookup>
<attributes/>
<cluster_schema/>
@@ -666,7 +671,7 @@
</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, parent_id, email, phone, mobile
+kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile, pareto_status
from res_partner
--where write_date >= (now() - '5 days'::interval)</sql>
<limit>0</limit>