Conditional Operators | Frontly Help Center

Operators are a way of comparing data. In Frontly, using these operators are critical to the functioning of filters (both Visible and Hidden) as well as in the set up of CRUD Permissions, and Custom Action run conditions. This article goes into detail about the use of the 'Operators' field in Frontly and the different options available.

Selecting an Operator

Choosing an operator begins with creating a condition for one of the functions mentioned above. In filter conditions, the recommended operators will always correspond to the data field types they are being compared with.

Selected operator types that don't match their data field counterparts will display an alert like the one shown below. Continuing forth with a configuration like this will likely cause issues for your data display blocks.

Note: Non-filter conditions will not show the same operator limitations, but be advised that not all recommended operators are applicable for all situations.

List of Operators

Below is the complete list of standard operator that are supported in Frontly and the data fields types that are compatible with them:

Operator	Description	Data Type(s)
Equals	Compare 2 values to ensure they are identical.	All
Does Not Equal	Compare 2 values to ensure they are not identical. The opposite of Equals.	All
Exists	Ensure a value is valid or not empty.	All
Does Not Exist	Ensure that a value is null or not set. The opposite of Exists.	All
Length Greater Than	Ensure a value's text length is greater than a certain number of characters	Text
Length Less Than	Ensure a value's text length is less than a certain number of characters.	Text
Contains	Ensure that a value contains another value Example: ✅ "John" in "John Smith" ❌ "John Patrick" in "John Smith" ✅ "03/2025" in "15/03/2025" ❌ "05/2025" in "05/03/2025"	Text, Integer, Float, Date
Does Not Contain	Ensure that a value does not contain another value. The opposite of "Contains".	Text, Integer, Float, Date
In	Ensure there's a match with a single value or a list of comma-separated values Example: ✅ "Apple, Orange, Banana" in "Banana" ❌ "Apple, Orange, Banana" in "Peach"	Text, Integer, Float
Not In	Ensure there isn't a match in a value or a list of comma-separated values. The opposite of In.	Text, Integer, Float
Is True	Ensures that the value is either one of True/TRUE/true.	True/False
Is False	Ensures that the value is either one of False/FALSE/false.	True/False
Greater Than	Ensure a value is greater than another value numerically.	Integer, Float
Less Than	Ensure a value is less than another value numerically.	Integer, Float
Date Equals	For comparing 2 dates to ensure they are the same.	Date
Date Before	For comparing 2 dates to ensure one is before the other.	Date
Date After	For comparing 2 dates to ensure one is after the other.	Date

Array Operators

Note: Not all data sources may support these array operators, and those that do may require additional setup from the integrated data source.

This section covers the selection of 'Array' operators should you toggle the 'Is Array' setting found within the 'Text' data type. The quickly define the difference between a String value or an Array / Comma-Separated one:

String:

A sequence of characters (letters, numbers, symbols) that are treated as a single data type.

Examples:
✅ Frontly

✅ abc123
✅ "Hi, this is Justin!"

Array / Comma-Separated:

A collection of elements, typically of the same data type, stored in a specific order. Each element is comma-separated and can be accessed by its index (position).

Examples:
✅ ["red", "blue", "yellow"]

✅ 1400, 8828, 1002

✅ "Is Admin", "Is User", "Is Owner"

Once a field has been established as an array, you will be presented with these new operators that can be used for filtering:

Operator	Description + Examples
Array Contains	Checks if a specific value exists within an array. Example: ✅ "Pending" in the list "Complete, Pending, To-Do".
Array Does Not Contain	Checks if a specific value is not present within an array. Example: ✅ "Cancelled" in the list "Complete, Pending, To-Do".
Array Contains Any	Checks if at least one value from a set exists within an array. Example: ✅ "Pending, Cancelled" in the list "Complete, Pending, To-Do" The result is true because "Pending" is found in the list, even though "Cancelled" is not. ❌ "Cancelled, In Progress" in the list "Complete, Pending, To-Do". The result is false because neither "Cancelled" nor "In Progress" are found in the list.
Array Contains All	Checks if all values from a group exist in a list. Example: ✅ "Pending, To-Do" in the list "Complete, Pending, To-Do" The result is true because both values are present. ❌ "Pending, Cancelled" in ""Complete, Pending, To-Do". The result is false because "Cancelled" is missing.