MediaCentral | UX User’s Guide : Searching for Assets : Conducting a Search : Wild Card Characters and Operators Supported for Federated Searches in Interplay | MAM Databases

Wild Card Characters and Operators Supported for Federated Searches in Interplay | MAM Databases
In addition to the basic criteria described in Conducting a Search, you can use different wild cards and operators to specify your query when conducting a federated search in Interplay MAM databases.
 
Option
Example
Result
Single character
I
Returns assets that contain the single search character “i” in one of their metadata fields. The field in question can contain other text.
Example: i finds I robot but also I’m a robot
The single character feature is also used to support searches for Chinese and Japanese characters.
If the feature Auto-Append Wildcards is activated, searching for a single character is not possible.
Single search term
house
Returns assets that contain the search term “house” in one of their metadata fields. The field in question can contain other text.
Exclamation mark (!)
!house
Returns assets that contain only the search term “house” in one of their metadata fields. The field in question cannot contain any further entries.
If the feature Auto-Append Wildcards is activated using the exclamation mark is not possible.
Quotation marks (“”)
“White House”
Returns assets that contain both the search term “White” and the search term “House.” “White” must come before “House” in the text. The two search terms cannot be separated by any other characters, except punctuation marks, as these are ignored.
Operator OR
Operator character |
White OR House
White | House
Returns assets that contain the search term “White” or the search term “House,” or both.
Operator AND
Operator character &
Terms separated by spaces
White AND House
White & House

White House
Returns assets that contain the search terms “White” and “House” in a single metadata field, or the search term “White” in one metadata field and the search term “House” in a different metadata field.
Operator NOT
Operator character ^ or ~
White NOT House
White ^ House
White ~ House
Returns assets that contain the search term “White” in at least one metadata field, but that do not contain the search term “House” in this or any other metadata field.
Brackets () and Operators
(house AND (white OR blair)) NOT visitors
If you create complex search queries — queries that use more than one Boolean operator — consider the priorities with which the operators are processed: NOT takes priority over AND, and AND takes priority over OR. In addition, you can use brackets in complex search queries to give structure to your query. In this case, the innermost bracket takes priority over the next bracket, and so on.
The example query excludes all assets that contain the word “visitors”; returns all assets that contain the other search terms, as follows: “house” and “white,” “house” and “blair,” “house” and “white” and “blair”.
Wild card * or %
Whit*
Whit%
The asterisk and the percentage sign are the universal wildcards that will return any character string (0, 1, or more characters) in a specific position.
Returns all assets containing words that start with whit, such as: “whit,” “white,” “white-collar,” “whitey,” “whiter,” or “whitish.”
Using the * or % wildcard at the beginning of a search term or within a search term requires specific usage rights. For performance reasons these search options are not available by default.
Auto-append *
Whit
If the option Auto-Append Wildcards is set in the System Settings for Interplay MAM, each search term is appended automatically by an asterisk before submission. This allows a search behavior more similar to Interplay Production and iNEWS.
With the activated Auto-Append Wildcards feature, searching for a single character and using the exclamation mark is not possible.