Column actions: filters | Ytria Documentation

There are multiple different filter options accessible through individual column headers. The options available are dependent on the type of column. For example, Date filters are only available on Time/Date-type columns.

NOTE	Multiple filters can be applied on the same column. Only values that meet all the specified criteria will be kept.

The filter options available for each column type are as follows:

Text	Number	Time/ Date	Checkbox
Filter Out Empty Cells	Filter Out Empty Cells	Filter Out Empty Cells	Filter Out Empty Cells
Filter By Regular Expression	Filter By Regular Expression	Filter By Regular Expression	Filter By Regular Expression
Text	Text	Text	Text
Number	Number	Date	Number
Value	Value	Time	Value
		Cutoff-Date/Time
		Value

Clear Filters

Remove all current column filters by clicking the 'Clear Filters' toolbar button , selecting it's corresponding context menu option located in the 'Grid Tools & Options' submenu, or by using Ctrl + K

TIP	See which filters are applied where at a glance by checking the column Filters Applied in the Grid Manager.

Filter Out Empty Cells

Selecting this option will remove all grid entries containing empty cells within the specified column.
This will affect grid entries whose targeted value is empty at the time of the filter being applied, whether the value is not yet loaded, or the value is missing once the full information is loaded.

general_flexygrid_column_filters1
In the example above, the value under the column Physical size for "bshepher.nsf" has not yet been loaded. Regardless of whether a value exists or not, because the value is not available at the time of applying the 'Filter Out Empty Cells' option, the cell is considered empty and the row removed from the grid.

general_flexygrid_column_filters2

Filter By Regular Expression

This filter option will let you enter a regular expression to be used as a filter on the specified column.

NOTE	See this page on regular expressions for more information about how Regular Expressions work.

NOTE

See this page on

regular expressions

for more information about how Regular Expressions work.

general_flexygrid_column_filters3

In the example above, the 'Filter By Regular Expression' option is being applied on the Database Type column. A simple text string, Domino Directory, has been entered. If 'OK' is clicked, only the entry matching that regular expression will remain in the grid.

Multiple options exist within this dialog:

'Test…': Clicking this button will open a secondary dialog where you can test your regular expression for validity.

general_flexygrid_column_filters4

TIP	You can access a quick reference guide to regular expression characters by clicking .

general_flexygrid_column_filters6

Regex History: Using these buttons, you can cycle through your list of last used regular expressions—a maximum of 100.

general_flexygrid_column_filters7

Click the button 'Show History' to show the entire current regex history. This list will be the same throughout all EZ Suite tools.

general_flexygrid_column_filters8

'Case sensitive': This checkbox will enable or disable case sensitivity.

Saved regular expression list: Here, you will have access to the list of saved regular expression list.

general_flexygrid_column_filters9

NOTE	Like the regular expression history, the saved regular expression list will populate across all EZ Suite tools. However, regular expressions saved while other sessions are open will not be visible in other tools until a new session is opened.

'OK': This will apply the regular expression as a filter on the specified column.

'Cancel': This will cancel the operation and close the dialog.

Text Filters

Text filters work on the text values in the grid. Numbers and symbols can be used.
Selecting 'Text Filters' from a column header will bring up a set of fields where you can input your desired strings. As a visual cue, the specified column header title will be automatically placed in the option name.
general_flexygrid_column_filters10

In the screenshot above, the 'Text Filters' option is selected for the column titled Database Type.

The options function as follows:

Number Filters

The logic of a number filter is based on integer order (e.g. number is greater than, number is less than). The applied cell number format will be considered.
This option is not available for Time/Date-type columns.
Selecting 'Number Filters' from a column header will bring up a set of input fields where you can enter your desired numbers:
general_flexygrid_column_filters11

In the screenshot above, the 'Number Filter' option is selected for the column titled Space Used.

The options function as follows:

Date Filters

The logic of a date filter is based on calendar date order (e.g. date is before, date is after). The applied cell date format will be considered.
Date filters are only available within Date/Time columns.
Selecting 'Date Filters' from a column header will bring up a set of fields where you can enter your desired dates:
general_flexygrid_column_filters12
In the screenshot above, the 'Date Filters' option is selected for the column Created.

The options function as follows:

Time Filters

This will apply time filters using specified times of your choice. The applied cell time format will be considered.
Time filters are only available within Date/Time columns.
Selecting 'Time Filters' from a column header will bring up a set of fields where you can enter your desired times:
general_flexygrid_column_filters13

In the screenshot above, the 'Time Filters' option is selected for the column titled Created.

The options function as follows:

Cutoff-Date/Time Filters

These filters let you specify a date prior to the current date and show only those entries whose date value in the column falls within that time range (e.g. show only the last X days).
Cutoff-Date/Time filters are only available within Date/Time columns.
Selecting 'Date Filters' from a column header will bring up a set of fields where you can enter your desired amounts of time to be considered in the filter.
general_flexygrid_column_filters14

In the screenshot above, the 'Cutoff-date/Time Filters' option is selected for the column Created.

The filters available are the following:

Entering a number in any of these fields will count back from the current date and set the cutoff date accordingly. Adding more than one of these filters will have a cumulative effect; the resulting cutoff date will be the total amount of time specified in these filter fields.

For example, setting 'Show only the last (Years)' to "2" while at the same time setting 'Show only the last (Months)' to "6" will set the cutoff date to 2 years and 6 months prior to the current date.

Value Filters

These filters will display a list of all values present in a given column. From this list, you can select any combination of these values and choose to either keep or exclude the rows containing your selected values. You can select this type of filter by clicking its menu option, or by Ctrl + M.
general_flexygrid_column_filters15
In the screenshot above, the 'Values Filters' option is selected for the column Database Type. The only two values within the column are "Domino Directory" and "Standard". If 'OK' was clicked using this current setup, only rows that contain the value "Standard" within the column Database Type will be shown in the grid.

The following additional options are available in this dialog: