ODBC Driver for MongoDB

Build 25.0.9434

QueryPassthrough

Determines whether queries are sent directly to MongoDB without modification.

Data Type

bool

Default Value

false

Remarks

When QueryPassthrough is set to true, the specified query can be passed to MongoDB as-is. Currently, only these shell commands are supported:

  • db.myCollection.find() returns all fields for all records in the collection.
  • db.myCollection.find({ query }) returns all fields for all records in the collection matching the query.
  • db.myCollection.find({ query }, { projection }) returns the fields in the projection, for all records matching the query.
  • All of the above forms accept a .json() suffix. This returns a single column containing the matching documents as JSON instead of individual fields.

When QueryPassthrough is set to false, the query is not sent directly to MongoDB. Instead, driver parses the query and converts it to MongoDB's native query language (MQL).

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434