Mongodb, NodeJs and Mongoose: Get inner object where inner Object value='search value'

Question

Example first:

{ "_id" : ObjectId("4f086809bf28fd7bb56e6059"), "admins" : [ "4ef8e785b2694c3649000001" ], "pages" : [
    {
        "pagename" : "home",
        "title" : "homepage",
        "default" : true
    },
    {
        "pagename" : "people",
        "title" : "Staff",
        "default" : false
    }
], "sitename" : "Site", "sitenameLower" : "site" }

So that's the document I'm querying, now what I want is to return the 'page' where pagename = 'home'.

I've tried various queries but it always returns the whole document and not the individual object inside the pages array - which is not much use to me.

Including:

db.sites.find({'pages.pagename' : 'home'});

I can see, why this is wrong, but getting it right, is perplexing me.

Community · Accepted Answer · 2017-05-23 10:24:22Z

0

See this question. Looks like it's a planned feature but you can't do it right now.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Jan 9, 2012 at 20:53

hross

3,6812 gold badges29 silver badges32 bronze badges

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

1 Comment

mrdnk Over a year ago

Thanks, ok I'll just refactor it, into another collection of pages. I've actually been thinking about how I do subsites and pages, so I may need to refactor it anyway... so that I have a collection of site items, namely pages, subsites, other lists.

Collectives™ on Stack Overflow

Mongodb, NodeJs and Mongoose: Get inner object where inner Object value='search value'

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related