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.
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
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
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
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
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
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.