Estimate/Production History Search:

The Estimate and Production History search engine utilizes a specialized database index to quickly execute text based queries. There are two search modes available:

1. Simple Search, which supports:

• Keywords
• Boolean AND , NOT operators
• Trailing Wildcards

2. Advanced Search, which supports:

• Keywords
• Phrases
• Boolean AND , NOT , OR operators
• Trailing Wildcards
• Location (proximity)

The Estimate and Production History search engine does not support searching based on symbols. Any non­-reserved symbol included in the search terms is considered to be equivalent to a space. (e.g. 15.2" Pipe = 15 2 Pipe). See the detailed sections below for more information.

Simple Search:

Keywords:

There is no special syntax for keyword searches in Simple Search.

(e.g. Search Terms = silt)

• Silt Fence 6" would return
• Silt Removal would return
• Clay Fence would not return

Multiple keywords can be entered. See AND operator section below for more details. 

Booleans
AND
Spaces are considered and operators in Simple Search. Every keyword must exist in the description for that result to be returned.

(e.g. Search Terms = Silt Fence)

• Clay Fence 6" would not return
• would returnSilt Fence 6" 
• Build Fence in silt would return

NOT
Dashes ( ‐ ) are considered NOT operators in Simple Search. Any keyword that begins with a ‘‐’ must not exist in the description for that result to be returns.

 (e.g. Search Terms = Fence ‐clay)

• Silt Fence 6" would return
• Steel Fence 6' would return
• Clay Fence 6" would not return

Combinations
Booleans can also be used in combination with each other.

 (e.g. Search Terms = Install Fence ‐Clay)

• Install silt fence would return
• Install steel fence would return
• Install clay fence would not return

Trailing Wildcards
Asterisks ( * ) are considered wildcards in Simple Search. Any keyword that ends in a * will match any word that begins with that keyword.

 (e.g. Search Terms = Install* )

• Install Fence would return
• Installed Fence would return
• Installs Fence would return
• Inst Fence would not return

Advanced Search
Advanced Search is accessed by enclosing the search terms in square brackets [] . (e.g.[Silt AND Fence] )

Keywords
Keywords can optionally be enclosed in "" . This is only necessary if the keyword is a reserved word like.  AND, OR, NOT

(e.g. Search Terms = ["silt"] )

• Silt Fence 6" would return
• Silt Removal would return
• Clay Fence would not return

Multiple keywords can be entered. See AND operator section below for more details.

Booleans
AND
Both spaces and the reserved word AND , are considered AND operators in Advanced Search. Every keyword must exist in the description for that result to be returned.

(e.g. Search Terms = [Silt AND Fence] )

• Silt Fence 6' would return
• Clay Fence 6' would not return
• Build Fence in Silt would return

OR
In advanced search, the OR operator is accessed by typing the reserved word OR . Only one of the keywords must exist in the description for that result to be returned.

(e.g. Search Terms = [Silt OR Fence] )