1. Using Guide for Oracle Cloud
  2. Data Studio
  3. The Catalog Page
  4. Sorting and Filtering Entities

Sorting and Filtering Entities

On the Catalog page, you can sort and filter the displayed entities.

Sort Entities

To set a sort order for the entities on the page,

  1. Click Sort by Sort by on the toolbar.

  2. Find the value you want to use to sort, for example Entity Type.

  3. Click the Ascending Sort ascending icon or the Descending Sort descending icon next to that value.

    After you've selected a value, it is displayed in a box next to the Sort by label beneath the toolbar.

  4. You can set one or more parameters. If you want to add a parameter to your search, repeat the steps above. For example, you can set Entity name (ASC) and then set Created on (DESC). Both appear as separate boxes next to the Sort by label beneath the toolbar.

To remove a sort value, you can do either of the following:

  • Click the X icon in the box that shows the sort value (next to the Sort by label beneath the toolbar).

  • Click Sort by Sort by on the toolbar and click the Ascending or Sort ascending Descending Sort descending icon next to the value you want to remove.

To return to the default (Updated on DESC), click Sort by Sort by and select Reset.

Filter Entities

Restrict which entities that are returned by a search are displayed on the page by setting filters in the Filters panel on the left side of the Catalog page. Select one or more filter values. Only those entities that are returned by a search and that match the filter values are shown. Selecting all or none of the options shows all entities returned by the search.

By default, system tables and private tables are not displayed. To display them, click Catalog User Preferences Preferences in the toolbar and then click the Show system tables slider or the Show private tables slider, or both.