diff options
Diffstat (limited to 'import_partner.ktr')
| -rw-r--r-- | import_partner.ktr | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/import_partner.ktr b/import_partner.ktr index 3dfa132..4e8c277 100644 --- a/import_partner.ktr +++ b/import_partner.ktr @@ -627,6 +627,21 @@ <rename>parent_id</rename> <update>Y</update> </value> + <value> + <name>email</name> + <rename>email</rename> + <update>Y</update> + </value> + <value> + <name>phone</name> + <rename>phone</rename> + <update>Y</update> + </value> + <value> + <name>mobile</name> + <rename>mobile</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> @@ -654,7 +669,8 @@ <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, parent_id + <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 from res_partner where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> |