How to build complex queries in Informatica data catalog
In the search bar, you can progressively build complex search queries to search for business and technical assets. As you type your search query, the search provides intelligent suggestions.
The following table lists some sample business asset search query that you can try in the search box:
Search query |
What it does |
all in domain HIPAA* |
Shows all assets that are children or contained in Domain assets that start with ' HIPAA'. |
' all in domain Human Resources' |
Shows all assets that are children or contained in Domain assets that start with the name ' Human Resources'. |
business term 'phone number' |
Shows all Business Term assets with the name ' Phone Number'. |
business term phone* |
Shows all Business Term assets that start with ' Phone'. |
business terms which are critical data element |
Shows all Business Term assets with Critical Data Element field as selected. |
business terms in domain Finance* |
Shows all Business Term assets that are children of Domain assets that start with the name ' Finance'. |
business terms where format type is Text |
Shows all Business Term assets with Text in the Format Type field. |
business terms without description |
Shows all Business Term assets with the Description field empty. |
domains containing business term Email |
Shows all Domain assets that have a parent-child relationship to Business Term assets with the name Email. |
business terms with stakeholder @<username> |
Shows all Business Term assets with a user name or user group in the Stakeholder field. |
business terms without stakeholder |
Shows all Business Term assets with the Stakeholder field empty. |
business term created by @<username> |
Shows all Business Term assets with a user name or user group in the Created By field. |
business term modified by @<username> |
Shows all Business Term assets with a user name or user group in the Modified By field. |
all related to business term email |
Shows all assets that are related to Business Term assets with the name ' email'. |
business terms related to data elements |
Shows all Business Term assets that are related to data elements. |
business terms not related to data elements |
Shows all Business Term assets that are not related to data elements. |
all where lifecycle is not Published |
Shows all assets where the Lifecycle field is not in the Published status. |
all with lifecycle Draft |
Shows all assets where the Lifecycle field is in the Draft status. |
business terms with lifecycle Draft |
Shows all Business Term assets where the Lifecycle field is in the Draft status. |
domains with lifecycle Draft |
Shows all Domain assets where the Lifecycle field is in Draft status. |
columns related to business term 'Phone Number' |
Shows all columns that are related to Business Term assets with the name ' Phone Number'. |
columns related to data classification 'Social Security Number' |
Shows all columns that are related to data classifications with the name ' Social Security Number'. |
columns related to data classification Email |
Shows all columns that are related to data classifications with the name Email. |
columns not related to business term |
Shows all columns that are not related to Business Term assets. |
data elements related to business term Email |
Shows all data elements that are related to Business Term assets with the name Email. |
data elements related to data classification 'Social Security Number' |
Shows all data elements that are related to data classifications with the name ' Social Security Number'. |
data elements not related to data classification |
Shows all data elements that are not related to any data classification. |
columns Credit* |
Shows all columns that start with ' Credit'. |
columns which are profiled |
Shows all columns that are profiled. |
columns which are not profiled |
Shows all columns that are not profiled. |
columns which are not related to data classification |
Shows all columns that are not related to data classifications. |
table CUST* |
Shows all tables that start with ' CUST'. |
tables with Age |
Shows all tables with the name ' Age'. |
tables which are profiled |
Shows all columns that are profiled. |
all with rating between 1 and 5 |
Shows all assets with rating between 1 and 5 stars. |
all rated by @<username> |
Shows all assets with a user name or user group in the Updated By field. |
all rated within last 3 days |
Shows all assets rated within last 3 days. |
all commented by @username |
Shows all assets with comments with a user name or user group in the Updated By field. |
all commented within last 2 days |
Shows all assets with comments within last 2 days. |
all certified by @username |
Shows all certified assets with a user name or user group in the Updated By field. |
all certified within last 10 days |
Shows all certified assets within the last 10 days. |
technical datasets which are not certified |
Shows all technical Data Set assets that are not certified. |
all having ratings |
Shows all assets with ratings. |
all having comments |
Shows all assets with comments. |
all not having ratings |
Shows all assets without ratings. |
all not having comments |
Shows all assets without comments. |
all which are certified |
Shows all technical Data Set assets that are certified. |
tables which are certified |
Shows all tables that are certified. |
files which are certified |
Shows all files that are certified. |