MongoDB Queries

Jump to bottom

Mark Robinson edited this page Aug 9, 2017 · 5 revisions

This is a page to design MongoDB queries for #117

Gets grouped values of retrievedFrom.branch where retrievedFrom.repoUrl and retrievedFrom.path are the same

db.workflow.aggregate(
  [
    {
      $group: {
        _id: {"retrievedFrom.repoUrl": "$retrievedFrom.repoUrl", "retrievedFrom.path": "$retrievedFrom.path"},
        branch: { '$addToSet': '$retrievedFrom.branch' }
      }
    }
  ]
)