The search by content allows you to retrieve views in the Virtual DataPort server that contain the query terms in their data. The Data Catalog does not query the views in real-time. Instead, it performs the search on an index created for the views exposed by Virtual DataPort.
Since the index may consider only a subset of all the views in Virtual DataPort, you will only obtain results on the views actually indexed.
To create a search by content you have to:
Type your query in the search bar located at the upper left corner.
Select the Content option under the Filter results section.
Select your filtering options.
Launch the query, by one of the following ways:
For each result, you can check how many matches are in the view. Click it and load the view details. You will find all the actual matches with the query in its Search tab. Instead, you can check a preview of the matches from the results. Click the Preview results section and unfold a snippet of the first matches. If you click the icon of a match, you will see all the information stored in the index for that match.
The search by content supports complex queries with advanced features like:
Wildcards in the query terms.
Fuzzy searches, where you look for words in the data similar to the query terms, but not exactly the query terms.
Proximity searches, which require that some terms are near each other at a certain distance.
Boosting some terms in the query.
The full list of features supported by the queries depends on the search engine used. Check which search engine is configured in the Data Catalog and find more information on its query syntax in one of the following links:
Apache Lucene Search Syntax for Scheduler Index server.
Query String Syntax for Elasticsearch 5.x.
Query String Syntax for Elasticsearch 6.x.
Query String Syntax for Elasticsearch 7.x.
Searches are always performed in the default field of the index, both with Scheduler Index server and Elasticsearch, so it is not supported to specify a field to search in.
In addition, you can refine your results applying some of the available filtering options under the Filter results section:
Databases. By default, all the databases with information in the index participate in the search. Select some databases and only their views will be considered in the results list.
Views. If you select some databases, you can filter even more your results list and select for which specific views you want to perform the search.
An administrator of the Data Catalog should consider that:
The search by content is only available if an index has been properly configured for the current Virtual DataPort. You can find more details in the Content Search Configuration section.
For a view to appear in the results list, the user must be granted with the
CONNECTprivilege on its database and with the
EXECUTEprivilege on it.
A view will not appear in the results list if the user has row restrictions on it.
A view will not appear in the results list if the user has column restrictions on it.