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

Supported Search Operators

Supported Search Operators

Use search operators to refine the results of a Data Privacy search.
The following list describes the search operators that you can use in a Data Privacy search:
~ (Tilde)
For a fuzzy search, use the tilde ("~") symbol at the end of a single word search term. For example, to search for a term similar in spelling to "roam," use the fuzzy search: roam~
This type of search returns words like roam, roams, or foam.
To limit the results returned by a search using a tilde operator, append a 0 or 1 after the tilde operator. For example:
  • ~0. This does a fuzzy search with zero edits. 0 operations (insertions, deletions or substitutions of a single character; or transposition of two adjacent characters) are allowed to change a word into another. For example, the search term "Doe~0" will return results if and only if Doe exists in the records.
  • ~1. This does a fuzzy search with one edit. 1 operation (insertion, deletion or substitution of a single character, or the transposition of two adjacent characters) is allowed to change a word into another. For example, the search term "Zo~1" will find terms like Zoe, Jo, So, or Ho.
~ (Tilde) Between Two Distant Terms
This operator finds words that are a within a specific distance away. For example: "4007 9901"~2 will return 4007-5368-2997-9901 since 4007 and 9901 are separated by only 2 indexed terms (5368 and 2997).
^ (Caret)
This operator boosts precedence of the term in search. For example:
Alan Zoe^4 will first return results that contain Zoe and then results that contain Alan.
Alan^4 Zoe will first return results that contain Alan and then results that contain Zoe
&& (Double Ampersand)
The && operator matches documents where both terms exist anywhere in the text of a single document. This is equivalent to an intersection using sets. For example:
Alan && Zheng will return the results which must contain both of the terms Alan and Zheng.
||, OR, Space
The operators ||, OR, or a space between two terms have the same function. These operators link two terms and find a matching document if either of the terms exist in a document. This is equivalent to a union using sets. You must enclose the complete search string in parenthesis.
For example:
(Alan || Zheng)
(Alan OR Zheng)
(Alan Zheng)
All three operators return the same result. The operators return results that contain either Alan or Zheng or both.
+ (Plus Sign)
This operator requires that the term after the "+" symbol exist somewhere in the field of a single document.
For example:
James+ Smith will return all the results which must contain James and might also contain Smith.
? (Question Mark)
The single character wildcard search looks for terms that match the term with a single character replaced.
For example:
Al?n will return Alan, Alon, Alen.
* (Asterisk)
The multiple character wildcard search looks for 0 or more characters.
For example:
Alan* will return Alan, Alanda, Alane.

0 COMMENTS

We’d like to hear from you!