MongoDB: Single result when searching array value

Question

I have a document containing a list of keywords which I want to search on, however Mongo only ever returns a single result even though there are many documents which contain the same keyword.

The documents look something like this:

{
    _Id: 51192567f5e65101d471c46b
    Name: "Cat",
    KeyWords: ["cat", "animal", "small"]
}

I am searching the database in the mongo shell using the following:

db.Resources.find({"KeyWords":"cat"})

I wanted to get back all documents where the KeyWords array contains cat (there are many), however I just get one document.

The schema in my example isn't the actual schema I'm working with, if I create a simple schema as above the search works as expected; there must be something in my full schema that's not quite right — Dale
– Dale, Commented Feb 12, 2013 at 10:58
I know it might sound obvious but do all documents in the collection have exactly the same structure? — br3w5
– br3w5, Commented Feb 12, 2013 at 11:19

Dis Shishkov · Accepted Answer · 2013-02-12 11:32:11Z

1

I have just checked in my local DB, so please review your structure MongoDB

answered Feb 12, 2013 at 11:32

Dis Shishkov

6567 silver badges21 bronze badges

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

Comments

Dale · Accepted Answer · 2013-02-12 11:37:34Z

0

Thanks for the replies; after much hunting, it turns out there was a piece of code in the program I'm using to load the data that only stores a single occurrence of any keyword, so although all documents appear to have lots of keywords, each keyword will only appear in a single document!! I was looking at the original data which had the keywords repeated between documents before the program stripped them out.

Data load failure!!!

answered Feb 12, 2013 at 11:37

Dale

1,7412 gold badges20 silver badges30 bronze badges

Collectives™ on Stack Overflow

MongoDB: Single result when searching array value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related