Search in subdocument

Question

Hello I want to get all the contacts with syncFlag true in contact object.

I tried this solution but only returns only one sub document

and I also tried this solution it returns all the documents either they are matched or not

How to find document and single subdocument matching given criterias in MongoDB collection

Here is the sample document

{
    "_id" : ObjectId("57ce7d6c7387d533bfa2d45c"),
    "ITBCompanyId" : 2608,
    "updatedAt" : ISODate("2016-09-06T12:19:35.972Z"),
    "createdAt" : ISODate("2016-09-06T08:25:16.325Z"),
    "name" : "This is test",
    "identifier" : "THDNOM2",
    "addressLine1" : "Valencia Lahore",
    "syncFlag" : true,
    "orgId" : "1",
    "deletedAt" : null,
    "whois" : [ 
        {
            "test" : "noman"
        }
    ],
    "configuration" : [ 
        {
            "test" : "noman"
        }
    ],
    "contact" : [ 
        {
            "firstName" : "Active",
            "_id" : ObjectId("57ceb04811f005420b7ed54a"),
            "syncFlag" : false,
            "communicationItems" : [],
            "customFields" : []
        }, 
        {
            "firstName" : "Active",
            "_id" : ObjectId("57ceb04811f005420b7ed54b"),
            "syncFlag" : false,
            "communicationItems" : [],
            "customFields" : []
        }, 
        {
            "firstName" : "Active",
            "_id" : ObjectId("57ceb44b5f8b534bc312aacd"),
            "syncFlag" : true,
            "communicationItems" : [],
            "customFields" : []
        }, 
        {
            "firstName" : "Active",
            "_id" : ObjectId("57ceb457f141fd4c1c98a748"),
            "syncFlag" : true,
            "communicationItems" : [],
            "customFields" : []
        }
    ],
    "agreement" : [ 
        {
            "test" : "noman"
        }
    ],
    "companySite" : [ 
        {
            "test" : "noman"
        }
    ],
    "companyNote" : [ 
        {
            "test" : "noman"
        }
    ],
    "type" : {
        "name" : "Client"
    },
    "status" : {
        "name" : "Active"
    },
    "id" : "19493",
    "__v" : 0,
    "_info" : {
        "updatedBy" : "Omer",
        "lastUpdated" : ISODate("2016-09-06T11:52:07.000Z")
    }
}

Expected Output:

 ITBCompanyId: 1,
    contact: [{
               "firstName" : "Active",
                "_id" : ObjectId("57ceb04811f005420b7ed54b"),
                "syncFlag" : true,
                "communicationItems" : [],
                "customFields" : []

    }]

@tarashypka I told in question I only want to found contact objects with syncFlag true — Noman Maqsood, Sep 06 '16 at 12:51
then your expected output should contain two objects as: `{ "firstName" : "Active", "_id" : ObjectId("57ceb44b5f8b534bc312aacd"), "syncFlag" : true, "communicationItems" : [], "customFields" : [] }, { "firstName" : "Active", "_id" : ObjectId("57ceb457f141fd4c1c98a748"), "syncFlag" : true, "communicationItems" : [], "customFields" : [] }` — Smita Ahinave, Sep 06 '16 at 12:58
Do you want `"ITBCompanyId"`, `"updatedAt"` and other fields to be in the output for each document from the collection? Or you want only an array of unique contacts for all documents in the collection? — mr.tarsa, Sep 06 '16 at 12:58
I only want array of contacts which have syncFlag true, and yes I want ITBCompanyId — Noman Maqsood, Sep 06 '16 at 13:05

score 0 · Accepted Answer · edited May 23 '17 at 12:08

0

Try this. You should get the document as required. Below I have used an aggregate query to format the mongodb response as required. For more information regarding mongodb aggregate, you can refer this. I reffered this stack overflow post for forming this query.

db.companies.aggregate(
    { $match: {"contact.syncFlag": true }},
    { $unwind: '$contact'},
    { $match: {"contact.syncFlag": true }},
    { $group: { 
            _id: '$_id',  
            contact: {$push: '$contact'},
    }
});

If you want all the other fields included in the document. You can try this.

db.companies.aggregate(
    { $match: {"contact.syncFlag": true }},
    { $unwind: '$contact'},
    { $match: {"contact.syncFlag": true }},
    { $group: { 
        _id: '$_id', 
        ITBCompanyId: {$first: '$ITBCompanyId'}, 
        updatedAt: {$first: '$updatedAt'}, 
        createdAt: {$first: '$createdAt'}, 
        name: {$first: '$name'}, 
        identifier: {$first: '$identifier'}, 
        addressLine1: {$first: '$addressLine1'}, 
        syncFlag: {$first: '$syncFlag'}, 
        orgId: {$first: '$orgId'}, 
        deletedAt: {$first: '$deletedAt'}, 
        whois: {$first: '$whois'}, 
        configuration: {$first: '$configuration'}, 
        contact: {$push: '$contact'},
        agreement: {$first: '$agreement'},
        companySite: {$first: '$companySite'},
        companyNote: {$first: '$companyNote'},
        type: {$first: '$type'},
        status: {$first: '$status'},
        id: {$first: '$id'},
        _info: {$first: '$_info'},
    }
});

edited May 23 '17 at 12:08

Community

1
1

answered Sep 06 '16 at 13:06

Ananth Pai

1,939
14
15

One solution is for limited fields and the other is for when all fields are included. – Ananth Pai Sep 06 '16 at 13:15
1

Don't copy paste the exact same query..change the collection name to the appropriate name of your collection, in my answer I have given the name of the collection as companies. – Ananth Pai Sep 06 '16 at 13:19
Sir for your kind information I know I have to change the collection name as per my collection name. But it did not work that's why I pasted it here. And I am asking you the question why the both solution did not work, and look what you are answering which is very obvious – Noman Maqsood Sep 06 '16 at 14:11
{ "result" : [ { "_id" : ObjectId("57ce7d6c7387d533bfa2d45c"), "contact" : [ { "firstName" : "Active", "_id" : ObjectId("57ceb44b5f8b534bc312aacd"), "syncFlag" : true, "communicationItems" : [ ], "customFields" : [ ] }, { "firstName" : "Active", "_id" : ObjectId("57ceb457f141fd4c1c98a748"), "syncFlag" : true, "communicationItems" : [ ], "customFields" : [ ] } ] } ], "ok" : 1 } – Ananth Pai Sep 06 '16 at 14:15
The response I had obtained using the first query – Ananth Pai Sep 06 '16 at 14:16

Search in subdocument

1 Answers1