Tools

Last published at: May 14th, 2024

FlowWright provides a couple of different tools to test things outside of process execution. 

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:  

This tool accepts any C# format expression including variables within these expressions.  Here are some example expressions:

34 + 45

355 / 5

Variable.num1 + Variable.num2

DateTime.Now.AddDays(5) 

Expression evaluator supports LINQ / LAMBDA C# expressions

The new version 9.10 supports LINQ / LAMBDA C# expressions.

e.g: The following example demonstrates how to concantenate 3 variable values with comma and also handle null values.

string1 = "Apples, Bananas"

string2 = ""

string3 = "Mangoes, Gauvas"

The expression syntax is as follows.

string.Join(" , ", new string[] { variable.string1, variable.string2, variable.string3 }.Where(s => !string.IsNullOrEmpty(s))) 

Email test tool

Using the email test tool, test email messages can be sent to test the email configuration.

SQL query tool

SQL tool allows the user to execute and test SQL queries by selecting the desired database connection. The UI is as shown below: