Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Installation & Upgrade
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:43]
dlee 		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?600 |}}+{{ :bizweaver:wf_var01.png?300 |}}
  
  
Line 48: 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 |}}
  
  
Line 121: Line 121:
  
  
-====== Examples ====== 
  
-Once a variable has been created, it can be used in any subsequent workflow step. 
  
-===== User Variable Example ===== +==== Example 4 ====
- +
-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 =====+
  
 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.1727199821.txt.gz · Last modified: 2024/09/24 13:43 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