0 Replies Latest reply: Jul 11, 2017 11:56 AM by Fabrice Haud RSS

    Help addressing a mongodb database

    Fabrice Haud

      Hi,

       

      I'm a new user of Qlik sense trying to load data from a mongodb database using the web connector mongodb. This database is populated with test results (json format).

      I succeed in connecting to the database and in loading data from a specific collection using the script hereafter:

      MongoDBConnector_Collection:

      LOAD

       

          outcome  as Collection_outcome,

       

      FROM

      [http://localhost:5555/data?connectorID=MongoDBConnector&table=Collection&server=mongodb%3a%2f%2fxxxxxx%3xxxxxxxx%40xxxxxxxxxx%3a27017&port=27017&database=xxxxxx&collection=CTC_results&jsonQuery=%7b%22configuration.shutdown_mode%22+%3a+%22EXPLOITATION%22%7d&appID=]

      (qvx);

       

      The data I got are not detailed enough, for example for the document outcome:

      "outcome" : {
          "test_date" : "2016-11-22",
          "startTest" : "00:00.00",
          "endTest" : "00:00.00",
          "val" : 0,
          "msg" : "BS successfully configured, tested and calibrated."
      }

      The data I got is a field "Collection_outcome" with the data: { "endTest" : "2016-12-09T19:34:20.000Z", "msg" : "TX oscillator error validation issue", "startTest" : "2016-12-09T19:32:28.000Z", "val" : 801 }.

      What I want to work on is to extract the fields "test_date", "startTest", "endTest" and "val" of each documents in my database.

      Is someone able to help me?

       

      Thank you.

       

      Fabrice.