Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-14563

Filling in with documents with default values after find/aggregate

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Won't Fix
    • Icon: Major - P3 Major - P3
    • None
    • 2.7.3
    • None

    Description

      Scenario: I have a collection:

      { "name" : "A", "value" : 1, "date" : ISODate("2014-01-01T00:00:00.000Z") }
      { "name" : "B", "value" : 7, "date" : ISODate("2014-01-01T00:00:00.000Z") }
      { "name" : "A", "value" : 3, "date" : ISODate("2014-01-02T00:00:00.000Z") }
      { "name" : "B", "value" : 8, "date" : ISODate("2014-01-02T00:00:00.000Z") }
      { "name" : "B", "value" : 8, "date" : ISODate("2014-01-03T00:00:00.000Z") }
      { "name" : "A", "value" : 5, "date" : ISODate("2014-01-04T00:00:00.000Z") }
      { "name" : "A", "value" : 4, "date" : ISODate("2014-01-05T00:00:00.000Z") }

      The document for A on 3rd Jan 2014 is not available. When I do a find/aggregate on A with a date range from 1/Jul/14 to 31/Jul/14, I would like the document to appear in my result set with a default value (or value same as previous date). For example:

      { "name" : "A", "value" : 1, "date" : ISODate("2014-01-01T00:00:00.000Z") }
      { "name" : "A", "value" : 3, "date" : ISODate("2014-01-02T00:00:00.000Z") }
      { "name" : "A", "value" : 3 (or default value -1), "date" : ISODate("2014-01-03T00:00:00.000Z") }
      { "name" : "A", "value" : 5, "date" : ISODate("2014-01-04T00:00:00.000Z") }
      { "name" : "A", "value" : 4, "date" : ISODate("2014-01-05T00:00:00.000Z") }

      URL Reference: http://stackoverflow.com/questions/24752090/filling-in-with-documents-with-default-values-after-find-aggregate

      Attachments

        Activity

          People

            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            allancth Allan Cheong
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: