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 greater than 20,000” will return records where the course fees field is below above 20,000.

Less than

Number, Currency, Date

Checks if provided value is less than in selected field.

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.

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

For example, the filter “Course fees Less or Equal 20,000” will return records where the course fees field is 20,000 or below 20000.

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.

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

For example, the filter “Course Duration during "10-09-2023, 06:47 PM" to "18-09-2023, 06:47 PM" “ will return course with duration between 10th September, 2023 and 18th September, 2023.

Contains

Text, Picklist

Checks if the text field contains a specified substring.

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

For example, the filter “Account Name contains Tom “ will return accounts with name containing Tom.

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.

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

For example, the filter “Account Name Starts WithTom “ will return accounts with name starting with Tom.

Ends With

Text, Picklist

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

...

In this section, provide a value to compare or check against the selected field. You can provide a value by clicking on the gear icon.

image-20240905-062437.pngImage Added

...

Screenshot 2024-08-05 024132.pngImage Added

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

For example, you can set the Account Name to 'Enzigma'.

Screenshot 2024-08-06 165740.pngImage Modified