The Goldfynch advanced search lets you include multiple values against a single parameter without having to create a new condition for each one. This is done through complex operators, and in effect works just like a group of conditions connected with "OR", "AND", and "NOT" Boolean operators. This article explains how can you speed up your query building process by using complex operators. 


The list of complex operators are:

  • CONTAINS ANY OF
  • CONTAINS ALL OF
  • CONTAINS NONE OF
  • DOES NOT CONTAIN ALL OF
  • IS ANY OF
  • IS ALL OF
  • IS NONE OF
  • IS-NOT ALL OF


Performing an advanced search using complex operators from the 'Advanced Search' view

Example 1: To find files that contain any one of the words 'email data', 'open file' or 'create case' 


For the above example, we can create a single search condition using the complex operator 'CONTAINS ANY OF'. This will be much faster than having to create multiple conditions and then connecting them with the 'OR' logical operator.


  1. Click the 'Advanced Search' button in the left pane 
  2. Click on the 'Create New Search' button
  3. Click on the edit icon (the pencil) or click anywhere in the condition box to enter the search criteria
  4. Select the parameter body and then click on the operator drop-down list and select the 'CONTAINS ANY OF' operator
  5. There are two ways to enter multiple values for the search -  
    • Method 1 - Enter values using the `+Add Value` button
      1. Click on the `+Add Value` button and enter the value. Repeat this for each of the values that need to be entered
    • Method 2 - Enter values using the `Bulk edit values` button
      1. Click on the `Bulk edit values` button
         
      2. Enter each value in the Bulk Edit screen overlay separating each value with commas or by entering each value in a new line. There is no need to enclose the values in quotes.
      3. Click on the Save button in the bulk edit screen overlay

  6. Execute the search query

Example 2: To find files that are tagged with all of the following tags 'Documentation', 'From Zips' and 'Important'


We follow the same procedure as for example 1, except instead of the body parameter we select the tags parameter. 


Here are the steps: 

  1. Navigate to the 'Advanced Search' view and create a new search using the 'Create New Search' button
  2. Click on the edit icon (the pencil) or click anywhere in the condition box to enter the search criteria
  3. Select the tags parameter from the drop-down list
  4. Select the 'IS ALL OF' operator from the Operator drop-down list
  5. Click on the `+Add Value` button and select a value from the drop-down list. Repeat this till all the values have been added.
  6. Execute the search 


Performing an advanced search using complex operators from the search bar


Performing advanced searches from the search bar is similar to performing them from the advanced search view, except that the entire query is typed directly into the search bar, separated with operators like AND, OR, and NOT. You can get a detailed look at how to use advanced searches from the search bar here.


We will use example 1 from above to show how we can use complex operators from the search bar. Our search should retrieve files that contain any of the following words 'email data', 'create case' or 'open file'


  1. Begin by typing 'body' in the search bar at the top of the screen
  2. Select the Advanced Search tab that appears on the screen
  3. Continue by typing the complex operator 'CONTAINS ANY-OF' 
  4. Add the values to the query in the search bar. Each value should be enclosed in quotes and be comma-separated. All the values should be enclosed within parentheses
  5. Hit the return key to execute the search


Complex Operators and their corresponding parameters


The following table gives you the list of complex operators, their effective function (of operators) they serve, and the parameters that they can be used with: 


Complex OperatorDescriptionEffective OperatorParameter List
CONTAINS ANY OFRetrieves files that contain any of the values enteredOR(values)Body,
Subject
CONTAINS ALL OFRetrieves only files that simultaneously contain all values enteredAND(values)Body,
Subject
CONTAINS NONE OFRetrieves only files that have none of the values enteredNOT(OR(values))Body,
Subject
DOES NOT CONTAIN ALL OFRetrieves files that do not simultaneously contain all values enteredNOT(AND(values))
Body,
Subject
IS ANY OFRetrieves files that satisfy any of the values selectedOR(values)Family role,
All email address related parameters, Production,
type,
hash,
pstate,
tags,
system-tags,
custodian,
source,
privileged-category,
directory,
name.ext,
name.term,
name.dirs
IS ALL OFRetrieves only files that satisfy all of the values selectedAND(values)All email address related parameters, Production,
tags,
system-tags,
directory,
name.dirs
IS NONE OFRetrieves only files that simultaneously satisfy none of the values selected
Family role,
All email address related parameters,
Production,
type,
hash,
pstate,
tags,
system-tags,
custodian,
source,
privileged-category,
directory,
name.ext,
name.term,
name.dirs
IS-NOT ALL OFRetrieves files that do not simultaneously contain all of the values selected
All email address related parameters, Production,
tags,
system-tags,
directory,
name.dirs