diff options
| -rw-r--r-- | import_brand.ktr | 2 | ||||
| -rw-r--r-- | import_pricelist.ktr | 122 | ||||
| -rw-r--r-- | import_product_product.ktr | 2 | ||||
| -rw-r--r-- | import_purchase_order.ktr | 2 |
4 files changed, 64 insertions, 64 deletions
diff --git a/import_brand.ktr b/import_brand.ktr index cc956af..e24b1a4 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -622,7 +622,7 @@ <sql>select id, x_name, x_manufacture_level, (select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group from x_manufactures xm -where xm.write_date >= (now() - '15 days'::interval)</sql> +--where xm.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_pricelist.ktr b/import_pricelist.ktr index 68442e5..16fa89f 100644 --- a/import_pricelist.ktr +++ b/import_pricelist.ktr @@ -430,7 +430,7 @@ <created_date>2023/08/09 15:49:32.100</created_date> <modified_user>-</modified_user> <modified_date>2023/08/09 15:49:32.100</modified_date> - <key_for_session_key/> + <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> <is_key_private>N</is_key_private> </info> <notepads> @@ -545,6 +545,64 @@ </hop> </order> <step> + <name>Insert / update</name> + <type>InsertUpdate</type> + <description/> + <distribute>Y</distribute> + <custom_distribution/> + <copies>1</copies> + <partitioning> + <method>none</method> + <schema_name/> + </partitioning> + <connection>dw bi indoteknik</connection> + <commit>100</commit> + <update_bypassed>N</update_bypassed> + <lookup> + <schema>public</schema> + <table>pricelist</table> + <key> + <name>id</name> + <field>id</field> + <condition>=</condition> + <name2/> + </key> + <value> + <name>id</name> + <rename>id</rename> + <update>N</update> + </value> + <value> + <name>product_id</name> + <rename>product_id</rename> + <update>Y</update> + </value> + <value> + <name>write_date</name> + <rename>write_date</rename> + <update>Y</update> + </value> + <value> + <name>price</name> + <rename>price</rename> + <update>Y</update> + </value> + </lookup> + <attributes/> + <cluster_schema/> + <remotesteps> + <input> + </input> + <output> + </output> + </remotesteps> + <GUI> + <xloc>368</xloc> + <yloc>176</yloc> + <draw>Y</draw> + </GUI> + </step> + <step> <name>Table input</name> <type>TableInput</type> <description/> @@ -557,8 +615,8 @@ </partitioning> <connection>erp indoteknik production</connection> <sql>select ppi.id, ppi.product_id, ppi.write_date, ppi.fixed_price as price -from product_pricelist_item ppi where ppi.pricelist_id = 1 and -ppi.write_date >= (now() - '5 days'::interval)</sql> +from product_pricelist_item ppi where ppi.pricelist_id = 1 +--and ppi.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> @@ -673,64 +731,6 @@ ppi.write_date >= (now() - '5 days'::interval)</sql> <draw>Y</draw> </GUI> </step> - <step> - <name>Insert / update</name> - <type>InsertUpdate</type> - <description/> - <distribute>Y</distribute> - <custom_distribution/> - <copies>1</copies> - <partitioning> - <method>none</method> - <schema_name/> - </partitioning> - <connection>dw bi indoteknik</connection> - <commit>100</commit> - <update_bypassed>N</update_bypassed> - <lookup> - <schema>public</schema> - <table>pricelist</table> - <key> - <name>id</name> - <field>id</field> - <condition>=</condition> - <name2/> - </key> - <value> - <name>id</name> - <rename>id</rename> - <update>N</update> - </value> - <value> - <name>product_id</name> - <rename>product_id</rename> - <update>Y</update> - </value> - <value> - <name>write_date</name> - <rename>write_date</rename> - <update>Y</update> - </value> - <value> - <name>price</name> - <rename>price</rename> - <update>Y</update> - </value> - </lookup> - <attributes/> - <cluster_schema/> - <remotesteps> - <input> - </input> - <output> - </output> - </remotesteps> - <GUI> - <xloc>368</xloc> - <yloc>176</yloc> - <draw>Y</draw> - </GUI> - </step> <step_error_handling> </step_error_handling> <slave-step-copy-partition-distribution> diff --git a/import_product_product.ktr b/import_product_product.ktr index 640a1a5..d133eb3 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -697,7 +697,7 @@ pt.website_description as description, pt.weight from product_product pp join product_template pt on pt.id = pp.product_tmpl_id -where pp.write_date >= (now() - '5 days'::interval)</sql> +--where pp.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index ee85cad..03bdb75 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -680,7 +680,7 @@ get_quarter(to_char(pol.write_date::timestamp with time zone, 'MM'::text)) from purchase_order po join res_partner rp on rp.id = po.partner_id join purchase_order_line pol on pol.order_id = po.id -where pol.write_date >= (now() - '5 days'::interval)</sql> +--where pol.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |