Using Filters in the Master Data Selector Input Element

FieldLogs

Using Filters in the Master Data Selector Input Element

A Filter is a condition built using operators and operands.

The Master Data Selector input element is populated with Data based on the value produced by the Filter execution. It can be used to select a set of records based on some criteria.

Operators Available In Filters

There are three categories of operators available to build Filters:

Category

Operators Available

Relational Operators

These operators enable comparisons to be made. They are used in condition testing.

Operator	Operation
=	Equals
!=	Does not equal
<	Less than
>	Greater than
<=	Less than or equal to
>=	Greater than or equal to

Arithmetic Operators

These operators are used to build arithmetic expressions.

Operator	Operation
+	Addition
-	Subtraction
*	Multiplication
/	Division

Logical Operators

These operators are used to combine relational operators to build more complex conditions. The result of the operation of a logical operator is a Boolean value, either true or false.

Operator

Operation

AND

Returns a Boolean value of TRUE only if all the conditions under consideration are satisfied.

Condition 1 AND Condition2

Returns a Boolean value of TRUE if any of the conditions under consideration are satisfied.

Condition 1 OR Condition2

The NOT logical operator (!) reverses the true/false outcome of the expression that immediately follows. It is also used to negate logical variables or constants.

! Condition 1

Operands In A Filter

The operands in a Filter can be:

Constant values.
Variable values ( Variables set at the template level or step level can be referenced ).
Object values ( Values of the records in the object can be referenced ).
Expressions built using any or all of the above.

Note

Variables set at the Template level or Step level can undergo changes based on the actions performed in the previous Steps.

Using variables enables you to make a dynamic decision based on the value of the variable at the time of executing the Template.

Before using a value, you must specify the data type of the value.

The following data types are available:

Data types	Description
VALUE_STRING	Character String Value.
VALUE_NUMERICAL	Numerical Value.
VALUE_LOGICAL	Logical Value.
VALUE_REGEX	Regular Expression - A sequence of characters that specifies a search pattern in text.
VALUE_DATE	Date value.
OBJECT_VALUE	A property of the selected object.
VARIABLE_VALUE	Value of a variable set at the template or step level.
VALUE_LITERAL	System Specific Usage. Not available to use currently.

Setting Up a Filter

To set a Filter:

Click Add Filter.
These warnings will persist until the filter is set up accurately.
Note
You will see these warnings multiple times during the course of setting up the Filter. They may appear when you change the operands and / or operators.
They alert you when incompatible operands are used with an operator and ensure that a meaningful Filter is created.
Click 'OP_UNKNOWN'.
Choose an operator that suits your requirements. Here, the relational operator Less than is chosen.
Specify the data type and value of the first operand. Here, the first operand is a property of the object, BatteryVoltage.
Specify the data type and value of the second operand. Here, the second operand is a template variable, MaxVoltage.
The filter is set to choose the records that have the value of BatteryVoltage less than the value of the variable MaxVoltage. The dropdown list in the Master Data Selector step will be populated with data from these records.