基于多个子文档的MongoDB / Mongoose查询(MongoDB/Mongoose query based on multiple subdocuments)

 我是MongoDB和Mongoose的新手。 我目前正在构建一个具有客户端集合的应用程序，该集合包含客户端拥有的一系列帐户。 
 
 我想根据客户端帐户的具体情况查询集合。 例如，我需要返回以下客户端： 
 
 
 
 clientType：“标准” 
 
 
 有两个帐户： 
  
 
   
 accountType：“FML”，余额：$ gt 3000 
 
   
 accountType：“OMG”，余额：$ lt 3000 
 
  
 
 
 以下是示例文档： 
 
{
    clientDetails: {
        cardNumber: "0123456",
        firstName: "Bob",
        lastName: "Dole",
        clientType: "Standard"
    },
    accounts: [
        {
            accountNumber: "123",
            accountType: "FML",
            balance: 4000.00
        },
        {
            accountNumber: "234",
            accountType: "OMG",
            balance: 2000
        }
    ]
}
 
 到目前为止，我只是想出了如何构建一个查询，可以使用accountTypes [“FML”，“OMG]获取clientType”Standard“的客户端，但我无法弄清楚如何为特定的指定平衡条件accountTypes。 
 
ClientModel
    .find({
        "clientDetails.clientType": "Standard",
        "accounts.accountType": { $all ["FML", "OMG"]
    })
    .then(
        function(){ //etc..},
        function(err){ //etc...}
    );

I'm brand new to MongoDB and Mongoose. I'm currently building an app that has a client collection that contains an array of accounts that the client has.
 
I'd like to query the collection based on specifics of the accounts the client has. For example, I need to return the client that is: 
 
 
 
clientType: "Standard"
 
 
Has two accounts: 
  
 
   
accountType: "FML", balance: $gt 3000
 
   
accountType: "OMG", balance: $lt 3000
 
  
 
 
Below is a sample document:
 
{
    clientDetails: {
        cardNumber: "0123456",
        firstName: "Bob",
        lastName: "Dole",
        clientType: "Standard"
    },
    accounts: [
        {
            accountNumber: "123",
            accountType: "FML",
            balance: 4000.00
        },
        {
            accountNumber: "234",
            accountType: "OMG",
            balance: 2000
        }
    ]
}
 
So far, I've only figured out how to build a query that can get a client of clientType "Standard" with accountTypes ["FML","OMG] but I can't figure out how to specify the balance condition for the specific accountTypes.
 
ClientModel
    .find({
        "clientDetails.clientType": "Standard",
        "accounts.accountType": { $all ["FML", "OMG"]
    })
    .then(
        function(){ //etc..},
        function(err){ //etc...}
    );

原文：https://stackoverflow.com/questions/43766481