summaryrefslogtreecommitdiff
path: root/import_partner.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2024-07-11 14:51:16 +0700
committerstephanchrst <stephanchrst@gmail.com>2024-07-11 14:51:16 +0700
commitc78165d60db8756628c6ffa4aabb300592f0848a (patch)
treecbbdfc99e8c2afa0bf8066ba9ccbca52177c333c /import_partner.ktr
parent0f99a02d7a0d55da370734cb92314c2e7a99cb32 (diff)
add column partner group
Diffstat (limited to 'import_partner.ktr')
-rw-r--r--import_partner.ktr7
1 files changed, 6 insertions, 1 deletions
diff --git a/import_partner.ktr b/import_partner.ktr
index aafb115..f1a1c19 100644
--- a/import_partner.ktr
+++ b/import_partner.ktr
@@ -642,6 +642,11 @@
<rename>pareto_status</rename>
<update>Y</update>
</value>
+ <value>
+ <name>group_partner_id</name>
+ <rename>group_partner_id</rename>
+ <update>Y</update>
+ </value>
</lookup>
<attributes/>
<cluster_schema/>
@@ -670,7 +675,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, pareto_status
+kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile, pareto_status, group_partner_id
from res_partner where write_date >= (now() - '5 days'::interval)</sql>
<limit>0</limit>
<lookup/>