Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-1771

Reading data from View (more details on description tab)

    • Type: Icon: Question Question
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None

      i have data in my collection in below format
      {
      "_id" : ObjectId("59a7ff69e01fee556442c309"),
      "TestData" : [

      { "Policy" : null, "Type" : "Upfront", "AccrualDate" : "2004-07-29", "ReceivableDate" : "2004-07-29", "IsOverriden" : false, "IsUpfront" : true, "AmountReceived" : null, "ReceivedDate" : null, "AmountDue" : 0.0, "ParBalance" : 6160000.0, "AccrualDateTo" : "2004-07-29", "IsUncollectible" : false, "AccrualRate" : 1.0, "ReceivedRate" : null, "StatusChangeComment" : null, "ReceivedStatus" : "TrueOutstanding", "Discriminator" : "1" }

      ,

      { "Policy" : null, "Type" : "Upfront", "AccrualDate" : "2004-08-01", "ReceivableDate" : "2004-07-29", "IsOverriden" : false, "IsUpfront" : true, "AmountReceived" : 148288.64, "ReceivedDate" : "2004-09-24", "AmountDue" : 148289.0, "ParBalance" : 6160000.0, "AccrualDateTo" : "2004-08-01T00:00:00", "IsUncollectible" : false, "AccrualRate" : 1.0, "ReceivedRate" : null, "StatusChangeComment" : null, "ReceivedStatus" : "Received", "Discriminator" : "1" }

      ]
      }
      --on top of this collection i have created view to retrieve the Premiums data below is the view script

      db.createView("TestView","Mycollection",[ { $project: { "Type": "$TestData.Type","AccrualDate":"$TestData.AccrualDate","ReceivableDate":"$TestData.ReceivableDate",
      "IsOverriden":"$TestData.IsOverriden","IsUpfront":"$TestData.IsUpfront","AmountReceived":"$TestData.AmountReceived","ReceivedDate":"$TestData.ReceivedDate","AmountDue":"$TestData.AmountDue",
      "ParBalance":"$TestData.ParBalance","AccrualDateTo":"$TestData.AccrualDateTo","IsUncollectible":"$TestData.IsUncollectible","AccrualRate":"$TestData.AccrualRate",
      "ReceivedRate":"$TestData.ReceivedRate","StatusChangeComment":"$TestData.StatusChangeComment","ReceivedStatus":"$TestData.ReceivedStatus"
      }} ])

      Now i am reading data from view using SSIS , i am getting data in below format in single row

      59a7ff69e01fee556442c309 ["Upfront", "Upfront"] ["2004-07-29", "2004-08-01"] ["2004-07-29", "2004-07-29"] [false, false] [true, true] [null, 148288.64000000001] [null, "2004-09-24"] [0.0, 148289.0] [6160000.0, 6160000.0] ["2004-07-29", "2004-08-01"] [false, false] [1.0, 1.0] [null, null] [null, null] ["TrueOutstanding", "Received"]

      we have two records in test data object we need single row for each record.

            Assignee:
            kelsey.schubert@mongodb.com Kelsey Schubert
            Reporter:
            vkuriminelli vijayakumar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: