Skip to end of banner
Go to start of banner

Data Table Column Management and Filtering (X) Break into 3?

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 4 Next »

Managing Columns

In the data table, there are default fields that are visible. These can be reordered, added to, revised and removed.

In the menu in the upper right, we can open a dropdown to select/deselect which columns we would like to see. Additionally, we can use the arrow in the column title to both sorts, hide, or move the column around.

Columns can also be resized by placing your cursor along the border under a resize icon appears, then drag the border to the desired size.

After we’ve arranged and resized how we like, it’s critical to open the menu and choose ‘Save Grid Layout’, otherwise, any change in the data or a new search will reset the grid.


Sorting

You can sort the data in columns by either clicking on the column title or opening the column menu and choosing one of the sort options. There are two different sort styles available.

Basic - By clicking on the column title, we can automatically sort it. Clicking again will sort it in a reverse manner, and a third time will remove the sort.

Multi - Using the column menu, we can also select a sort. With this option, after a column has been sorted, we can select another column's menu and also sort based on that. The order they are sorted will be denoted by a small number next to the arrow.

Clearing Sorts - You can remove sorts using the column menu, or through the table menu option ‘Clear All Sorts’.


Filters

One of the useful functions of the data table is the ability to filter data. In order to do so, filters must first be toggled on using the utility button if they are not present.

Filters allow us to enter values to narrow down the available data in the table.

We know filters have been applied, and multiple can be applied, when they are surrounded by a box. Values written that are not boxed have not been applied.

Removing/Clearing Filters - In the table menu, we can choose ‘Clear All Filters’, or if we’re only looking to remove one value, we can click the 'x' in the box next to the value itself.

Manipulate site data (+buttons)

Page navigation.

  • No labels