Multi-Word Keyword Searches 

MDM supports multi-word keyword searching. It performs an “OR” or “AND” search depending on how you enter the search words.

Search terms separated by a semi-colon (;) are treated as OR searches where MDM matches a record if it contains any of the search words in its keyword-enabled fields.

For example, the keyword search entry “washer; dryer” would return all of the records shown in the following figure.

Records found by OR keyword search

recordID	Product¹	Description¹
112	Electric Dryer	Washer sold separately
113	Washer and Dryer	Side-by-side
114	Washer	Top-loading
115	Dryer	Front-loading
116	Laundrymatic 2000	Compact washer and dryer set

¹ Keyword-enabled field

As the figure above shows, the OR search returns records 114 and 115 are even though they do not contain all of the search words.

Search terms NOT separated by a semi-colon (;) are treated as AND searches. To match, a record must contain all of the search words anywhere in their keyword-enabled fields. Search words do not have to appear next to each other, or even in the same field, to match.

For example, the keyword search entry “washer dryer” would return the records shown in the figure below.

Records found by AND keyword search

recordID	Product¹	Description¹
112	Electric Dryer	Washer sold separately
113	Washer and Dryer	Side-by-side
116	Laundrymatic 2000	Compact washer and dryer set

¹ Keyword-enabled field

As the figure above shows, the AND search does not return records 114 and 115 because they do not contain all of the search words.