MongoDB Aggregation Framework - Various Example Queries

mongo_aggregation.js

// http://docs.mongodb.org/manual/reference/operator/aggregation/

db.agencyProfiles.aggregate( [
    { $match: {"_id":"Florida SUI Wage"} },
    { $unwind: "$agencyErrors" },
    { $project: {_id:0, agencyErrors: {errorDescription:1, cannedAction:{actionCodeDescription:1}}}}
] )



db.outboundAcksInfo.aggregate( [
    { $match: {"uniqueFilingIdentifier":"Minnesota SUI Wage",
               "outBoundFileName": "009300161ta7"
               } 
    },
    { $unwind: "$ackIdLineInfo" },
    { $project: {"_id": 0, ackIdLineInfo: {ackId: 1, startLineNumber:1, } } } 
] )




db.outboundAcksInfo.aggregate( [
    { $match: {"uniqueFilingIdentifier":"Minnesota SUI Wage",
               "outBoundFileName": "009300161ta7"
               } 
    },
    { $unwind: "$ackIdLineInfo" },
    { $match: {"ackIdLineInfo.startLineNumber":2970} },
    { $project: {"_id": 0, ackIdLineInfo: {ackId: 1, startLineNumber:1, } } } 
] )



db.outboundAcksInfo.aggregate( [
    { $match: {"uniqueFilingIdentifier":"Minnesota SUI Wage",
               "outBoundFileName": "009300161ta7"
               } 
    },
    { $unwind: "$ackIdLineInfo" },
    { $match: { "ackIdLineInfo.startLineNumber": {$lte:3190},
                "ackIdLineInfo.endLineNumber": {$gte:3190}
               } 
    },
    { $project: {"_id": 0, ackIdLineInfo: {ackId: 1, startLineNumber:1, endLineNumber:1} } } 
] )