When you search the Data Vault, you specify the archive folder and the entity that you want to search in. If the archive folder includes multiple schemas, the query uses the mined schema in the Enterprise Data Manager for the corresponding entity. The search only returns records from the corresponding schema and table combination. If the archive folder only includes one schema, the query uses the

dbo

schema.

Use table columns to specify additional search criteria to limit the amount of records in the search results. The columns that you can search on depend on what columns are configured as searchable in the Data Discovery portal search options. Based on your system-defined role, you can also search the Data Vault based on tags, legal hold groups, retention expiration date, and effective retention policy.

You can add multiple search conditions. Use AND or OR statements to specify how the search handles the conditions. You can also specify the maximum number of records you wish to see in the results. You have the option to order the search results based on a specific column in the entity driving table and to sort them in ascending or descending order.

You can save the search criteria that you configure. Saved criteria is useful when you configure multiple search conditions and want to search using the same conditions in the future. You can edit and delete the saved criteria, and you can designate whether the criteria is available for use by all users or only you.