Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • General Settings for Bizweaver • Introduction (Bizweaver) • business_partner_for_service_layer • Installation & Upgrade • General Settings for Bizweaver • Application Overview • SAP Business One Inventory Transfer with Bins
bizweaver:wf_var

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
bizweaver:wf_var [2024/09/24 13:38]
dlee [Using Variables] 		bizweaver:wf_var [2024/09/24 13:54] (current)
dlee [String Manipulation]
Line 12: Line 12:
   * Use drag & drop to place variable in your tool configuration.   * Use drag & drop to place variable in your tool configuration.
  
-{{ :bizweaver:wf_var01.png |}}+{{ :bizweaver:wf_var01.png?300 |}}
  
  
Line 22: Line 22:
 The **Variables** tool can establish constant/static values to be used in the following workflow steps. The **Variables** tool can establish constant/static values to be used in the following workflow steps.
  
-{{ :bw2:bizweavervartool1.png |}}+{{ :bw2:bizweavervartool1.png?600 |}} 
  
   * “Name” is the name of the variable.  This is how it is referenced in the workflow.   * “Name” is the name of the variable.  This is how it is referenced in the workflow.
Line 35: Line 36:
   * The __value__ field is blank because the value to be used will be sent in the API call to Bizweaver.   * The __value__ field is blank because the value to be used will be sent in the API call to Bizweaver.
  
-{{ :bw2:bizweavervartool2.png |}}+{{ :bw2:bizweavervartool2.png?600 |}}
  
 The variable is then referenced in a subsequent SQL: Reader step. The variable is then referenced in a subsequent SQL: Reader step.
   * Any time a variable is referenced using <F4> in a SQL step, the string must be enclosed in single quotes as shown.   * Any time a variable is referenced using <F4> in a SQL step, the string must be enclosed in single quotes as shown.
  
-{{ :bw2:bizweavervartool3.png |}}+{{ :bw2:bizweavervartool3.png?600 |}}
  
 ====Example 2===== ====Example 2=====
Line 47: Line 48:
   * In this case, the __values__ are static.  They represent login information used to access the SAP HANA Service Layer API.   * In this case, the __values__ are static.  They represent login information used to access the SAP HANA Service Layer API.
  
-{{ :bw2:bizweavervartool4.png |}}+{{ :bw2:bizweavervartool4.png?600 |}}
  
 The variables are then referenced in a subsequent WebService2 tool step as shown. The variables are then referenced in a subsequent WebService2 tool step as shown.
  
-{{ :bw2:bizweavervartool5.png |}}+{{ :bw2:bizweavervartool5.png?600 |}}
  
-===== Calculations in Variables ===== 
  
 +====Example 3=====
 +<WRAP center round tip 80%>
 Arithmetic calculations can be applied to a numeric variable during workflow execution.  Arithmetic calculations can be applied to a numeric variable during workflow execution. 
  
 A calculation using a variable is done by using the “EVAL{}” function in the “Value” of the variable. The calculation can be done against both user and step variables. The calculation is placed within the braces {} as shown in the examples. A calculation using a variable is done by using the “EVAL{}” function in the “Value” of the variable. The calculation can be done against both user and step variables. The calculation is placed within the braces {} as shown in the examples.
 +</WRAP>
  
-Everyday use of this functionality is to maintain a counter to control processing or document processing. The calculation will typically be placed inside of a loop construct. 
- 
-====Example 3===== 
 Following is a simple example of how a “counter” calculation is defined. We want to know how many records were passed into a loop from an SQLCommand step in this case. For this example, we will use a simple statement. Following is a simple example of how a “counter” calculation is defined. We want to know how many records were passed into a loop from an SQLCommand step in this case. For this example, we will use a simple statement.
  
Line 121: Line 121:
  
  
-====== Examples ====== 
- 
-Once a variable has been created, it can be used in any subsequent workflow step. 
- 
-===== User Variable Example ===== 
- 
-In a Bizweaver workflow, a user can reference variables initiated earlier in the workflow using the variables selector. In this example, a SQL statement is being used to pull information from the database. We want to limit the data based on a certain value. In this example, a value from the “Variables” step is used. 
- 
-When processed, the below workflow will only pull the CardType of "C," set in the "Variables_Init" step. 
- 
-{{ :bw2:bizweavervartool11.png |}} 
- 
-In the variables tool, there is a **User-Defined Variable ** of "UserVariable1." 
- 
-{{ :bw2:bizweavervartool12.png |}} 
- 
-In the SQL tool step, you can reference the **User-Defined Variable** of "UserVariable1" by pressing [F4] in the SQL tool, navigating to the left menu, and selecting the correct Variables option variable from the list of variables on the right menu. 
- 
-{{ :bw2:bizweavervarmanager2.png |}} 
- 
-So, the SQL statement now uses the value ‘C’ in the variable “UserVariable1.” 
- 
-{{ :bw2:bizweavervartool14.png |}} 
  
-Since the variable value ‘C’ is a string (text), the variable name must be enclosed in single quotes as required by SQL. 
  
-===== Step Variable Example =====+==== Example 4 ====
  
 In this example, we are writing the output of the SQL step to a file. In this example, we are writing the output of the SQL step to a file.
Line 161: Line 137:
 Next, you will press [F4] and select the SQL step variables when going to the file writer step. Next, you will press [F4] and select the SQL step variables when going to the file writer step.
  
-{{ :bw2:bizweavervarmanager3.png |}}+{{ :bizweaver:wf_var02.png |}}
  
 You can see each step variable in the "Body" section of the FileWriter Tool. You can see each step variable in the "Body" section of the FileWriter Tool.
Line 170: Line 146:
 =====String Manipulation===== =====String Manipulation=====
  
-Starting in Bizweaver 2.7.2, the functionality to modify variables was introduced. This allows a user to manipulate all variables that are inserted in a specific step.+This allows a user to manipulate all variables that are inserted in a specific step and is accessed by pressing F4
  
-{{ :bw2:bizweavervarmanager1.png |}}+{{ :bizweaver:wf_var03.png |}}
  
   * **Escape:** Selecting this checkbox will enable or disable the escaping functionality.   * **Escape:** Selecting this checkbox will enable or disable the escaping functionality.
bizweaver/wf_var.1727199519.txt.gz · Last modified: 2024/09/24 13:38 by dlee

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