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, click the 'settings' gear icon above the table.
You'll see a popup where you can choose what columns of metadata to show. You can even choose to save this view; it's especially useful for collaborators working in the same workspace.
To save the column selection, click the save this column selection button. When prompted, name the column selection and then click the save button.
To load previously-saved column selections, click the 'settings' gear icon above the data table. You'll see a list of saved column selections in the popup window. Click on the three-dot icon next to any of these selections to load or delete it.
Search within a workspace table
Faster searching for exact terms in large tablesFor large tables, using the default search across the entire table may be slow. If you know the exact term you are searching for, we recommend using search by column
Default search ("AND")
To filter for rows that include all terms:
1. Use the search field at the top right of the table.
2. Enter search terms separated by a space.
3. Click the blue magnifying glass search icon.
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.
2. Click the OR (rows with any term) radio button.
3. Enter search terms separated by a space.
4. Click the blue magnifying glass search icon.
What to expect
The search will process immediately and Terra will return only the rows that meet the search conditions.
To clear search results
Click the "x" icon in the search field.
Search all tables in a workspace
1. Use the search field above the table names on the top left.
2. Enter search terms separated by a space.
3. Click the blue magnifying glass search icon.
The default search mode is "AND"
What to expect
While Terra searches 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.
To clear search results
Click the "x" icon that appears when you hover over the search field.
Filter by column value
Separating out specific rows by a specific value in a column can be useful for quickly generating subsets when working with large datasets.
1. Click the three dot action icon to the right of the column name.
2. Enter a filter term in the field with the magnifying glass icon. Note that the filter must be an exact match (including capitalization). Click on the magnifying glass icon or hit 'enter' to execute the search.
3. Terra will return rows with an exact match for the filter. You will see a breadcrumb at the top of the column that shows the filter applied to the table.
To return to the main view
Click the x in the circle beside the "filtered by" condition.
Save filtered results as a set
Once you complete a search, you may want to save the results - e.g., if you want to analyze just those entities.
1. Click the checkbox at the top left of the table.
2. Select Filtered from the menu.
3. Click Edit (pencil icon) above the table.
4. Select Save section as set.
What to expect
Terra will save the filtered results as a new set in the table's associated set table. For more information on how to integrate set tables into your Terra workflows and interactive analyses, see Managing data with tables.