Conditions
Conditions
Check Webservice availability
Description
Check Webservice availability is a Process Entry in the Conditions Plugin for Process Studio Processes. Check Webservice availability Process Entry checks if a given URL (e.g. a Webservice URL) is valid, can be connected to and data can be read from it. If it connects within the given timeout and data can be read, it returns 'true', else 'false'.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
URL
Specifies the URL to validate.
3
Connect timeout (ms)
The connect timeout in ms. The value is depending on the quality of service of this URL and experiences.
4
Read timeout (ms)
After connection, the process entry tries to read data. This value gives the read timeout in ms. The value is depending on the quality of service of this URL and experiences.
Check files locked
Description
Check files locked is a Process Entry in the Conditions Plugin for Process Studio Processes. This process entry goes over a list of files to see if they are locked by another process. This is verified by renaming a file to the same name as before. On some operating systems (MS Windows systems in particular) this operation fails if the file is locked.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Settings: Include subfolders
Enable this option to also check files in subfolders of specified folders
3
Settings: Copy previous results to args?
Pass the result rows of a previous process entry execution to the files list of this entry.
4
Files/Folders
Here you can list a series of files or folders with wildcards. The wildcards are Java Regular expressions. For instance .*\.txt would check any file with a .txt extension.
Please note that you can use the Delete/Edit buttons to edit the list.
You can also use the File/Folder and Wildcard entries right above the list to add new entries, browse for files and so on.
Columns exist in a table
Description
Columns exist in a table is a Process Entry in the Conditions Plugin for Process Studio Processes. This process entry verifies that one or more specified columns exist in a database table.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Connection
The database connection to use
3
Schema name
The schema of the table to use
4
Table name
The name of the table to use
5
Columns
The list of column names to verify (one or more)
Wait for
Description
Wait for is a Process Entry in the Conditions Plugin for Process Studio Processes. You can use the Wait for Process Entry to wait for a delay time before running the next process entry.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Wait for
The delay to wait
3
Unit time
Specify the unit time (second, minute and hour)
Evaluate files metrics
Description
Evaluate files metrics is a Process Entry in the Conditions Plugin for Process Studio Processes. Evaluate files/folders total size or files/folders count in a given path.
Configurations
General Tab
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
Settings:
1
Source files
2
Wildcard
Wildcard is active if “Filenames result” is chosen above.
3
File Result field
This field is active if “Previous result row” is chosen above. Result rows field that contains file/folder name.
4
Wildcard result field
This field is active if “Previous result row” is chosen above. Result rows field that contains wildcard.
5
Include subfolders result
This field is active if “Previous result row” is chosen above. Result rows field that contains include subfolders information.
6
Evaluate
Files/Folders
Filenames ResultPrevious Results Row7
File/Folder source
If “Files/Folders” is chosen in Source files above this field and the following fields are active. Select the Files/Folders to evaluate metrics.
8
Wildcard
Filter Files/Folders using wildcard.
Files/Folders:
This tabular section contains all the Files/Folders chosen above.
1
File/Folder source
The File/Folder
2
Wildcard
The wildcard applied to filter files/folders
3
Include subfolders
Select Y/N to include or exclude subfolders
Advanced Tab
No.
Field Name
Description
Success on:
1
Scale
In terms of Bytes, KBytes, Mbytes, GBytes
If value is greater than
If Value is different fromIf Value is Smaller thanIf value is smaller or equalIf Value is greater thanIf Value is greater than or equalIf value is betweenIf value is in listIf value is not in list3
Value
Provide a value for the item selected above.
Check Db Connections
Description
Check Db Connections is a Process Entry in the Conditions Plugin for Process Studio Processes. This process entry allows you to verify connectivity with one or several databases within a given Wait time.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Connection
List of connections.
3
Wait
After the connection was opened, wait x (s, min, hrs).
4
Units of Time
Specify the unit of measurement for the length of time to remain connected.
5
Get connections
Get available connects.
File Exists
Description
File Exists is a Process Entry in the Conditions Plugin for Process Studio Processes. File Exists process entry to verify that a specified file exists on the server on which Process Studio is running. You must provide the file name. Process Studio returns a True or False value depending on whether or not the file exists.
The File Exists process entry result could be a trigger or signal to launch a workflow or process.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. .
2
Filename
The name and path of the file to check for.
Evaluate rows number in a table
Description
Evaluate rows number in a table is a Process Entry in the Conditions Plugin for Process Studio Processes. You can get the number of rows in a target table by connecting to the table or you can write a custom SQL statement to get the number of rows. You can you evaluate the number of rows and branch the process based on the evaluation.
Configuration
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Connection
Name of the database connection on which the target table resides.
3
Target schema
The name of the Schema for the table to write data to.
4
Target table name
Name of the target table.
Success Condition:
1
Success when rows count
For the success condition you can check the number of rows if they are:
- Equal to
- Different from
- Smaller than
- Smaller or equal to
- Greater than
- Greater or equal to
2
Limit
Give a numerical limit for the conditions above.
Custom SQL:
1
Custom SQL
Check this option when you want to specify a custom SQL statement in the below field
2
Use variable substitution
Variables in the SQL statements will be substituted.
3
Clear list of result rows
Clears the internal list of result rows before executing.
4
Add rows to result
Adds all rows returned from the SQL statement within the internal list of result rows. This list of result rows can then be used in subsequent process entries to loop over or e.g. within a workflow by the Get rows from result step.
Checks if files exist
Description
Checks if files exist, is a Process Entry in the Conditions Plugin for Process Studio Processes. Checks if files exist can be used to check for existence of one or more files/folders.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
File/folder name
Browse file/folder and “ADD”
Files/Folders:
This is a tabular section.
1
File/folder
Shows all the files/folders chosen and added above.
Check if a folder is empty
Description
Check if a folder is empty is a Process Entry in the Conditions Plugin for Process Studio Processes. This process entry checks if a folder is empty i.e. there are no regular files or sub-folders in the folder.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Folder name
The name of the folder to verify for emptiness.
3
Limit search to
Limits the search for files to those with a certain wildcard (regular expression)
4
Wildcard
The wildcard (regular expression) to limit the files to look for with, for example: .*\.txt$
Simple evaluation
Description
Simple evaluation is a Process Entry in the Conditions Plugin for Process Studio Processes. Simple evaluation evaluates the contents of a variable or a field in the result stream (If the result stream has multiple rows, the first row will be evaluated.). You can draw a main hop and an error handling hop from this step to handle true or false results of Simple Evaluation.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
Evaluate
Select this to evaluate a ‘variable set before’ or ‘Field from previous result’.
Source:
1
Evaluate
Choose ‘variable set before’.
2
Variable name
Enter the variable name using the usual syntax
3
Type
The type of your variable
Success On:
4
Success when variable set
When this option is selected, the true path is followed when the variable is set.
Note: The process entry checks if the variable is defined, so an empty or null value is also true. When testing this within Process Studio you need to delete the line with the variable in the variables section of the Execute a process window. And remember: Once this variable is set, the variable keeps existing, even when deleting it from the list.5
Success condition
Select the condition to be met for a successful result.
6
Value
Value to compare the variable to.
Source:
1
Evaluate
Field from previous result
2
Field name
Enter the field name from the result row
3
Type
The type of your field
Success On:
4
Success condition
Select the condition to be met for a successful result (Equal/Non equal/etc.)
5
Value
Value to compare the field to
Table exists
Description
Table exists is a Process Entry in the Conditions Plugin for Process Studio Processes. Table Exists process entry checks if a specified table exists on a database. You must provide a connection and the table name. Process Studio returns a True or False value depending on whether or not the table exists.
Note: This process entry performs one check and then moves on. If you want to poll until the tables appear, use Evaluate rows number in a table process entry which has a polling interval parameter.
Configurations
No.
Field Name
Description
1
Process Entry name
Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
2
Connection
The name of the connection to connect to the database.
3
Schema name
The table's schema name.
4
Table name
The table name to check for existence.