Guest User

Untitled

a guest
Dec 11th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. [
  2. {
  3. name:"member1",
  4. activity:"activity1",
  5. selected:true
  6. },
  7. {
  8. name:"member1",
  9. activity: "activity3",
  10. selected:false
  11. },
  12. {
  13. name:"member2",
  14. activity:"activity2",
  15. selected:true
  16. },
  17. {
  18. name:"member2",
  19. activity: "activity4",
  20. selected:false
  21. }
  22.  
  23. ]
  24.  
  25. [
  26. {
  27. name:"member1",
  28. activities:[true,null,false,null]
  29. },
  30. {
  31. name:"member2",
  32. activities:[null,true,null,false]
  33. }
  34. ]
  35.  
  36. db.collection("MemberActivities").aggregate(
  37. [
  38. {
  39. $group:
  40. {
  41. _id: "$MemberName",
  42. activities: { $push: "$selected"}
  43. }
  44. }
  45. ]
  46.  
  47. [
  48. {
  49. _id:"member1",
  50. activities:[true,false]
  51. },
  52. {
  53. _id:"member2",
  54. activities:[true,false]
  55. } ]
Add Comment
Please, Sign In to add comment