Text search with compound maybe

Jakab_Gipsz · 2024-01-08T15:55:56.441Z

Hey,

I’m sorry, I speak a little English.

This is my PHP code:

    $questions = $mongo->find_array('faq_questions',
      array(
        '$text' => array(
          '$search' => 'pénz',
          '$caseSensitive' => false,
          '$diacriticSensitive' => true
        ),
      ), array(
        'projection' => array('score' => array('$meta' => 'textScore')),
        'sort' => array('score' => array('$meta' => 'textScore')),
      )
    );

It works, but not fully. Mongo version: 3.6.8

My data in faq_questions collection:

_id                      question    answer
658eb9d5a663443da35493c2 pénz        etc
658ee1dda663443da35493c3 papírpénz   xyz
658eedf8a663443da35493c4 pénzcsipesz abc

The result only 1, the first: “pénz”

… but I would like see all (3).

My index creation:

 db.faq_questions.createIndex(
  {
    question: "text",
    answer: "text"
  },
  {
    default_language: "hungarian",
    weights: {
      question: 10,
      answer: 5
    },
    name: "text_index"
  }
 );

Please help me. Thanks.

Jakab_Gipsz · 2024-01-08T17:09:40.169Z

Query help is enough with index creation. Not need PHP help and not need Hungarian help. English query is okay, example:

Keyword: “room” (not “pénz”)

Data:

room (not "pénz")
bathroom (not "papírpénz")
roommate (not "pénzcsipesz")

If I search “room”, I would like see all (3) results.