Illustrations for Filter Value

Introduction

When Automations Pro runs at the nodes: Update Record, Delete Record, Query Record/Records, specific records will be selected from the target form, based on the filtering conditions added at the nodes. This enables subsequent operations. The filtering logic and the filter value can vary depending on the type of the selected target field.

Here, with the Query Record node as an example, let's see how to set the filter value for a filtering condition.

Note:

1. At the three kinds of nodes mentioned above, the rules to set the filter values are the same.

2. The target form's subfields cannot be selected for a Path Condition at an Add Path node. Except that, the rules for setting filter values in a Path Condition node are the same as those at the above three nodes.

Setting Filter Value

When setting a condition for the query, you can select a Field Value at nodes, or input a Custom value, as the filter value. Also, you can set the filtering logic as is empty.

Field Value at Nodes

Note:

"Field Value at nodes" refers to the field value of records stored in the current automation's preceding nodes (including both the trigger node and action nodes). In the following passage, the concept is called "Field Value from/at a preceding node(s)".

1. How to set

To set a filtering condition is to determine the filtering logic between a target field value and a field value at a preceding node. This allows the current automation to operate on specific and reasonable target data.

2. Descriptions

a. Here are the details of the filtering logic and field types in preceding nodes that correspond to each type of target form field:

Target Form Fields	Filtering Logic	Fields in Preceding Nodes
Single Line Multi Line Radio Single Select Serial No.	equals/does not equal contains/does not contain empty/is not empty	Single Line, Single Select, Radio, Serial No., Multi Line (truncated according to the maximum length of the target form field)
Single Line Multi Line Radio Single Select Serial No.	equals any does not equal any	Single Line, Single Select, Radio, Serial No., Multi Line (truncated according to the maximum length of the target form field) Checkbox, Multi Select, SubForm (Single Line, Multi Line, Single Select, Radio)
Number	equals/does not equal greater than/greater than or equal to less than/less than or equal to is between is empty/is not empty	Number (The matching is based on values, not on the number of decimal places.)
Checkbox Multi Select	is empty/is not empty	/
Checkbox Multi Select	contains all contains any	Checkbox, Multi Select, SubForm (Single Line, Single Select, Radio)
Date&Time Created Time Updated Time	equals/does not equal greater than/greater than or equal to less than/less than or equal to is between is within is empty/is not empty	Date&Time, Created Time, Updated Time
SubFields	Same with fields	Same with fields
Member Created User	equals/does not equal is empty/is not empty	Member, Created User
Member Created User	equals any does not equal any	Member, Created User Members, SubForm (Member)
Members	is empty/is not empty	/
Members	contains all contains any	Members, SubForm (Members)
Department	equals/does not equal is empty/is not empty	Department
Department	equals any does not equal any	Department Departments, SubForm (Department)
Departments	is empty/is not empty	/
Departments	contains all contains any	Departments, SubForm (Department)
Workflow Status	equals/does not equal	Workflow Status
Image Attachment Signature	is empty/is not empty	/

Note:

1. If the filtering logic is set as equals any/does not equal any/contains all/contains any (highlighted in the above table), you can compare values in an array in the target form with those from a preceding node that are also in an array:

equals any: When the value in the target form equals any one value in the node's array
does not equal any: When the value in the target form does not equal any of the values in the node's array
contains all: When the values in the target form contain all the values in the node's array
contains any: When the values in the target form contain any one value in the node's array

2. Additionally, if the filtering logic is set as equals any/does not equal any, you can compare a target form field with a field from a preceding node that includes a single value. According to this logic, as long as the two values are equal, the condition is met.

b. If the condition(s) is set, the target form records will be filtered and retrieved based on the logic and the selected Field Value from preceding nodes. Specifically, here are the matching details for the Date&Time fields:

Date&Time Type (In the node)	Examples	Matched Date&Time Type (In the target form)	Examples	Matching Rules
YYYY-MM	2024-03	YYYY-MM YYYY-MM-DD YYYY-MM-DD HH:MM YYYY-MM-DD HH:MM:SS	2024-03 2024-03-19 2024-03-19 15:19 2024-03-19 15:19:12	Equal in YYYY-MM
YYYY-MM-DD	2024-03-19	YYYY-MM	2024-03	Equal in YYYY-MM
YYYY-MM-DD	2024-03-19	YYYY-MM-DD YYYY-MM-DD HH:MM YYYY-MM-DD HH:MM:SS	2024-03-19 2024-03-19 15:19 2024-03-19 15:19:12	Equal in YYYY-MM-DD
YYYY-MM-DD HH:MM	2024-03-19 15:19	YYYY-MM	2024-03	Equal in YYYY-MM
		YYYY-MM-DD	2024-03-19	Equal in YYYY-MM-DD
		YYYY-MM-DD HH:MM YYYY-MM-DD HH:MM:SS	2024-03-19 15:19 2024-03-19 15:19:12	Equal in YYYY-MM-DD HH:MM
YYYY-MM-DD HH:MM:SS	2024-03-19 15:19:12	YYYY-MM	2024-03	Equal in YYYY-MM
		YYYY-MM-DD	2024-03-19	Equal in YYYY-MM-DD
		YYYY-MM-DD HH:MM	2024-03-19 15:19	Equal in YYYY-MM-DD HH:MM
		YYYY-MM-DD HH:MM:SS	2024-03-19 15:19:12	Equal in YYYY-MM-DD HH:MM:SS

Custom Value

1. How to set

In setting a query condition, you can customize a value to match a certain field in the target form. This enables the accurate selection of required records.

2. Descriptions

Here are the details of customizing values that correspond to each type of target form field:

Target Form Fields	How to Set
Single Line Radio Single Select Serial No.	When the filtering logic is equals any/does not equal any, you can input multiple values, and press Enter to separate them. Under other logics, enter values directly.
Number	Enter numbers; non-number content will be seen as empty.
Date&Time	Select a date or a specific time and date from the calendar.
Member	When the filtering logic is equals any/does not equal any, you can click and select one or multiple members. Under other logics, select a certain member.
Members	Click and select one or multiple members.
Department	When the filtering logic is equals any/does not equal any, you can click and select one or multiple departments. Under other logics, select a certain department.
Departments	Click and select one or multiple departments.

Empty

In a query condition, you can set the filtering logic as is empty, allowing you to find out records with empty fields.