View, filter, and sort table data

You can view table data in the Workato UI. The data table interface enables you to filter, sort, and hide/display column data.

By default, the interface displays the first 200 (two hundred) records of the data table. Workato loads additional pages automatically as you scroll through the table.

Filter

Create custom filters to organize your data. The types of available filters depend on the data type of the filtered column. You can add multiple filters. All filters are chained using AND.

User-generated filters are case-sensitive.

Filter records with multiple filters

To create a filter:

1

Click + Add filter.

2

Select a column to filter.

3

Select the type of filter.

4

Enter a value.

5

Click ✓ (check mark).

Available operands

Reference our column types documentation for a list of available operands.

Sort

Sort data in ascending or descending order by sorting an individual column.

If you sort one column and then an additional column, the most recent sort selection is applied, overriding the first sorting selection.

Sort column data

Multi-value columns cannot be sorted. You can only sort single-value column types, such as text, number, date, and boolean.

Complete the following steps to sort column data:

1

Choose the column you plan to sort.

2

Next to the column name, click ... (ellipsis).

3

Select Sort descending or Sort ascending.
You can reverse the sort direction by clicking the ↑(arrow) next to the column name (optional).

Sort descending

Sorts column data in descending order.
For example, it sorts text fields in reverse alphabetical order, numeric fields from the highest number to the lowest, and date fields from most recent to most remote. Null values appear at the bottom of the sorted column.

Sort ascending

Sorts column data in ascending order.
For example, it sorts text fields in alphabetical order, numeric fields from the lowest number to the highest, and date fields from the most remote past to current time. Null values appear at the top of the column.

Hide and display columns

You can hide or display columns in your table. By default, Workato hides all auto-generated columns.

Learn more about auto-generated columns.

Select/deselect column names to display/hide columns

When you hide columns in the table, Workato informs you of this by updating the numerical value in the Hide columns button. For example, when you create a new table, this button reads 3 hidden columns, referencing the three auto-generated columns that Workato hides by default. When you hide additional columns, Workato updates this button.

If you choose not to hide any columns, Workato displays this button as Hide columns.

To hide or display a column:

1

Click Hide columns/X columns hidden.

2

Workato displays a list of columns.

3

Hide a column by deselecting the column name.
Conversely, to display a column, select that column name.