Text query through referenced objects with MongoDB

Question

I have the following structure.

books collection:

{
    _id: "book_1",
    title: "How to build a house",
    authorId: "author_1"
}

{
    _id: "book_2",
    title: "How to plant a tree",
    authorId: "author_2"
}

authors collection:

{
    _id: "author_1",
    name: "Adam Adamson"
}

{
    _id: "author_2",
    name: "Brent Brentson"
}

I want to make a case insensitive free text search with the string "b" through the books collection and find all books that either has the "b" in the title or has an author with "b" in the name.

I can embed the author in the book object just to be able to make the query. But if the author name changes in the authors collection, the embedded authors object will have the wrong name.

{
    _id: "book_2",
    title: "How to plant a tree",
    authorId: "author_2",
    author:
    {
        name: "Brent Brentson"
    }
}

What would be a good way to solve this problem?

chridam · Accepted Answer · 2015-06-05 09:30:15Z

3

You could use the following queries where the first gets the array of author ids that match the given regex expression query on the authors collection (using the map() method of the find() cursor) and the second query applies that array in the books collection query using the $in operator as well as using the regex pattern to find books that have "b" in the title:

var authorIds = db.authors.find({"name": /b/i}).map(function (doc) {return doc._id}); 
db.books.find({$or: [{"title": /b/i}, {"authorId": {"$in": authorIds} }]})

Result:

/* 0 */
{
    "_id" : "book_1",
    "title" : "How to build a house",
    "authorId" : "author_1"
}

/* 1 */
{
    "_id" : "book_2",
    "title" : "How to plant a tree",
    "authorId" : "author_2"
}

-- UPDATE --

Thanks to @yogesh for suggesting another approach which uses the distinct() method to get the author ids list:

var authorIds = db.authors.distinct("_id", {"name": /b/i})

edited Jun 5, 2015 at 9:30

answered Jun 5, 2015 at 9:04

chridam

104k26 gold badges246 silver badges243 bronze badges

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

2 Comments

Neo-coder Over a year ago

this also works var authorIds = db.authors.distinct("_id",{"name": /b/i})

chridam Over a year ago

@yogesh Nice one, would be a great alternative too.

Collectives™ on Stack Overflow

Text query through referenced objects with 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