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);
                }
        });

Which mogoose version are you using?

hzitoun
– hzitoun

2016-11-25 14:15:13 +00:00
Commented Nov 25, 2016 at 14:15 — hzitoun
– hzitoun, Commented Nov 25, 2016 at 14:15
Currently using Mongoose 4.7.0

Jasch1
– Jasch1

2016-11-25 14:17:07 +00:00
Commented Nov 25, 2016 at 14:17 — Jasch1
– Jasch1, Commented Nov 25, 2016 at 14:17
you need to create a text index on your fields: example

Mohsen ZareZardeyni
– Mohsen ZareZardeyni

2016-11-25 14:17:18 +00:00
Commented Nov 25, 2016 at 14:17 — Mohsen ZareZardeyni
– Mohsen ZareZardeyni, Commented Nov 25, 2016 at 14:17

Gal Margalit · Accepted Answer · 2020-08-16 16:31:16Z

13

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.

edited Aug 16, 2020 at 16:31

Gal Margalit

5,8646 gold badges57 silver badges60 bronze badges

answered Nov 25, 2016 at 14:22

DevDig

1,01813 silver badges19 bronze badges

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

Comments

hzitoun · Accepted Answer · 2017-06-20 12:06:25Z

8

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

edited Jun 20, 2017 at 12:06

answered Nov 25, 2016 at 14:18

hzitoun

5,8702 gold badges40 silver badges44 bronze badges

Comments

Gal Margalit · Accepted Answer · 2020-08-17 12:31:01Z

0

If for some reason adding a test index is not an option, you could also use the regex operator in your aggregation pipeline to match strings.

$regex

Provides regular expression capabilities for pattern matching strings in queries.
MongoDB uses Perl compatible regular expressions (i.e. “PCRE” ) version 8.42 with UTF-8 support.

To use $regex, use one of the following syntaxes:

{ <field>: { $regex: /pattern/, $options: '<options>' } }
{ <field>: { $regex: 'pattern', $options: '<options>' } }
{ <field>: { $regex: /pattern/<options> } }

In MongoDB, you can also use regular expression objects (i.e. /pattern/) to specify regular expressions:

{ <field>: /pattern/<options> }

edited Aug 17, 2020 at 12:31

answered Aug 17, 2020 at 12:19

Gal Margalit

5,8646 gold badges57 silver badges60 bronze badges

Collectives™ on Stack Overflow

Full-Text Search in Node JS with Mongoose

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related