This article contains information related viewing and manipulating data stored in tables such as below:

Toggling Columns - Saving Table Preferences

Any table with this icon in the top right has the ability to hide and possible show extra columns. Certain tables also have the ability to save your user's table preferences. This allows you to set the default way you wish to view a table. It stores the row count, column sorting, and visible columns.

Toggle Columns

1. Click the Manage Table Icon

2. Toggle columns to hide or show. Columns with an X are currently visible, columns with a + are currently hidden

Save Table Settings View For User

Once you have toggled all the columns into view that you like, you can then set this as your default table view by clicking "Save Table Settings" at the bottom of the list

Filtering Data

Most table columns will have a way to filter the data based on that column. Multiple columns can be filtered in order to stack the effect. Different types of data can be filtered in different ways

Filtering Text

Text is filter case-insensitive to match any part of the field.

Filtering Numeric Data

Numeric data can be filtered as an exact match

Or as a range by using a :

For example "1000:" will show all numbers greater than or equal to 1000

And ":1000" will show all numbers less than or equal to 1000

And "1:1000" will show all numbers between 1 and 1000 inclusive

Filtering Dates

Filter date columns show as a

button. You can select a start date and/or an end date to exclude values outside of that range

Exporting Data

Table data can be exported using one of two buttons found in the top right of the table

This icon will export only the visible columns, and include filters for any filtered columns

This icon will export all data and columns possible

Bulk Actions

Some tables allow you to select multiple rows and perform bulk actions on them. In this example we'll walk through bulk deleting crypto transactions.

From here we can see a list a checkboxes the left of each row, and one on the header row which is used to select all rows on the current page.

Once we have selected at least one row, the Bulk action button/menu appears. Click this button to perform the action. There will be a prompt to confirm you wish to continue:

After you click confirm, depending on how many rows you have selected, it may take a few minutes to complete the action. Please leave the window open while it loads.

If there are a large number of rows selected, a progress bar will appear to give you an indication of progress.

Did this answer your question?