2.1

Conducting a Search
255
Wild Card Characters and Operators Supported for Federated Searches
in Interplay | MAM Databases
In addition to the basic criteria described in “Conducting a Search” on page 243, 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.