Search Operators

<< Click to Display Table of Contents >>

Navigation:  CloudNine Explore > Using CloudNine Explore > Case Dashboard > Search >

Search Operators

Search Operators allow you to write your own advanced queries to garner stronger search results from your case records. Once you learn how to use Search Operators, you start utilizing complex searches that will help you locate information that might otherwise takes hours of review to uncover.

Searching in CloudNine™ LAW, CloudNine™ Explore, and CloudNine™ Explore Web is not case sensitive, so you do not have to enter all caps when typing in Search Operators. You should type spaces between search terms and the operator (LayK AND LangW), except when searching with characters or using symbols and punctuation. For more information, refer to the Search Operators table below.

There are several different types of Search Operators:

Document Level (Boolean) - Boolean operators are based on the binary logic used in computers today, producing strict true or false results. In CloudNine™ LAW, CloudNine™ Explore, and CloudNine™ Explore Web, Boolean operators search at the document level. Boolean operators used in CloudNine™ LAW, CloudNine™ Explore, and CloudNine™ Explore Web include AND, OR, and AND NOT.

Field Level (Context) - Context operators search at the field level. The search term you are trying to locate may still exist elsewhere in your case data (in another field or spreadsheet), you are just narrowing your search to one field.  CloudNine™ LAW, CloudNine™ Explore, and CloudNine™ Explore Web use the search operator CONTAINS to locate text within a specified field. An alternative to typing CONTAINS is typing double colons (::). When you use this option, you must have a space before and after the double colons.  Field names must have quotes around them. For example, when you search the Author field, your query should by typed as: "Author".

Word Level (Proximity) - Proximity operators search at the word level and are useful when looking for content that appears in records either in direct succession, adjacent order, or in close succession to each other within a specified range. This number refers to the maximum number of intervening indexed words.

Character Level (Wild-cards) - Wild-card operators are symbols you can use as a substitute for characters or series of characters in a search term, creating a broader search with stronger results.  Using wild-card characters helps you locate:

oVariations on a root word

oPossible misspellings of a name or word

oWords or names that might include punctuation (apostrophes)

Search Operators







AND contains both words

lay AND lang

Finds all records with both the words: lay and lang

OR contains either word

lay OR lang

Finds all records with either lay or lang, or both

AND NOT contains first word, but not second

lay AND NOT lang

Finds all records with lay, but not lang





lay w/5 lang

Finds lay within five words of lang

not w/12

lay not w/12 lang

Finds lay where it is not within 12 words of lang

w/5 xfirstword

lay w/5 xfirstword

Finds lay when it occurs in the first five words of a document

% performs a fuzzy search


Finds Phil, Philip, and Philllip

* Fuzzy searching finds words even if they are misspelled. The position of the % character determines how many letters at the start of the word must match exactly. For example: ba%nana must begin with ba and have at most one difference between it and banana. The query: b%%anana finds words that begin with b and have at most two differences between it and banana.

For more information, see Fuzzy Searching.

# performs a phonic search


Finds words that sounds alike, such as Smith and Smythe

For more information, see Phonic Searching.

~ stemming at the end of a word finds grammatical variations of a word



Finds manager and management

Finds applies, applied, applying

For more information, see Stemming.

& finds synonyms


Finds quickly

For more information, see Synonym Searching.

//text contains

//text contains Smith

Finds Smith within the content of the documents only.

Does not search for Smith in the a document's metadata fields.





"Filename" CONTAINS meeting

Finds meeting in the File Name field

* Text before the CONTAINS operator must be a field name and the field name must be in quotes.

** The CONTAINS operator cannot be used with  the NEAR or BEFORE operators.


"Filename" :: meeting

Short form alternative for the CONTAINS operator. Returns the same results: Finds meeting in the File Name field.

Requires a space before and after the double colons. The field name must be in quotes.




? represents any character in its place in the character sequence




Finds the following: woman, women

Finds all dates in the year 1999

Finds all timeframes of 10:00 o'clock (a.m. or p.m.), i.e. 10:00, 10:42

= matches any single digit



Finds all records that contain the number 55

Finds dates with the number 12, such as 12/01/2001 and 08/12/2005

* matches multiple characters


Finds Phil, Philip

## regular expression


Finds apple pie

Finds search terms that includes a combination of characters. A regular expression included in a search query must be in double quotes and must begin with ##.

For more information, see Regular Expressions.




<                    less than

< 50

Florida < 32803

Finds numbers less than 50

Finds Florida followed by a number less than 32803

>                    greater than

> 50

Finds numbers greater than 50

<=                  less than or equal to


Finds numbers less than or equal to 50

>=                  greater than or equal to


Finds numbers greater than or equal to 50

=                     equal to


Finds the number 50

<x and >x       not equal to

<50 and >50

Finds all numbers except 50

~~                  numeric range

10 ~~ 20

Finds any numbers between the two numbers, such as between 10 and 20

For more information, see Numeric Range Searching.


10 TO 20

Finds numbers in text within the specified range

* The TO operator requires numeric text before and after the operator.