Searching with Multiple Terms (Single Compound Pill)

Advanced searches allows you to combine multiple search terms within a single compound pill. Consider the following example illustration.

This search includes a combination of the following:

  • Use of quotes indicate that the results must contain "jaunting car" as an exact term.

  • The plus symbol indicates that the results must also include Killarney or water.

  • The parenthesis indicate that Killarney and water are joined terms and the double-pipe symbol ( | | ) represents an OR value. The search results must include either "jaunting car" plus Killarney, or "jaunting car" plus water.

  • The minus symbol indicates that results must not include results that include the word castle.

If you add a parenthesis symbol to the pill, the Search app displays a Warning icon to the far right of the pill. This serves as a reminder that your current search is incomplete. The warning is removed after you add the second enclosing parenthesis symbol. You can hover your cursor over the warning symbol to display a tool-tip that provides more information about the cause of the issue.

Although this verification process might assist in preventing some errors, it is still possible to create a search that results in a failure. If for example you include a set of parentheses with no values ( ), the pill verification would pass, but the search would still result in a failure. In this case an error is displayed in the Results area.

Compound pills support the following options:

Symbol

Name

Type

Symbol

Name

Type

+

Plus

And

||

Pipe

Or

AND

Plus

And

OR

Pipe

Or

&&

Plus

And

 

 

 

-

Minus

Not

"    "

Quotes

Exact match

NOT

Minus

Not

(    )

Parentheses

Joined terms

!

Minus

Not

~

Tilde

Fuzzy or proximity

Note the following when using compound pills:

  • You can create compound pills when using Search Types whose data type is text-based only, such as Metadata or Markers & Segments. Other search types do not apply.

  • When using AND, &&, OR, ||, NOT, or - , Avid highly recommends that you use parentheses as the usual precedence rules are not honored.

  • Operators must either be the first character (element) in the search pill, or be separated by a space to be recognized as an operator. For example the + is not recognized as an operator in this search: my+search, but it would be in the following because of the added space: my +search.

  • The following operators (+, - and !) must precede the affected term directly, without a space. For example:(-Killarney +water !castle). If you add a space between the operator and the term, the operator is ignored.

  • Since the default operator within a compound pill is And, the use of any "And" operator is optional. While it can help clarify the intent of the query, it does not change its results.