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 upper left corner.
Select the Metadata option 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 search keywords and how many fields matched with VDP tags. If you want to know more information about them, just click the link with the number of matches and check the fields and custom properties that matched.
Take into account that the search by metadata supports multiple search terms and it is inclusive and case insensitive:
Multiple search terms. Search for an exact phrase consisting of one or more words is supported. It is also possible to search the elements that contain all the search terms entered or those that contain at least one of the search terms.
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 option. Select the desired search type:
Exact match. This is the default option. You can search for an exact phrase consisting of one or more words and only the elements containing the particular sequence of terms in the exact order you entered will be retrieved.
All the words. Allows a search including all the search terms. When searching all the words, only the elements containing all the words in some of the search fields will be returned (i.e. all the words are contained in the element name, all the words are contained in the description, all the words are contained in a field name, all the words are contained in a field description, or all the words are contained in a property value).
Any of the words. Allows a search including at least one of the search terms. When searching any of the words, only the elements containing at least one of the words in some of the search fields will be returned.
Note that the maximum number of words for All the words and Any of the words search options is 6. The seventh and any subsequent words will be ignored.
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.
Tags. If you select a tag, in the results list will appear those views and web services with that tag assigned. When VDP tags are imported, the results list will also shows those views containing some field assigned to the tag.
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.