Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

Advanced Search Text Filter

Advanced Search Text Filter

In Test Data Manager, you can enter a text instead of the wild characters in the filter criteria to search for columns.
Based on the type of filter operators, TDM searches and displays the results.
The following table lists the sample formats that the filter supports:
Filter Type
Sample Text
Operator Type
Exact match
"EMPLOYEE_FIRSTNAME"
Equality operator
Starts with
EMPLOYEE*
Like operator and type is STARTS_WITH
Ends with
*SALARY
Like operator and type is ENDS_WITH
Contains
BONUS
Like operator and type is CONTAINS
The following table lists the Test Data Manager views and pages in which you can use the advanced filter:
Test Data Manager Page
Path in Test Data Manager
Advanced Filter Supported Columns
Discover | Column
Project -> Discover -> Columns
Table Name, Column, Owner, Data Type, and Domain
Define | Data Masking
Project -> Define -> Data Masking
Name, Owner, Columns, Data Type, Domain, Policy, and Masking Rule
Define | Data Generation
Project -> Define -> Data Generation
Table, Owner, Column, Data Type, Data Domain
Profile Results
Project -> Discover -> Profile -> Column Profile Results -> Column Table
Table, Column, and Data Type