The search by metadata allows you to seek views or web services that contain the query terms in their metadata, considering an element’s metadata as:
The names of its fields.
The descriptions of its fields.
The values of any custom properties it has assigned.
To create a search by metadata you have to:
Type your query in the search bar located at the top left corner.
Metadataoption under the Filter results section.
Select your filtering options.
Launch the query, by one of the following ways:
Notice that the first time you search some terms, the Data Catalog will perform a search by metadata. In addition, if the search by content is not available, all your searches will be by metadata.
The results list supports two display modes: list or grid. To have more information about each result, click the icon to enable the list mode. Instead, if you prefer more results in the page, click the icon to enable the grid mode.
For each result, you can check how many fields or custom properties matched with the query. Just click on the icon. If you want to know more information about them, click on the icon and check the fields and custom properties that matched.
Take into account that the search by metadata supports simple, inclusive and case insensitive queries:
Simple: The queries consist of a list of terms and a set of filtering options. Complex conditions involving logical operands like
NOTare not supported.
Inclusive: For a view or web service to appear in the results list, its metadata must contain the search terms. For instance, the search term
customerwill match with the views
dv_customers, since the search term is included in their names.
Case insensitive: Uppercase and lowercase letters are treated the same when the Data Catalog compares the terms in the query and the terms in the metadata. For instance, the search term
CUSTOMERwill match with the views
Customer, since their names are composed by the same letters.
If the query is empty, all the views and web services will match with it.
In addition, you can refine your results applying some of the available filtering options under the Filter results section:
Element type. Select which type of elements you want in the results:
Views and web services.
Web services only.
Search fields. By default all the fields in the metadata participate in the search. You can alter this set by selecting which ones should be taken into account:
Collaboration. Only the views and web services with at least one of the collaboration you choose will appear in the results:
Databases. By default, all the databases in the Virtual DataPort server participate in the search. You can refine your results list by selecting the list of databases to consider.
Categories. If you select a category, in the results list will only appear those views and web services that belong to that category or any of its subcategories.
Tags. If you select a tag, in the results list will only appear those views and web services with that tag assigned.
An administrator of the Data Catalog should consider that:
In order to work, the search by metadata requires that the Data Catalog has been synchronized with the Virtual DataPort server at least once. Otherwise, the results list will be empty.
For a view or web service to appear in the results list, the user must be granted with the
CONNECTprivilege on its database and with the
METADATAprivilege on it.