General Overview

Ondexx uses Excel-style filters on data grids, commonly found in different reports and lists through the platform. These filters can be incredibly useful and powerful when used properly.

There are two types of filters used within Ondexx. While similar, they have slightly different functions.

Filter Type 1

This is the simpler of the two filter types, and displays as an empty text input at the top of each column. By using the text input and selecting a filter using the funnel icon, you can filter by the contents of the column.

Available Filters

• NoFilter
  • This turns the filter off.
• Contains
  • This only displays rows that contain your input in this column. This will also display partial matches.
  • Example: “Work” will show rows containing both “Work” and “Worker” in this column.
• DoesNotContain
  • This will display rows that do not contain your input this column. This also applies to partial matches.
  • Example: “Work” will not display rows with “Work” or “Worker” in this column.
• StartsWith
  • This will display rows that begin with your input in this column.
  • Example: “Work” will display rows with “Work” and “Worker” in this column, but will not display rows with “Construction Worker”.
• EndsWith
  • This will display rows that end with your input in this column.
  • Example: “Work” will display rows with “Work” in this column, and “Construction Work,” but will not display rows with “Worker”.
• EqualTo
  • This will display rows that exactly match your input in this column.
  • Example: “Work” will display rows with “Work” in this column, but will not display rows with “Worker” or “Construction Work”.
• NotEqualTo
  • This will display rows that do not exactly match your input in this column.
  • Example: “Work” will not display rows containing “Work,” but will display rows containing “Worker” or “Construction Work”.
• GreaterThan
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than your input in this column.
  • Example: “10” will display rows that withrows with “15” in this column, but will not display rows with “5” or “10” .
• LessThan
  • This field only applies to numerical and date-based columns.
  • This will display rows that are less than your input in this column.
  • Example: “10” will display rows that with “5” in this column, but will not display rows with “15” or “10”.
• GreaterThanOrEqualTo
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than or equal to your input in this column.
  • Example: “10” will display rows that with “15” or “10” in this column, but will not display rows with “5”.
• LessThanOrEqualTo
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than your input in this column.
  • Example: “10” will display rows that with “5” or “10” in this column, but will not display rows with “15”.
• IsEmpty
  • This field will display rows that are empty in this column. This field does not require a text input.
• NotIsEmpty
  • This field will display rows that are not empty in this column. This field does not require a text input.
• IsNull
  • This field will display rows that are empty in this column. This field does not require a text input.
• NotIsNull
  • This field will display rows that are not empty in this column. This field does not require a text input.

Unavailable Filters

The following filters are not in use by Ondexx:

• Between
• NotBetween

Filter Type 2

These filters are more complicated, and have more options. These filters can be found by clicking the three vertical dots next to the column headers.

Sorting Options

These options can also be toggled by clicking the column header you wish to sort.

• Sort Ascending
  • This sorts rows alphabetically by this column.
  • For numerical columns, this sorts rows from least to greatest.
• Sort Descending
  • This sorts rows reverse-alphabetically by this column.
  • For numerical columns, this sorts rows from greatest to least.
• Clear Sorting
  • This resets sorting to default.

Grouping Options

This allows you to group rows together if they contain the same content in the column you choose. These can be combined with other sorting options, and use other columns.

• Group By
  • This groups all rows by this column, showing rows indented in a collapsible Group if they share the same content in this column.
• Ungroup
  • This removes the grouping.

Columns

This allows a user to choose which table columns they want to be shown.

Filters

These filters work similarly to Filter #1, by using a text input, and selecting the type of filter you would like to apply. Using the second filter, you can have two filters active at once.

• NoFilter
  • This turns the filter off.
• Contains
  • This only displays rows that contain your input in this column. This will also display partial matches.
  • Example: “Work” will show rows containing both “Work” and “Worker” in this column.
• DoesNotContain
  • This will display rows that do not contain your input this column. This also applies to partial matches.
  • Example: “Work” will not display rows with “Work” or “Worker” in this column.
• StartsWith
  • This will display rows that begin with your input in this column.
  • Example: “Work” will display rows with “Work” and “Worker” in this column, but will not display rows with “Construction Worker”.
• EndsWith
  • This will display rows that end with your input in this column.
  • Example: “Work” will display rows with “Work” in this column, and “Construction Work,” but will not display rows with “Worker”.
• EqualTo
  • This will display rows that exactly match your input in this column.
  • Example: “Work” will display rows with “Work” in this column, but will not display rows with “Worker” or “Construction Work”.
• NotEqualTo
  • This will display rows that do not exactly match your input in this column.
  • Example: “Work” will not display rows containing “Work,” but will display rows containing “Worker” or “Construction Work”.
• GreaterThan
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than your input in this column.
  • Example: “10” will display rows that with “15” in this column, but will not display rows with “5” or “10” .
• LessThan
  • This field only applies to numerical and date-based columns.
  • This will display rows that are less than your input in this column.
  • Example: “10” will display rows that with “5” in this column, but will not display rows with “15” or “10”.
• GreaterThanOrEqualTo
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than or equal to your input in this column.
  • Example: “10” will display rows that with “15” or “10” in this column, but will not display rows with “5”.
• LessThanOrEqualTo
  • This field only applies to numerical and date-based columns.
  • This will display rows that are greater than your input in this column.
  • Example: “10” will display rows that with “5” or “10” in this column, but will not display rows with “15”.
• IsEmpty
  • This field will display rows that are empty in this column. This field does not require a text input.
• NotIsEmpty
  • This field will display rows that are not empty in this column. This field does not require a text input.

Unavailable Options

The following options are not in use by Ondexx:

• Aggregates