Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "_id": "5c451b7ab5bd0fd4a6d9b4ba",
- "serviceRequestType": "Type A",
- "status": "Completed",
- "creationDate": "2014-01-18T00:00:00",
- "completionDate": "2014-01-21T00:00:00",
- "streetAddress": "5541 W CATALPA AVE"
- }
- Aggregation agg = newAggregation(
- group("serviceRequestType").addToSet("creationDate").as("start")
- .addToSet("completionDate").as("end"),
- unwind("end", "endArray"),
- unwind("start", "startArray")
- AggregationResults<Query4Result> result = mongoTemplate.aggregate(agg, "incidents", Query4Result.class);
- return result.getMappedResults();
- {_id=TypeA, start=2014-04-07T00:00:00, end=2014-05-12T00:00:00,
- endArray=0, startArray=0}
- {_id=TypeA, start=2014-04-06T00:00:00, end=2014-05-12T00:00:00,
- endArray=0, startArray=1}
- {_id=TypeA, start=2014-04-05T00:00:00, end=2014-05-12T00:00:00,
- endArray=0, startArray=2}
- {_id=TypeA, start=2014-04-07T00:00:00, end=2014-07-09T00:00:00,
- endArray=1, startArray=0}
- {_id=TypeA, start=2014-04-06T00:00:00, end=2014-07-09T00:00:00,
- endArray=1, startArray=1}
- {_id=TypeA, start=2014-04-05T00:00:00, end=2014-07-09T00:00:00,
- endArray=1, startArray=2}
- {_id=TypeB, start=2014-04-07T00:00:00, end=2014-05-23T00:00:00,
- endArray=0, startArray=0}
- {_id=TypeB, start=2014-04-06T00:00:00, end=2014-05-23T00:00:00,
- endArray=0, startArray=1}
- {_id=TypeB, start=2014-04-05T00:00:00, end=2014-05-23T00:00:00,
- endArray=0, startArray=2}
- {_id=TypeB, start=2014-04-07T00:00:00, end=2014-05-20T00:00:00,
- endArray=1, startArray=0}
- {_id=TypeB, start=2014-04-06T00:00:00, end=2014-05-20T00:00:00,
- endArray=1, startArray=1}
- {_id=TypeB, start=2014-04-05T00:00:00, end=2014-05-20T00:00:00,
- endArray=1, startArray=2}
Add Comment
Please, Sign In to add comment