Enable Mixed Type Filter

This option specifies whether the connector uses mixed type filtering, which allows a value to pass the filter even if it is not the same data type as the specified filter term.

  • Enabled (1): When filtering data, the connector retrieves all values that match the specified filter term, even if the values are stored as different data types than the filter term. For example, if the data store contains "1000" as a NumberInt value and also as a String value, when you execute a query that filters for "1000" as a String value, the connector returns both the NumberInt and String values.
  • Disabled (0): When filtering data, the connector only retrieves values that match the data type of the specified filter term. For example, if the data store contains "1000" as a NumberInt value and also as a String value, when you execute a query that filters for "1000" as a String value, the connector only returns the String value.
    Note:

    Mixed type filtering requires the connector to scan the entire MongoDB collection. You can disable this feature to increase the connector's performance, but note that doing so also alters the results of your queries.

Key Name Default Value Required

EnableMixedTypeFilter

Selected (1)

No