diff options
Diffstat (limited to 'import_partner_one_time.ktr')
| -rw-r--r-- | import_partner_one_time.ktr | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/import_partner_one_time.ktr b/import_partner_one_time.ktr index e99f884..92901fd 100644 --- a/import_partner_one_time.ktr +++ b/import_partner_one_time.ktr @@ -648,6 +648,11 @@ <rename>group_partner_id</rename> <update>Y</update> </value> + <value> + <name>user_id</name> + <rename>user_id</rename> + <update>N</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -676,10 +681,10 @@ </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, group_partner_id +kecamatan_id, kelurahan_id, is_potential, parent_id, email, phone, mobile, pareto_status, group_partner_id, user_id from res_partner --where write_date >= (now() - '5 days'::interval) -where pareto_status is not null</sql> +where user_id is not null</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |