Advertisement
Guest User

Untitled

a guest
May 4th, 2016
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. {
  2. "_id": 681
  3. "sensors": [
  4. {
  5. "type": "foo"
  6. },
  7. {
  8. "type": "bar"
  9. }
  10. ]
  11. }
  12.  
  13. {
  14. "_id" : ObjectId("570cc8b6ac55850d5740784e"),
  15. "timestamp" : ISODate("2016-04-12T12:06:46.344Z"),
  16. "type" : "foo",
  17. "nodeid" : 681,
  18. "value" : 10
  19. }
  20.  
  21. {
  22. "_id" : ObjectId("190ac8b6ac55850d5740776e"),
  23. "timestamp" : ISODate("2016-04-12T12:06:46.344Z"),
  24. "type" : "bar",
  25. "nodeid" : 681,
  26. "value" : 20
  27. }
  28.  
  29. {
  30. "_id" : ObjectId("167bc997bb66750d5740665e"),
  31. "timestamp" : ISODate("2016-04-12T12:06:46.344Z"),
  32. "type" : "bar",
  33. "nodeid" : 200,
  34. "value" : 20
  35. }
  36.  
  37. {
  38. "_id" : ObjectId("110cc9c6ac55850d5740784e"),
  39. "timestamp" : ISODate("2016-04-09T12:06:46.344Z"),
  40. "type" : "foo",
  41. "nodeid" : 681,
  42. "value" : 12
  43. }
  44.  
  45. {
  46. "_id": 681
  47. "sensors": [
  48. {
  49. "_id" : ObjectId("570cc8b6ac55850d5740784e"),
  50. "timestamp" : ISODate("2016-04-12T12:06:46.344Z"),
  51. "type" : "foo",
  52. "nodeid" : 681,
  53. "value" : 10
  54. },
  55. {
  56. "_id" : ObjectId("190ac8b6ac55850d5740776e"),
  57. "timestamp" : ISODate("2016-04-12T12:06:46.344Z"),
  58. "type" : "bar",
  59. "nodeid" : 930,
  60. "value" : 20
  61. }
  62. ]
  63. }
  64.  
  65. db.nodes.aggregate(
  66. [
  67. {
  68. $unwind: "$sensors"
  69. },
  70. {
  71. $match:{
  72. nodeid: 681
  73. }
  74. },
  75. {
  76. $lookup:{
  77. from: "values", localField: "sensors.type", foreignField: "type", as: "sensors"
  78. }
  79. }
  80. }
  81. ]
  82. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement