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

Selects all workflows with unique repoUrl and path values

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