Manage Records > Finding records > Using the search box to find records
  

Using the search box to find records

Select one or more business entities and use the search box to search for records. The search results show the most important details of the records. You can see the complete details by opening the records.
You can use a complete or partial text as a search string. When you start typing the search string and if you see a matching string in the suggestion list, select it. You can also select a recently used search string.
The following table lists few example search strings and explains how they function:
Example Search String
Search Behaviour
Smart Phone
Searches for records that contain Smart, Phone, or any variations of Smart or Phone as a field value.
"Smart Phone"
Searches for records that contain Smart Phone as a field value.
When you use this search string format, avoid combining it with other formats. The search results might not be the same when you use them separately. For example, "Mini" || Air* might return different results when you search for "Mini" and Air* separately.
Smart*
Searches for records that contain a value which starts with Smart. For example, Smart Watch or Smart Television.
Pr*r
Searches for records that start with Pr and ends with r. For example, Processor or Printer.
MDM0000000000F
Searches for a record with a field value that matches the business ID MDM0000000000F. The search also returns records that approximately match this value.
If you use a source business ID to search for a record, the search returns the master record to which the source contributes values.
If you use a master business ID to search for a record, the search returns all the records that contain the searched record as related record.
For example, you can use the business ID of an organization record to search for all the person records related to the organization record.
*
Returns all the records.
Note:
When you use only white spaces as a search string without any other characters, the search doesn't return any results.
iP?d
Searches for records with a single character between iP and d, such as iPad and iPod.
You can use the question mark wildcard character multiple times in a word.
The Washington Post
Ignores the stopword The and searches for the records that contain Washington, Post, or any variations of Washington or Post.
The example stopwords are a, an, of, and with. For a complete list of stopwords, contact Informatica Global Customer Support.
-iPad*
Searches for records that don't start with iPad or any variations of iPad, such as iPad Pro or iPad Mini.
+Mini +iPad*
Searches for records that contain Mini and a field value that starts with iPad. For example, a record that starts with product name iPad and model Mini 2 matches the search string.
Lenovo~
Searches for records with similar values where up to two characters in the search string can be replaced. For example, Lonovo or Bonovo can match the search string.
iPad && Air*
Searches for records that contain iPad and variations of Air in the same record. For example, product name is iPad and model is Air 2.
(Mini* || Air*) && iPad
Searches for records that contain iPad and any variations of Mini or Air as a field value. For example, a record with model Air 2 and product name iPad.
/Air_([0-9]+)/
Searches for records that contain Air_ followed by a numeral, such as Air_1 or Air_2.
Note:
The forward slashes act as escape characters so that the wildcard characters are not considered as search string.
/iPhone[*]/
Searches for records that contain iPhone followed by the asterisk (*) character.
Note:
To use wildcard characters as part of the search string, escape the wildcard characters with square brackets ([]). Also, ensure that the search string starts and ends with forward slashes.
Note:
Search strings can include only the following special characters:
+ - = && || > < ! ( ) { } [ ] ^ " ~ * ? : \ /
You can't search for records with similar values in system fields. However, you can search for records that exactly match the specified values in system fields and continue to use the supported wildcards in search strings for system fields.
When you search for records with keywords, such as AND, OR, and NOT, as field values, ensure that you specify the values in the following format:
If you don't enter the values in the specified format, MDM SaaS doesn't return any results. However, if these keywords are part of a field value, such as SAND AND MARVEL, you don't have to enclose the keyword part of the value in the specified format.
You can save the searches that you perform frequently and run them any time from the Search page. The saved searches contain the search term and the filter attributes that help you initialize the searches.
When you search for records that contain URLs with digital assets, use only the file names of digital assets that are in English, excluding their URLs. If the file names contain spaces, ensure that you enclose them within double quotes.