- 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
IIF
Name
IIF
Synopsis
If there are any hits in the first term then it returns all the hits for the second term. Optionally if a third term was passed and no hits were in the first term then all the hits in the third term are returned.
Arguments
Comparison term or subquery
Result if found term or subquery
Result if not found term or subquery [optional]
Ranking Scheme
Doesn't modify weights.
Comments
IIF is like an "if-then-else" construct in programming languages. It functions, however, over all indexed terms rather than on the record level. If the first term is present, return the second term, else return the third term.
If you need an "if-statement" that functions on each record rather than simply checking if there are any hits, please use GATE.
Example
IIF( 'blue', 'green', 'red' );
See Also