- Operator Reference
Operator List
Topical List - Query Language
Introduction
Summary
Operators
Tips, Questions, and Answers - Main Index
Index
Tutorial
API Functions
Query Language
Technology Overview
Contact Us - Other Products
Onix Text Search and Retrieval Engine
Brevity Document Summarizer
Lextek Document Profiler & Categorizer
RouteX Document Routing Engine
Lextek Language Identifier
GATE
Name
GATE
Synopsis
If there is a hit in a record for the first term it returns any hits for that record in the second term. Optionally if there isn't a hit for a record in the first term it returns any hits for that record in a third term
Arguments
Comparison term or subquery
Result if found term or subquery
Result if not found term or subquery [optional]
Ranking Scheme
Returns weight of hit.
Comments
Gate is like an "if-then-else" construct in programming languages. It functions, however, on the record level rather than on the expression level. If the first term is present, return the second term, else return the third term.
For each record, if there is a hit in the first term, then any hits for that record in the second term are returned (along with their respective weights). If there is no hit for the first term in that record and a third term was passed to the operator, then any hits that third term has for that record are returned.
Example
GATE( 'blue', 'green', 'red' );
See Also