This tab allows to search for views of the selected database by its name and description or the name of its fields. When you access to this tab, by default, all the views of the database are shown together with its field names, but you can filter the results entering the desired search term and clicking the Search icon. The tool will show:
- All the views whose name contains the search term.
- All the views whose description contains the search term.
- All the views containing a field whose name contains the search term.
- All the views containing a field whose description contains the search term.
For each view, it will show its name, its description and the number of fields whose name contains the search term. Clicking the Details icon () you can see those fields (if any) within their description. Note that the fields of the view whose name and description do not contain the search term will not be shown.
The values where the search terms are contained are shown in bold (the view name, the view description and/or the field names and descriptions).
In the example of the figure below, the results have been filtered using the search term contact”. Four views are returned. Both, the name and the description of the first view contains the search term (so, both are shown in bold), but none of its fields contains the search term (the number of Matched Fields is 0). The name and description of the other three views are not shown in bold because the search term is not contained in any of them. This means that they contain some fields whose name or description contains the search term (the number of fields verifying this condition is shown in the Matched Fields column). Clicking the Details icon () you can see the fields. For example, the view customer has three fields whose name contains “contact” (contact_person, contact_phone and contact_email), and a field whose description contains the search term (address), so they are shown in bold.
By default, the search term is case insensitive, so you would see the same results searching by CONTACT” instead of contact”. If you want the metadata search to be case sensitive, you have to check the Case sensitive check box. In this case, if the Virtual DataPort database is configured as restricted (case insensitive) make sure to write the search terms in lowercase, as it is how the identifiers are stored.
Note that a view will not be listed in the results if the user does not have the privileges required to see it.