Guest User

Untitled

a guest
Jan 22nd, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. {
  2. "_id": "5c451b7ab5bd0fd4a6d9b4ba",
  3. "serviceRequestType": "Type A",
  4. "status": "Completed",
  5. "creationDate": "2014-01-18T00:00:00",
  6. "completionDate": "2014-01-21T00:00:00",
  7. "streetAddress": "5541 W CATALPA AVE"
  8. }
  9.  
  10. Aggregation agg = newAggregation(
  11. group("serviceRequestType").addToSet("creationDate").as("start")
  12. .addToSet("completionDate").as("end"),
  13. unwind("end", "endArray"),
  14. unwind("start", "startArray")
  15.  
  16. AggregationResults<Query4Result> result = mongoTemplate.aggregate(agg, "incidents", Query4Result.class);
  17.  
  18. return result.getMappedResults();
  19.  
  20. {_id=TypeA, start=2014-04-07T00:00:00, end=2014-05-12T00:00:00,
  21. endArray=0, startArray=0}
  22. {_id=TypeA, start=2014-04-06T00:00:00, end=2014-05-12T00:00:00,
  23. endArray=0, startArray=1}
  24. {_id=TypeA, start=2014-04-05T00:00:00, end=2014-05-12T00:00:00,
  25. endArray=0, startArray=2}
  26. {_id=TypeA, start=2014-04-07T00:00:00, end=2014-07-09T00:00:00,
  27. endArray=1, startArray=0}
  28. {_id=TypeA, start=2014-04-06T00:00:00, end=2014-07-09T00:00:00,
  29. endArray=1, startArray=1}
  30. {_id=TypeA, start=2014-04-05T00:00:00, end=2014-07-09T00:00:00,
  31. endArray=1, startArray=2}
  32.  
  33.  
  34. {_id=TypeB, start=2014-04-07T00:00:00, end=2014-05-23T00:00:00,
  35. endArray=0, startArray=0}
  36. {_id=TypeB, start=2014-04-06T00:00:00, end=2014-05-23T00:00:00,
  37. endArray=0, startArray=1}
  38. {_id=TypeB, start=2014-04-05T00:00:00, end=2014-05-23T00:00:00,
  39. endArray=0, startArray=2}
  40. {_id=TypeB, start=2014-04-07T00:00:00, end=2014-05-20T00:00:00,
  41. endArray=1, startArray=0}
  42. {_id=TypeB, start=2014-04-06T00:00:00, end=2014-05-20T00:00:00,
  43. endArray=1, startArray=1}
  44. {_id=TypeB, start=2014-04-05T00:00:00, end=2014-05-20T00:00:00,
  45. endArray=1, startArray=2}
Add Comment
Please, Sign In to add comment