Getting Specific Array Element - Meteor Mongodb

Question

I have this structure

{
"_id" : "EbtLm2Nmb79WWryEr",
"notificationByUsers" : {
    "all" : [ 
        {
            "account_id" : "X5PjY66JAwgoxDb4L",
            "date" : ISODate("2016-07-27T13:48:17.154Z"),
            "value" : null
        }, 
        {
            "account_id" : "2C2FKXaKtmeRMNT3E",
            "date" : ISODate("2016-07-27T13:53:10.296Z"),
            "value" : "Instant"
        }, 
        {
            "account_id" : "6Np35oj63cavF4RHs",
            "date" : ISODate("2016-07-28T07:18:22.696Z"),
            "value" : "Instant"
        }
    ]
}

}

and i am querying

db.Collection.findOne({_id: EbtLm2Nmb79WWryEr, 'notificationByUsers.all':{$elemMatch:{account_id: "2C2FKXaKtmeRMNT3E"}}}, {_id:0, 'notificationByUsers.all.$': 1})

it returns in roboMongo

{
 "notificationByUsers" : {
"all" : [ 
    {
        "account_id" : "2C2FKXaKtmeRMNT3E",
        "date" : ISODate("2016-07-27T13:53:10.296Z"),
        "value" : "Instant"
    }
]
}

But in Meteor it returns all array elements with this query. I want the result with specific array element as working in robomongo.

Querying client or server side with Meteor?

Julien Leray
– Julien Leray

2016-07-28 08:43:47 +00:00
Commented Jul 28, 2016 at 8:43 — Julien Leray
– Julien Leray, Commented Jul 28, 2016 at 8:43
Server Side Brother.

Mohammad Kashif Sulaiman
– Mohammad Kashif Sulaiman

2016-07-28 08:50:05 +00:00
Commented Jul 28, 2016 at 8:50 — Mohammad Kashif Sulaiman
– Mohammad Kashif Sulaiman, Commented Jul 28, 2016 at 8:50

Pankaj Jatav · Accepted Answer · 2016-07-28 08:59:35Z

1

You can do this using fields projection, like:

MyCollection.findOne({},{ fields : {_id:0, 'notificationByUsers.all':1}});

This will return object like :

{
 "notificationByUsers" : {
"all" : [ 
    {
        "account_id" : "2C2FKXaKtmeRMNT3E",
        "date" : ISODate("2016-07-27T13:53:10.296Z"),
        "value" : "Instant"
    }
]
}

answered Jul 28, 2016 at 8:59

Pankaj Jatav

2,1782 gold badges16 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mohammad Kashif Sulaiman Over a year ago

"$err" : "Can't canonicalize query: BadValue >1 field in obj: { _id: 0.0, notificationByUsers.all.$: 1.0 }" in mongodb

Pankaj Jatav Over a year ago

This is the meteor way my friend.

Collectives™ on Stack Overflow

Getting Specific Array Element - Meteor Mongodb

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related