Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Operator

Supported Field Types

Description

Greater than

Number, Currency, Date

Checks if provided value is greater than in selected field.

Less than

Number, Currency, Date

Checks if provided value is less than in selected field.

Panel
panelIconId1f5e8
panelIcon:speech_left:
panelIconText🗨️
bgColor#F4F5F7

For example, the filter “Course fees less than 20,000” will return records where the course fees field is below 20,000.

Equal

Number, Currency,Date,Text, Boolean, Picklist

Checks if the value of a field is equal to a specified value.

Panel
panelIconId1f5e8
panelIcon:speech_left:
panelIconText🗨️
bgColor#F4F5F7

For example, the filter “Course fees Equals 20,000” will return records where the course fees field is 20,000

Not Equal

Text, Number, Currency, Date, Boolean, Picklist

Checks if the value of a field is not equal to a specified value.

Less or Equal

Number, Currency, Date

Checks if the value of a field is less than or equal to a specified value.

Greater or Equal

Number, Currency, Date

Checks if the value of a field is greater than or equal to a specified value.

During

Date

Checks if the date value of a field falls within a specified range.

Contains

Text, Picklist

Checks if the text field contains a specified substring.

Does Not Contain

Text, Picklist

Checks if the text field does not contain a specified substring.

Starts With

Text, Picklist

Checks if the text field starts with a specified substring.

Ends With

Text, Picklist

Checks if the text or picklist field ends with a specified substring.

...