0

My schema goes something like this:

Registration: {
    totalDue: Number,
    amountPaid: Number,
    charges: [
        {
            amount: Number,
            paymentMethod: String,
            status: String
        }
    ]
}

I am building a reporting tool, so that users can query for charges by a given amount. For example, I want to show all successful charges with amounts greater than 30.

My current query is:

db.registrations.aggregate(
    {$match: {'charges.status':'succeeded', 'charges.amount': {$gt: 30}}},
    {$unwind:'$charges'}, 
    {$match: {'charges.status':'succeeded', 'charges.amount': {$gt: 30}}},
    {$project:{'charges':1}}
)

I'm getting the correct results, which is a list of charges, but I'm also new to mongodb so I'm unsure if there is a much better way of doing this. It seems like there would be a more efficient way then using $match twice with the same criteria, once to get all registrations with correct charges, and then again to filter the actual charges.

There may be many thousands of registrations, and each having anywhere from 0 to a few hundred charges.

By the way, when I run the query on robomongo, it only shows me 50 results, and no additional pages for me to scroll through, any idea why? I'm not using $limit.

Neil Lunn
  • 148,042
  • 36
  • 346
  • 317
Jordan Hui
  • 1
  • The marked duplicate answers your first question of a better way of doing things. Your other question on Robomongo is considered off-topic as it's about a software tool. – chridam Jun 23 '16 at 19:01
  • Related http://stackoverflow.com/questions/3985214/retrieve-only-the-queried-element-in-an-object-array-in-mongodb-collection – chridam Jun 23 '16 at 19:04

0 Answers0