Conditions

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

  1. Files/Folders
  2. Filenames result
  3. Previous result row

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


7

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



2

Success when

  1. If value is greater than
  2. If value is different from
  3. If value is small than
  4. If value is smaller or equal
  5. If value is greater than
  6. If value is greater than or equal
  7. If value is between
  8. If value is in list
  9. If value is not in list

3

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 ProcessesYou 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:

  1. Equal to
  2. Different from
  3. Smaller than
  4. Smaller or equal to
  5. Greater than
  6. 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 ProcessesTable 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.





      Links to better reach 

            Bot Store

             EPD