This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
bizweaver:wf_build [2024/09/19 15:04] dlee [Breakpoint] |
bizweaver:wf_build [2024/09/19 15:13] (current) dlee |
||
|---|---|---|---|
| Line 105: | Line 105: | ||
| * The “linking” line now connects the selected starting point to the new step. | * The “linking” line now connects the selected starting point to the new step. | ||
| - | ==== Manually Linking Workflow Steps ==== | + | === Manually Linking Workflow Steps === |
| * Hover over the new step, and you will see a blue “dot” icon in the lower right corner. \\ | * Hover over the new step, and you will see a blue “dot” icon in the lower right corner. \\ | ||
| Line 164: | Line 164: | ||
| Breakpoints are used during [[bizweaver: | Breakpoints are used during [[bizweaver: | ||
| - | ====== Workflow Variables ====== | + | ---- |
| - | + | **[[bizweaver:Home|Home]]** | |
| - | “Variables” are data values that are held in memory during the execution of a workflow. There are two types of variables in Bizweaver: | + | |
| - | + | ||
| - | To access these variables while in any workflow tool, press F4. This will display the variables menu flyout in the tool window. Workflow steps will be displayed on the right, appearing in the order they are in the workflow. Workflow variables will be displayed under the tool name once the tool is clicked on in the flyout alphabetical order. | + | |
| - | + | ||
| - | <WRAP center round info 80%> | + | |
| - | In Bizweaver 2.6.10 and before, the variables selector will be a separate window, but the functionality remains when selecting workflow steps and then associated variables. | + | |
| - | </ | + | |
| - | + | ||
| - | To select variables, select the desired tool, click the tool name. This will expand the list and show all available variables from that tool in alphabetical order. Double click on the variable, and it will automatically be inserted into the last place the cursor was in the tool. To close the variable flyout, press the collapse button to the top right of the panel. | + | |
| - | + | ||
| - | {{ : | + | |
| - | + | ||
| - | **User Variables** are defined by the user. These values can be defined in the **//[[bw2:using_variables|Variables tool]]//** or they can be created using the **// | + | |
| - | + | ||
| - | **Step Variables** are special references created by the Bizweaver application. Most Bizweaver workflow tools create these variables as the step is executed. An example of this would be a reference to an output column from a SQL/HANA Tool or File Reader step. | + | |
| - | + | ||
| - | Bizweaver variables are available to other workflow steps that follow the step where they are created. | + | |
| - | + | ||
| - | More information is found on the **// | + | |
| - | + | ||
| - | + | ||
| - | ======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. | + | |
| - | + | ||
| - | {{ : | + | |
| - | + | ||
| - | * **Escape:** Selecting this checkbox will enable or disable the escaping functionality. | + | |
| - | * 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. | + | |
| - | * 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. | + | |
| - | * 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 | + | |
| - | * **Replace empty values with NULL:** This will take any empty strings or blanks ex '' | + | |
| - | * This works independently of the Escape functions. | + | |
| - | + | ||
| - | ^**JSON Reserved Character** | + | |
| - | |Backspace | + | |
| - | |Form feed | + | |
| - | |Newline | + | |
| - | |Carriage return | + | |
| - | |Tab |A tab in a string | + | |
| - | |" | + | |
| - | |\ |A backslash | + | |
| - | + | ||
| - | ^**XML Reserved Character** | + | |
| - | |< |Less than sign |& | + | |
| - | |> | + | |
| - | |& | + | |
| - | |" | + | |
| - | |' | + | |
| - | + | ||
| - | ^**SQL Reserved Character** | + | |
| - | |' | + | |