FlowWright provides several tools to test things outside of process execution.
You must navigate to the Administration - Tools page.
The page is rendered with Expression Evaluator UI as below.
You may click the Tools menu to navigate to the Email or SQL Query functions.
The Expression Evaluator is used to validate the C# expressions.
The Email tool validates the message's HTML content and the email function.
The SQL Query tool only validates the SQL syntax for Select statements.
Expression Evaluator tool.
Expressions are used throughout many workflow processes. Use the expression evaluation tool to test expressions to make sure expressions are defined correctly and they work. The following UI can be used to test expressions.
You must provide the variable/global reference with the default values, as below. Use the Add button to include multiple variables/globals for the expression. This tool accepts any C# format expression, including variables within these expressions. Create variables with appropriate data types and select the Add option.
You must provide the expression (or load any previous items). Click the Compute Expression button to evaluate and display the result in the box, as below.
Here are some example expressions:
34 + 45
355 / 5
Variable.num1 + Variable.num2
DateTime.Now.AddDays(5)
Click the “Save Expression” button to reuse the expression. Provide a new name and click the Save Expression button to confirm.
Reuse the expression by selecting from the dropdown list. The expression is copied to the text area.
Click on the “Compute Expression” button to see the result of your calculations.
The expression evaluator supports LINQ / LAMBDA C# expressions.
Now supports LINQ / LAMBDA C# expressions.
For example, the following example demonstrates how to concatenate 3 variable values with a comma and also handles null values.
string1 = "Apples, Bananas"
string2 = ""
string3 = "Mangoes, Oranges"
The expression syntax is as follows.
string.Join(" , ", new string[] { variable.string1, variable.string2, variable.string3 }.Where(s => !string.IsNullOrEmpty(s)))
Define the variables with values and use the above syntax in the expression to evaluate them.
Click on the (fx) icon to invoke the Expression Builder feature as a modal window inside the box marked. Use the expression builder UI to build an expression and validate it. Copy the expression to the clipboard and paste it where input is required for workflow step property (like above). Click the Clear Expression button to remove the previous expression syntax from the workspace.
Email.
Using the email test tool, test email messages can be sent to test the email configuration.
The status of the email sent is displayed in the result box.
SQL Query.
SQL tool allows the user to execute and test SQL queries by selecting the desired database connection.
You'll need to navigate to the Tools - SQL Query page.
The SQL Query UI is rendered below. You must select the connection string (preconfigured) from the drop-down list. The Table View checkbox displays the query list as a table. Provide the SQL Select query in the box and click the Execute SQL Query button to view the result. You can go ahead and reload the previous SQL Query saved through this user interface.
Provide a SQL statement and select the Execute SQL Query button to see the result.
Use the Save SQL Query button to save the SQL syntax by providing a new name. And reuse it by selecting the Load SQLQuery button.
Select the Load SQLQuery button to view the previously saved query list. Choose any query from the list, and the expression will be loaded into the text area. Select the Execute SQL Query button to see the result.
Select the Generate INSERTs button to generate SQL insert statements for the above result. The file is downloaded to the local download folder.
Use Notepad to view the SQL inserts generated by the tool. Note: It is advised that users exercise discretion when validating the insert statements before execution, as the SQL Tool is not familiar with the target table intended for data insertion.
