Full-Text Search in Node JS with Mongoose

Question

I'm trying to perform a full-text search on an array of strings in Mongoose and I am getting this error:

{ [MongoError: text index required for $text query]
  name: 'MongoError',
  message: 'text index required for $text query',
  waitedMS: 0,
  ok: 0,
  errmsg: 'text index required for $text query',
  code: 27 }

However, I do have a text index declared on the field on the User Schema and I confirmed that the text index has been created because I am using mLab. I am trying to perform a full-text search on fields

Here Is My User Schema:

var userSchema = mongoose.Schema({
        local: {
            firstName: String,
            lastName: String,
            username: String,
            password: String,
            fields: {type: [String], index: true}
        }
});

Here is My Code for the Full-Text Search:

User.find({$text: {$search: search}}, function (err, results) {
                if (err) {
                    console.log(err);
                } else {
                    console.log(results);
                }
        });

Answer 1

You need to add a text index to your schema like below:

userSchema.index({fields: 'text'});

Or use userSchema.index({'$**': 'text'}); if you want to include all string fields

Answer 2

For $text queries to work, MongoDB needs to index the field with a text index. To create this index by mongoose use

fields: {type: [String], text: true}

See here for the MongoDB documentation of text indexes.