Get Array element from JSON array from mongodb document

Question

{
"employees" : [ 
    {
        "name" : "XXX",
        "id" : "1",
        "Salary" : [ 
            {
                "Month" : "XXXX",
                "Amount" : "XXXX",
            }, 
            {
                "Month" : "XXXX",
                "Amount" : "XXXX",
            }, 
            {
                "Month" : "XXXX",
                "Amount" : "XXXX",
            }
        ]
    }, 
    {
        "name" : "YYY",
        "id" : "2",
        "Salary" : [ 
            {
                "Month" : "YYYY",
                "Amount" : "YYYY",
            }, 
            {
                "Month" : "YYYY",
                "Amount" : "YYYY",
            }, 
            {
                "Month" : "YYYY",
                "Amount" : "YYYY",
            }
        ]
    }
],
}

This is sample of json format in mongodb document. I want to get the result as a one particular element from employees Array that search by name I tried these methods

db.abc.find({"employees.name": "XXX"},{employees: {$elemMatch: {name: "XXX"}}});

and

db.abc.find({ employees: { $elemMatch: { name: "XXX"} } })

none of those won't work. those methods give whole document as a result. can anyone give me a solution on that.

Januka samaranyake · Accepted Answer · 2016-09-28 10:54:02Z

1

Try this

db.abc.find({"employees.name": "XXX"},{"employees.$":1})

edited Sep 28, 2016 at 10:54

Januka samaranyake

2,6072 gold badges34 silver badges54 bronze badges

answered Sep 28, 2016 at 6:56

Vaibhav Patil

3,0915 gold badges17 silver badges24 bronze badges

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

4 Comments

Januka samaranyake Over a year ago

Yh. That works. Can you help me to do this with indexing

Vaibhav Patil Over a year ago

Please elaborate what you want to do?

Januka samaranyake Over a year ago

Serch this using indexing

Vaibhav Patil Over a year ago

You have to set indexing first db.abc.ensureIndex({"employees.name" : 1}).

Collectives™ on Stack Overflow

Get Array element from JSON array from mongodb document

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related