Sorting and Filtering

Sorting and filtering do not change or reorder the actual data in the table, but only its visible presentation.

Sorting Rows

You can sort the rows of a Data Table being edited or viewed. To enable sorting, click the column header. Clicking a header already used for sorting will reverse the sorting order.

To sort table by multiple columns, click them in a desired sort priority order while holding Ctrl key down.

Object List Sorting

If an object list is used as the data source for the editor, sorting rules update caused sorting of the whole object list rather than currently displayed records only. Thus, re-sorting may completely change currently visible records.

Filtering Rows

There are two ways to filter data in a Data Table Editor:

Using Filter Text Field

Enter some text in filter text field located in the Data Table Editor toolbar (and indicated by a looking glass icon). Table contents will be filtered to show only rows matching to the filter.

Context menu of the filter bar provides the following operations:

Column Selection

Allows to perform searching in all columns or selected columns only.

Case Sensitive

Enables case sensitive searching.

Case Insensitive

Disables case sensitive searching.

Use Wild Cards

Enables/disables wildcard search mode. Wild cards may include * or ? characters that match any characters or any character, respectively.

Use Regular Expressions

Enables/disables regular expression search mode.

Match From Start

Filter text must appear in the beginning of cell text.

Match Exactly

Filter text must exactly match cell text.

Match Anywhere

Filter text may appear anywhere in the cell text.

Using Quick Filter

Hover mouse over a column header cell and a Quick Filter icon will pop up in this cell. Click on this icon and select field values that should be shown. Records with other field values will be filtered out.

Object List Filtering

If an object list is used as the data source for the editor, filtering rules update caused filtering of the whole object list rather than currently displayed records only. Thus, new filtering rules may completely change currently visible records.

Was this page helpful?