Why doesn't MongoDB full-text search on multiple fields work?

Question

JavaScript

Hello. Can you please tell me why the full-text search in MongoDB for several fields does not work? Where did I go wrong in the code?
I have three documents.

{
    "_id": {
        "$oid": "5d7f70d46b647c1a74d9b8aa"
    },
    "firstName": "user",
    "lastName": "one",
    "phoneNumber": "[phone]",
    "city": "Москва",
    "userId": {
        "$oid": "5d5ea4596886b1107c2be849"
    },
    "__v": 0
}


{
    "_id": {
        "$oid": "5d7f70d46b647c1a74d9b8aa"
    },
    "firstName": "user",
    "lastName": "two",
    "phoneNumber": "[phone]",
    "city": "Сочи",
    "userId": {
        "$oid": "5d5ea4596886b1107c2be849"
    },
    "__v": 0
}


{
    "_id": {
        "$oid": "5d7f70d46b647c1a74d9b8aa"
    },
    "firstName": "user",
    "lastName": "two",
    "phoneNumber": "[phone]",
    "city": "Москва",
    "userId": {
        "$oid": "5d5ea4596886b1107c2be849"
    },
    "__v": 0
}

For example, the following line comes to my input: The
'ne чи'
search result is expected for all documents and the following fields in these documents:

firstName
lastName
city

Result:

{
    "_id": {
        "$oid": "5d7f70d46b647c1a74d9b8aa"
    },
    "firstName": "user",
    "lastName": "one",
    "phoneNumber": "[phone]",
    "city": "Москва",
    "userId": {
        "$oid": "5d5ea4596886b1107c2be849"
    },
    "__v": 0
}


{
    "_id": {
        "$oid": "5d7f70d46b647c1a74d9b8aa"
    },
    "firstName": "user",
    "lastName": "two",
    "phoneNumber": "[phone]",
    "city": "Сочи",
    "userId": {
        "$oid": "5d5ea4596886b1107c2be849"
    },
    "__v": 0
}

The model looks like this:

const mongoose = require('mongoose')

const bookSchema = new mongoose.Schema(
  {
    firstName: {
      type: String,
      required: true
    },
    lastName: {
      type: String,
      required: true
    },
    city: {
      type: String,
      required: true
    },
    phoneNumber: {
      type: String,
      required: true
    },
    userId: {
      type: mongoose.Schema.Types.ObjectId,
      ref: 'User'
    }
  }
)

// Define our indexes
bookSchema.index({
  firstName: 'text',
  lastName: 'text',
  city: 'text'
})

module.exports = mongoose.model('Book', bookSchema)

controller:

exports.searchBook = async (req, res, next) => {

  const term = 'ne чи'
  console.log(term)

  const books = await Book.find({
    $text: {
      $search: term
    }
  }, {
    score: { $meta: 'textScore' }
  })
  .sort({
    score: { $meta: 'textScore' }
  })

  console.log('books', books)
}

The result is an empty array. Even if you pass, for example: 'Sochi', then an empty string will also be returned.
What am I doing wrong.
The source I referred to?
https://stackoverflow.com/questions/24714166/full-...

Answer 1

one field ok?