Skip to content

Instantly share code, notes, and snippets.

@novalagung
Created December 22, 2017 03:35
Show Gist options
  • Save novalagung/b8632f616475bf4e27e1bb525ef8d113 to your computer and use it in GitHub Desktop.
Save novalagung/b8632f616475bf4e27e1bb525ef8d113 to your computer and use it in GitHub Desktop.
var portfolioMaster = db.getCollection('RAW_CORE_PROJECT').aggregate([
{ $group: {
_id: {
ProgramID: "$PROGRAM_ID",
Portfolio: "$PORTFOLIO_NAME",
}
} },
{ $project: {
ProgramID: "$_id.ProgramID",
Portfolio: "$_id.Portfolio",
_id: 0
} }
]).toArray()
db.getCollection('Initiative').find({ InitiativeType: "ITO" }).forEach(function (d) {
var masterFound = portfolioMaster.find(function (g) { return g.ProgramID == d.ClarityId })
if (typeof masterFound !== 'undefined') {
d.Portofolio = masterFound.Portfolio // haruse portfolio, typo, ben kah
db.getCollection('Initiative').save(d)
}
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment