Searching and filtering data in tables

Allie Cliffe
  • Updated

Learn how to search within a single table or between all tables in a workspace. You can filter results based on search criteria and save filtered results as a set for analysis. 

Select and hide columns

If you just want to select specific columns or hide columns, you can do that by clicking the gear icon at the top right of the table. This will reveal a popup where you can choose what columns of metadata to show. You can even choose to save this view, especially useful for collaborators working in the same workspace.
Modify-table_Save-column-selection_Screen_shot.png

Search within a workspace table

Default search ("AND")

To filter for rows that include all terms:

1. Use the search field at the top right of the table.
Search-data-table_Search-within-table_Screen_shot.png

2. Enter search terms separated by a space.

3. Click the blue search icon.

The default search mode is "AND"

Advanced search ("OR")

To filter for rows that include any of the specified terms:

1. Select Advanced search at the top right of the table.
Search-data-table_Advanced-search_Screen_shot.png

2. Click the OR (rows with any term) radio button.

3. Enter search terms separated by a space.

4. Click the blue search icon.

What to expect

The search will process immediately and Terra will return only the rows that include all search terms

Search-with-a-table_Screen_capture.gif

To clear search results

Click the "x" icon in the search field.
Search-data-table_Cancel-search_Screen_shot.png

Search all tables in a workspace

1. Use the search field above the table names on the top left.
Search-data-tables_Search-all-tables_Screen_shot.png

2. Enter search terms separated by a space.

3. Click the blue search icon.

The default search mode is "AND"

What to expect

While Terra is searching across all tables in the workspace, you'll see a spinner in the tables column. 

When the search is complete, you'll see a green oval next to each table with the number of rows that contain all search terms

Click on a table to view the filtered results.

Search-data-tables_Search-all-tables_Screen_capture.gif

To clear search results

Click the "x" icon in the search field.
Search-data-tables_Clear-all-tables-search_Screen_shot.png

Save filtered results as a set

Once you've completed a search, it can be useful to save the results - if you want to analyze just those entities, for example. 

1. Click the checkbox at the top left of the table.

2. Select Filtered from the menu.
Search-data-table_Save-results-as-set_Select-filtered_Screen_shot.png

3. Click Edit (pencil icon) above the table.

4. Select Save section as set. 
Search-data-table_save-results-as-set_Save-selection-as-set_Screen_shot.png

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.