Informix® query operators and modifier
The Informix® query operators and modifier are extensions to the MongoDB API.
Query operators
You can use the Informix® query operators in all MongoDB functions that accept query operators, for example find() or findOne().- $ifxtext
- The $ifxtext query operator is similar to the MongoDB $text operator, except that it passes the search string as-is to the bts_contains() function.
- $like
- The $like query operator tests for matching character strings and maps to the SQL LIKE query operator. For more information about the SQL LIKE query operator, see LIKE Operator.
Query modifier
You can use the Informix® query modifier in the MongoDB find() function with the addSpecial function.- $nativeCursor
- The $nativeCursor query modifier holds open a true cursor on the Informix® database server during a query. A native cursor requires more wire listener resources because connections and result set objects are tied to a single session, but the cursor guarantees consistent query results. You can control the cursor idle timeout with the cursor.idle.timeout wire listener property. For REST API queries, use the killCursors command to close the cursor.