Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Integrated Validation for Archive and Retirement Projects
  12. Retention Management
  13. External Attachments
  14. Data Archive Restore
  15. Data Discovery Portal
  16. Data Visualization
  17. Data Privacy
  18. Oracle E-Business Suite Retirement Reports
  19. JD Edwards Enterprise Retirement Reports
  20. Oracle PeopleSoft Applications Retirement Reports
  21. Language Settings
  22. Appendix A: Data Vault Datatype Conversion
  23. Appendix B: Special Characters in Data Vault
  24. Appendix C: SAP Application Retirement Supported HR Clusters
  25. Appendix D: Glossary

Examples of Search Queries

Examples of Search Queries

You can search for records archived to the Data Vault in a variety of ways to make your search results more relevant. You can use a word or phrase, add boolean operators or wildcard characters, or specify a range of values.
The following list describes some of the search queries you can use:
Single Word
Enter a single word in the search field. For example, enter
Anita
. Records with the word Anita appear in the results.
Phrase
Enter a phrase surrounded by double quotes. For example, enter
"exceeding quota"
. Records with the term exceeding quota appear in the results.
Replace Characters
Use ? and * as wildcard characters to replace letters in a single word search. You cannot use wildcards if your search query has more than one word. You cannot replace the first character of the word with a wildcard character.
To replace a single character in a word, use ?. For example, enter
te?t
. Records with the word tent, test, or text appear in the results.
To replace multiple characters in a word, use *. For example, enter
te**
. Records with the word teak, teal, team, tear, teen, tent, tern, test, or text appear in the results.
Similar Spelling
Use the ~ character to search for a word with a similar spelling. For example, enter
roam~
. Records with the word foam or roams appear in the results.
Range Searches
You can search for records with a range of values. Use a range search for numbers or words.
Enter the high and low value of a range separated by TO. The TO must be in uppercase.
To search by range, use the following formats:
  • To include the high and low values, surround the range with square brackets:
    <column name>: [<high> TO <low>]
    For example, enter
    name: [Anita TO Ella]
    Records with the word Anita, Ella, and words listed alphabetically between Anita and Ella in the name column, appear in the results.
  • To exclude the high and low values, surround the range with curly brackets:
    <column name>: {<high> TO <low>}
    For example, enter
    name: {Anita TO Ella}
    Records with the words listed alphabetically between Anita and Ella in the name column appear in the results. Records with the word Anita or Ella do not appear in the results.
  • To search for a date range, use the format yyyymmdd. Use square brackets to include the high and low values. Use curly brackets to exclude the high and low values.
    <column name>: [<yyyymmdd> TO <yyyymmdd>]
    For example, enter
    hire_date: [20040423 TO 20121231]
    Records with dates from April 23, 2004 to December 31, 2012 in the hire_date column appear in the results.
AND Operator
To search for records that contain all the terms in the search query, use AND between terms. The AND must be in uppercase. You can replace AND with the characters &&.
For example, enter
"Santa Clara CA" AND Platinum
. Records with the phrase Santa Clara CA and the word Platinum appear in the results.
+ Operator
To specify that a term in the search query must exist in the results, enter the + character before the term. For example, enter
+semiconductor automobile
. Records with the word semiconductor appear in the results. These records may or may not contain the word automobile.
NOT Operator
To search for records that exclude a term in the search query, enter NOT before the term. You can replace NOT with either the ! or - character.
For example, enter
Member NOT Bronze
. Records that contain the word Member but not the word Bronze appear in the results.

0 COMMENTS

We’d like to hear from you!