From a6cc1baf4f0786e76acb18bc9d21b60f73c49928 Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Tue, 19 Sep 2023 11:22:12 +0700
Subject: update price 1 to 5 without update solr flag

---
 insert_update_pricelist2.ktr | 51 ++++----------------------------------------
 1 file changed, 4 insertions(+), 47 deletions(-)

(limited to 'insert_update_pricelist2.ktr')

diff --git a/insert_update_pricelist2.ktr b/insert_update_pricelist2.ktr
index c567570..ddbc082 100644
--- a/insert_update_pricelist2.ktr
+++ b/insert_update_pricelist2.ktr
@@ -569,11 +569,6 @@
       <to>Insert / update</to>
       <enabled>Y</enabled>
     </hop>
-    <hop>
-      <from>Insert / update</from>
-      <to>Execute SQL script</to>
-      <enabled>Y</enabled>
-    </hop>
   </order>
   <step>
     <name>Add constants</name>
@@ -636,13 +631,13 @@
         <set_empty_string>N</set_empty_string>
       </field>
       <field>
-        <name>active</name>
+        <name>active_const</name>
         <type>Boolean</type>
         <format/>
         <currency/>
         <decimal/>
         <group/>
-        <nullif>true</nullif>
+        <nullif>Y</nullif>
         <length>-1</length>
         <precision>-1</precision>
         <set_empty_string>N</set_empty_string>
@@ -746,44 +741,6 @@
       <draw>Y</draw>
     </GUI>
   </step>
-  <step>
-    <name>Execute SQL script</name>
-    <type>ExecSQL</type>
-    <description/>
-    <distribute>Y</distribute>
-    <custom_distribution/>
-    <copies>1</copies>
-    <partitioning>
-      <method>none</method>
-      <schema_name/>
-    </partitioning>
-    <connection>erp indoteknik production (localhost)</connection>
-    <execute_each_row>N</execute_each_row>
-    <single_statement>N</single_statement>
-    <replace_variables>N</replace_variables>
-    <quoteString>N</quoteString>
-    <sql>update product_pricelist_item set active = 'true' where pricelist_id = 17024;</sql>
-    <set_params>N</set_params>
-    <insert_field/>
-    <update_field/>
-    <delete_field/>
-    <read_field/>
-    <arguments>
-    </arguments>
-    <attributes/>
-    <cluster_schema/>
-    <remotesteps>
-      <input>
-      </input>
-      <output>
-      </output>
-    </remotesteps>
-    <GUI>
-      <xloc>1152</xloc>
-      <yloc>272</yloc>
-      <draw>Y</draw>
-    </GUI>
-  </step>
   <step>
     <name>Filter rows</name>
     <type>FilterRows</type>
@@ -870,7 +827,7 @@
       </value>
       <value>
         <name>active</name>
-        <rename>active_1</rename>
+        <rename>active_const</rename>
         <update>Y</update>
       </value>
       <value>
@@ -1054,7 +1011,7 @@
       <method>none</method>
       <schema_name/>
     </partitioning>
-    <loglevel>log_level_basic</loglevel>
+    <loglevel>log_level_nothing</loglevel>
     <displayHeader>Y</displayHeader>
     <limitRows>N</limitRows>
     <limitRowsNumber>0</limitRowsNumber>
-- 
cgit v1.2.3