Operators

The MongoDB operators that are supported by HCL OneDB™ are sorted into logical areas.

MongoDB operators are supported on both JSON collections and relational tables, unless explicitly stated otherwise.

If the wire listener determines the accessed entity is a relational table, it converts the basic MongoDB operators on that table to SQL, and then converts the returned values back into a JSON document. The initial access to an entity results in an extra call to the HCL OneDB server. However, the wire listener caches the name and type of an entity so that subsequent operations do not require an extra call.