Details
-
New Feature
-
Resolution: Won't Fix
-
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
Issue Links
- is documented by
-
DOCS-8998 Filling in with documents with default values after find/aggregate
-
- Closed
-