Condition Judgment Logic Description- FineDataLink Help Document

Last update: May 13, 2025

Overview

Version

FineDataLink Version	Functional Change
4.1.1	Standardized the condition judgment logic in FineDataLink.
4.1.5.5	Applied the condition judgment logic in the File Transfer node.

Function Description

This document introduces the condition judgment logic in FineDataLink, applying to:

Data Filtering > Add Condition and Data Distribution > Distribution Condition
Conditional Branch > Add Condition and Loop Container > Execution
Condition > Configuration Condition
Jodoo Input > Filtering Condition
MongoDB Input > Conditional Query > Configure Condition
File Input > Read Folder > File Filtering
File Transfer > Read Folder > File Filtering

Description

Judgment Logic

Starting from FineDataLink 4.1.1, the condition judgment logic has been standardized.

The following table describes the details.

Field Type	Condition Type	Judgment Logic Configuration	Meaning
Date	Between	No Limit ≤ Value < No Limit (default value)	All, including null values
		No Limit ≤ Value < Y	Less than Y, excluding null values
		X ≤ Value < No Limit	Greater than or equal to X
		X ≤ Value < Y	Greater than or equal to X and less than Y
	Not Between	No Limit ≤ Value < No Limit	Empty
		No Limit ≤ Value < Y	Greater than or equal to Y
		X ≤ Value < No Limit	Less than X, excluding null values
		X ≤ Value < Y	Less than or equal to X and greater than or equal to Y, excluding null values
	Before	Value ≤ No Limit	All, including null values
	Before	Value < X	Less than X, excluding null values
	After	No Limit ≤ Value	All, including null values
	After	X < Value	Greater than X, excluding null values
	Equal To	No Limit	All, including null values
	Equal To	X	Equal to X
	Not Equal To	No Limit	All, including null values
	Not Equal To	X	Not equal to X, including null values
	Null	-	Null values
	Not Null	-	All non-null values
Text	In For details, see Differences Between In and Contain Operators.	No Limit	All data, including null and empty values
		X	If the value is in Set X, the system will return the value. (Values that are null or empty are excluded from the results.) If not, the system will return an empty value.
	Not In For details, see Differences Between In and Contain Operators.	No Limit	Empty
		X	If some elements of the value are not included in set X, the system will return the value. Values that are null or empty are included in the results.
	Contain For details, see Differences Between In and Contain Operators.	Empty	The system will return all data. (Null values are included in the results, while empty values are excluded.)
		X	If the value contains all elements of Set X, the system will return the value. (Values that are null or empty are excluded from the results.) If not, the system will return an empty value.
	Not Contain For details, see Differences Between In and Contain Operators.	Empty	Empty
		X	If the value does not contain all elements of Set X, the system will return the value. (Null values are included in the results, while empty values are excluded.)
	Begin With	Empty	All, including empty strings but excluding null values
	Begin With	X	Strings that start with X, excluding empty strings and null values
	Not Begin With	Empty	Empty
	Not Begin With	X	Strings that do not start with X, including empty strings but excluding null values
	End With	Empty	All, including empty strings but excluding null values
	End With	X	Strings that end with X, excluding empty strings and null values
	Not End With	Empty	Empty
	Not End With	X	Strings that do not end with X, including empty strings but excluding null values
	Null	-	Empty strings and null values
	Not Null	-	All, excluding empty and null strings
Value	In	No Limit	All, including null values
		X	Equal to X
		X,Y	Equal to X or equal to Y
	Not In	No Limit	Empty
		X	Not equal to X, excluding empty and null values
		X,Y	Not equal to X, and not equal to Y, excluding empty and null values
	Between	No Limit ≤ Value < No Limit	All, including null values
		No Limit ≤ Value < Y	Less than Y, excluding null values
		X ≤ Value < No Limit	Greater than or equal to X
		X ≤ Value < Y	Greater than or equal to X and less than Y
	Not Between	No Limit ≤ Value < No Limit	Empty
		No Limit ≤ Value < Y	Greater than or equal to Y
		X ≤ Value < No Limit	Less than X, excluding null values
		X ≤ Value < Y	Less than or equal to X and greater than or equal to Y, excluding null values
	Greater Than	No Limit	All, including null values
	Greater Than	X	Greater than X, excluding null values
	Less Than	No Limit	All, including null values
	Less Than	X	Less than X, excluding null values
	Greater Than or Equal To	No Limit	All, including null values
	Greater Than or Equal To	X	Greater than or equal to X, excluding null values
	Less Than or Equal To	No Limit	All, including null values
	Less Than or Equal To	X	Less than or equal to X, excluding null values
	Null	-	Null values
	Not Null	-	All non-null values
Boolean	True	-	The system will filter the database data that exactly matches the boolean character, retrieving values of true or 1.
Boolean	False	-	The system will filter the database data that exactly matches the boolean character, retrieving values of false or 0.
Others	Equal To	Empty	Empty
	Equal To	X	Equal to X, excluding null values
	Not Equal To	Empty	All, excluding null values
	Not Equal To	X	Not equal to X, excluding null values

Supported condition types may vary across different functions.

Note:

For the MongoDB Input and Judoo Input operators, unsupported field types will not be displayed during filtering.

Function	Field Type Support Status	Condition Type Support Status
Data Filtering > Add Condition Data Distribution > Distribution Condition	Supports all types.	Supports all types.
Conditional Branch > Add Condition Loop Container > Execution Condition > Configuration Condition	Field types except for Date, Text, Value, and Boolean are not supported.	Supports all types.
File Input > Read Folder > File Filtering	Supported: Text (filename) Date (file creation time and file modification time) Unsupported: Value, Boolean, and other types	Limit support: Null and Not Null are not supported for fields of text or date types.
MongoDB Input > Conditional Query > Configure Condition	Field types except for Date, Text, Value, and Boolean are not supported.	Supports all types.
Jodoo Input > Filtering Condition	Unsupported: Boolean and other types	Limit support. For details, see the following table.

Jodoo API has restrictions on judgment logic. FineDataLink supports the following condition types based on the judgment logic provided by the API.

Field Type	Supported Condition Type	Description
datetime	Equal To and Not Equal To Between (Only supports X ≤ Value ≤ Y.) Null and Not Null	-
number	Equal To and Not Equal To Between (Only supports X ≤ Value ≤ Y.) Null and Not Null	-
text	Equal To and Not Equal To In (Allows passing up to 200 items.) and Not In (Allows passing up to 200 items.) Null and Not Null	Includes single-line text, dropdown box, radio button group, and serial number.
phone	Contain Verified and Unverified Null and Not Null	Verified filters mobile numbers that have been filled in and verified. Unverified filters mobile numbers that have been filled in but not verified.
flowState	Equal To and Not Equal To	Only valid for process forms.
Others	Null and Not Null	Excludes subform fields.

Logical Operator

In the Conditional Branch and Loop Container nodes, judgment conditions are converted to logical operators for display.

Condition Type	Logical Operator
AND	&&
OR	\|\|
Equal To	==
Not Equal To	!=
Greater Than	>
Less Than	<
Greater Than or Equal To	>=
Less Than or Equal To	<=
Hierarchical Nesting	()

Example: If the judgment condition is that the parameter ${test} is not equal to 1 or greater than 2, it will be converted to the logical expression ${test}!=1||${test}>2.

Upgrade Compatibility Instruction

For FineDataLink of V4.1.1 and later versions, the condition types are described as follows:

1. Data Filtering > Add Condition and Data Distribution > Distribution Condition. Conditional Branch > Add Condition and Loop Container > Execution Condition > Configuration Condition.

Type	Pre-Upgrade - Condition Type	Pre-Upgrade - Filter Value	Post-Upgrade - Condition Type	Post-Upgrade - Filter Value
Date	Between	X-Y	Between	X < Value < Y
	Not Between	X-Y	Not Between	X < Value < Y
	Before	X	Before	Value < X
	After	X	After	X < Value
Boolean	Equal To	1\true	True
		0 or false	False
		Other values, including parameters	True
	Not Equal To	1 or true	True
		0 or false	False
		Other values, including parameters	True

2. MongoDB Input > Conditional Query > Configure Condition

Type	Pre-Upgrade - Condition Type	Pre-Upgrade - Filter Value	Post-Upgrade - Condition Type	Post-Upgrade - Filter Value
Number	Equal To	X	In	X
	Not Equal To	X	Not In	X
	Range	X-Y	Between	X < Value < Y
	Not Null		Not Null
Date	Range	X-Y	Between	X < Value < Y
	Not Null		Not Null
	Defining the date-type value: Changed Select to Date after the upgrade. MongoDB Input remains unchanged after the upgrade, still as MongoDB Input.
Text	Equal To	X	In	X
	Not Equal To	X	Not In	X
	Equal To Any	X,Y,Z	In	X,Y,Z
	Not Equal To Any	X,Y,Z	Not In	X,Y,Z
	Not Null		Not Null

3. Jodoo Input > Filtering Condition

Type	Pre-Upgrade - Condition Type	Pre-Upgrade - Filter Value	Post-Upgrade - Condition Type	Post-Upgrade - Filter Value
Date	Range	X-Y	Between	X ≤ Value ≤ Y
Number	Range	X-Y	Between	X ≤ Value ≤ Y
Text	Equal To Any	X,Y,Z	In	X,Y,Z
Text	Not Equal To Any	X,Y,Z	Not In	X,Y,Z

Helpful
Not helpful
Only read

中文（简体）

English

Condition Judgment Logic Description