Sorting Filtering & Arranging Data

In the Database Browser, you can modify the presentation of the data by filtering, hiding, displaying, or moving columns. The methods we describe below can help you analyze your data more clearly and manage it more easily.

On This Page

• Sort On a Column
• Show or Hide Columns
• Rearrange Columns
• Settings Saved
• Filter Records
• Refreshing the Data View

Sort On a Column

To sort a column, hover over the column heading to display the small menu arrow, then select either Sort Ascending or Sort Descending.

Here's an example of a column heading with the menu arrow. 

When you sort a column, the records will rearrange according to an alphabetical or numerical sorting of the values in that column. If, for example, you sort on a Last Name column, the records will rearrange so that the names form a list in alphabetical order. Numerical data will sort sequentially. If you choose to Sort Ascending, then the sort will run A-Z or from the smallest to largest number. Or, you can choose Sort Descending and the sort will run Z-A or from the largest to the smallest number.

Show or Hide Columns

To display or hide a column, click the column header and then select Columns to display a listing of all the columns. Place check-marks next to the columns that you want to appear in the database browser, and uncheck any boxes for columns that you want to hide.

Rearrange Columns

You can move columns to re-arrange their placement. Click on a column heading, then drag and drop it in its new location.

Settings Saved

All of these settings for sorting, showing and hiding, and rearranging will persist when you log out. The next time you access the Database Browser, you will find your data arranged as you had left it.

Filter Records

To filter the display of records,  click the column header, select Filters, and enter the value for which you expect to find at least one match. If any matches are found in that column, only the records containing those matches will show in the browser. To clear an individual filter, again click the column header and uncheck the box next to the Filters menu item. To clear all filters, click the Reset Filters menu item in the bottom toolbar.

You can filter multiple columns by using an AND operator between the values. If you use the AND operator, a match will result only for those records in which both values are found within that column.

If you're not seeing all the data you expect, then try the Reset Filters button. Any columns to which you apply a filter are shown in green highlighting. As with column settings, the filters will persist after you close and re-open the database browser.  

Refreshing the Data View

Data in the grid doesn't automatically update when a new submission is received. Use the Refresh icon  in the bottom toolbar to retrieve the very latest data from the server.