Conditions

Overview

A condition consists of a field, an operator, and a value. Conditions determine which transactional records are selected for processing. Complex conditions can be crafted for rules that incorporate multiple conditions, using AND or OR operators to connect them.

Field

Field values populate according to the transaction table chosen from the drop-down list in the General Details tab, from where you can select the necessary option.

Dot Walking

The Dot walking concept helps us to traverse from one table to another table based on the data source of the field selected from the table in the general details screen. Usually, conditions can be set on properties connected to the parent table and related tables alike. 

The concept is available for users who want to define conditions on the attributes of the parent table. The Dot Walking concept is applicable in all the below scenarios.  

• Within the same table
• Main table to another associated table
• Main table to multiple associated tables

Dot walking is the process of using the dot notation to navigate from the parent table to the associated tables. It is easy to move from one table to another with dot walking. It decides which operators should be loaded and what values to take into account based on the types of fields. The operator would load based on the data type of the last node in dot walking. 

Figure: Condition stepper

Figure: Condition stepper - Dynamic

For more information related to Dot-walking concept, refer Dot-walking.

Operator

The operators will be displayed based on the selected field value. Select the required operator from the drop-down list. The possible values for operators are as shown below. 

When the Data Type is String

Consider the example where the user has selected the Description field, then under the Conditions, the Operators loaded will be related to the Textbox values.

When Data Type is Numeric

 Consider the example where the user has selected the Numeric field, then under the Conditions, the Operators loaded will be related to the Numeric values.

Note

There is a provision to set multiple input in the values field by adding a comma separator when the operator is selected as is one of / is not one of . For example, when we want to search Incident ID, we can use the following operators is one of / is not one of to give values separated by commas. For more information, refer to the image below.

When Data Type is Date 

Consider the example where the user has selected the Date field, then under the Conditions, the Operators loaded will be related to the Date values.

As illustrated below, the "Date control" operator function allows multiple conditions to be set on the conditions page. The operators that can be used in this scenario are: 

• Is more than 
• Is less than

Figure: Date Control

When Data Type is Boolean

Consider the example where the user has selected the Field as Is Active under Conditions, then the Operator will be Is and Value as shown below.

Figure: When Data Type is Boolean

Value	Implication
	Yes
	No

Dynamic Operator

Tables in a user interface or an application's backend that can alter their content easily in response to events, user input, or data modifications are referred to as dynamic tables. We can create dynamic groups and admin tables to which the dynamic conditions can apply.  Because of these tables' extreme flexibility and adaptability, developers may design interfaces that support a wide range of data types and user needs or interfaces that can adapt to different user needs and data formats. 

The "Dynamic" operator function can be used to map the dynamic tables in the scheduler. When we select the Dynamic operator, we get two drop-down. The first drop-down is to select Dynamic groups/Admin Table and the second drop-down is to select the fields of the table selected. For more information refer the image below. 

For more information on the Dynamic concept in Schduler, refer Dynamic Scheduler

• When Dynamic tables are selected in the condition stepper, all the Admin tables will appear grouped under Admin Table, whereas only those Dynamic groups will appear which belong to the Transaction table (Based on the table on which the Scheduler is being configured, the Admin Table/Dynamic Group should point to the same data source).  The selection of Field/Table points to the same data source (screenshot). 

Grouping of Conditions

When there are multiple conditions which need to be computed together, these conditions can be grouped together in a Scheduler. This can be achieved by using the AND/OR conditions and by using the grouping functionality provided in the tool.

Figure: Grouping of Conditions

Value

Based on the selected Field type and Operator the options are populated in the Value field.

The value field can be one of the following four types: 

1. Date: Represents a calendar date. This can be used for inputting or displaying dates in various formats (e.g., MM/DD/YYYY or YYYY-MM-DD). In programming, date-related operations and formatting are commonly used for managing time-sensitive data.
   
   
2. Dropdown: A dropdown, also known as a drop-down menu or list, is a user interface element that allows users to select one option from a list of available options. This is often used when you have a predefined set of choices, and the user can choose one from the list.
   
   
3. Numeric: Refers to numerical data, including integers and floating-point numbers. Numeric input is used when you need users to enter numerical values, such as quantities, amounts, or any other numeric data. Validation is typically applied to ensure that only valid numeric input is accepted.
   
   
4. String: Represents a sequence of characters. String input is used for text-based data, such as names, addresses, or any other textual information. It's a versatile data type that can accommodate a wide range of alphanumeric characters.