Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Using Variables)
bw2:using_variables

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bw2:using_variables [2023/12/18 16:40]
wgates [Variables Tool] 		bw2:using_variables [2023/12/19 09:02] (current)
wgates
Line 71: Line 71:
 {{ :bw2:bizweavervartool7.png |}} {{ :bw2:bizweavervartool7.png |}}
  
-The “SQLCommand_getData” step reads a list of data records. This list feeds into a loop.+The “SQLCommand” step reads a list of data records. This list feeds into a loop.
  
 <code> <code>
-Select  +SELECT 
-     (recordNumber) -- This will be a record number from your table that you are using +     [recordNumber] -- This will be a record number from your table that you are using 
-From +FROM 
-    (your table) -- table you are pulling the recordNumber from+    [yourTable] -- table you are pulling the recordNumber from
 </code> </code>
  
Line 92: Line 92:
 {{ :bw2:bizweavervartool9.png |}} {{ :bw2:bizweavervartool9.png |}}
  
-This type of processing could be used in conjunction with a **//[[bw2:decision_tool#Decision Tool|Decision Tool]]//** such that processing would go in one direction or another based on the number of records found. 
  
 ====== Step Variables ====== ====== Step Variables ======
Line 104: Line 103:
 The step named “SQL Command_getData” uses the SQL statement: The step named “SQL Command_getData” uses the SQL statement:
  
-<code sql>select +<code sql>SELECT CardCode,  
-t0.CardCode, t0.CardName, t0.CardType +   CardName,  
-from OCRD t0+   CardType 
 +FROM OCRD
 </code> </code>
  
 This produces a list of records that feeds into the loop “Loop_ProcessRecords.” The step variable created for “CardCode” is: This produces a list of records that feeds into the loop “Loop_ProcessRecords.” The step variable created for “CardCode” is:
  
-<code>WorkFlow(SQLCommand_getData).Get({FIELD_CardCode})</code>+<code>WorkFlow(SQLCommand).Get({FIELD_CardCode})</code>
  
 This step variable is used in the FileWriter_VariableTest step. This step variable is used in the FileWriter_VariableTest step.
Line 195: Line 195:
     * Only one of these can be selected at once, and they only apply in the step in which they are enabled.     * Only one of these can be selected at once, and they only apply in the step in which they are enabled.
     * **JSON:** Selecting this will escape reserved characters for a JSON file. See the table below for more information.     * **JSON:** Selecting this will escape reserved characters for a JSON file. See the table below for more information.
-      * This will generally be used in a Databuilder step  
     * **XML:** Selecting this will escape any reserved characters for an XML file. See the table below for more information.     * **XML:** Selecting this will escape any reserved characters for an XML file. See the table below for more information.
-      * This will generally be used in a Databuilder step 
     * **SQL:** Selecting this will escape reserved characters for SQL Server see table below for more information     * **SQL:** Selecting this will escape reserved characters for SQL Server see table below for more information
   * **Replace empty values with NULL:** This will take any empty strings or blanks ex '' and replace it with NULL   * **Replace empty values with NULL:** This will take any empty strings or blanks ex '' and replace it with NULL
bw2/using_variables.1702935614.txt.gz · Last modified: 2023/12/18 16:40 by wgates

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki