Qlik MongoDB connector dataset filtering when reloading nested JSON structured data

[Andreas_Giesbrecht]

Please note that from Qlik Sense August 2022 the Qlik MongoDB connector (within the Qlik ODBC connector package) is able to filter datasets on the MongoDB server side for only 1 level nested JSON structured data.

For MongoDB collections with more than 1 level nested JSON structure (also the array must not be nested within a multidimensional array) like the following example, the filtering still happens on the Qlik engine side:

collection:

[
  {
    _id: 2,
    array: [
      [
        {
          inner_array: [
            {
              obj: {
                c1: 'a',
                c2: 'b'
              }
            }
          ]
        },
        {
          inner_array: [
            {
              obj: {
                c1: 'c',
                c2: 'd'
              }
            }
          ]
        }
      ]
    ]
  }
]

Environment

• Qlik Sense Enterprise on Windows 
• Qlik ODBC Connector Package 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.