Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-28880

Issue in Text Search Index

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Works as Designed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Text Search
    • Labels:
      None

      Description

      Hi there,

      I am facing an issue in Text Search.

      My Text Search Index is

      {
              "v" : 1,
              "key" : {
                  "_fts" : "text",
                  "_ftsx" : 1
              },
              "name" : "ms.products",
              "ns" : "rajeshtesh.ms.products",
              "weights" : {
                  "brand" : 50,
                  "categories" : 30,
                  "collections" : 20,
                  "description" : 4,
                  "name" : 500
              },
              "default_language" : "english",
              "language_override" : "language",
              "textIndexVersion" : 3
       }
      

      And I am posting a query to search idli word in it

      db.ms.products.find({ publish: '1', '$text': { '$search': "idli" }}, {name: 1, score: { '$meta': 'textScore' }}).sort({score : { '$meta': 'textScore' }})
      

      *Query Result is : *

      *{ "_id" : ObjectId("58824b8e254a2a001496fb9b"), "name" : "ID WHEAT PAROTA", "score" : 388.3333333333333 }*
      { "_id" : ObjectId("58843604254a2a0014988bcb"), "name" : "ID SPECIAL KERALA PAROTA", "score" : 367.5 }
      { "_id" : ObjectId("589c29b1f62aa8912582737c"), "name" : "ID SPECIAL IDLY/DOSA BATTER", "score" : 355 }
      { "_id" : ObjectId("58834a82254a2a001497bb14"), "name" : "VIJAY IDLI RAVA", "score" : 333.3333333333333 }
      { "_id" : ObjectId("58824c4a254a2a0014971373"), "name" : "BHAGYALAKSHMI IDLI SOOJI", "score" : 333.3333333333333 }
      { "_id" : ObjectId("58824cb8254a2a0014971ea8"), "name" : "24 MANTRA IDLI RAVA", "score" : 312.5 }
      { "_id" : ObjectId("588f08916a5bc29c3b0e9600"), "name" : "iFILL IDLI RICE REGULAR", "score" : 312.5 }
      

      Full Content of First Record

      {
          "_id" : ObjectId("58824b8e254a2a001496fb9b"),
          "name" : "ID WHEAT PAROTA",
          "price" : 69.3,
          "compare_price" : 70,
          "brand" : "ID",
          "sku" : "339286",
          "barcode" : "339286",
          "categories" : [
              "food-essentials",
              "ready-to-eat",
              "cook-eat-meals"
          ],
          "publish" : "1",
          "weight" : "1",
          "inventory_management" : "automatic",
          "product_has_multiple_variants" : "Product",
          "inventory_allow_out_of_stock" : "0",
          "inventory_quantity" : 0,
          "inventory_low_stock_quantity" : 0,
          "option_set" : "58c4f7e6a72619a53c3f0969",
          "_metadata" : {
              "option_set" : {
                  "action" : "automatic"
              }
          },
          "images" : [
              {
                  "image" : "ms.products/58824b8e254a2a001496fb9b/images/58824b8e254a2a001496fb9c/58824b8eac9b955813b4c873/58824b8eac9b955813b4c873.jpg",
                  "caption" : "",
                  "tags" : "",
                  "_id" : "58824b8e254a2a001496fb9c",
                  "_metadata" : {
                      "image" : {
                          "_id" : "58824b8eac9b955813b4c873",
                          "name" : "339286.jpg",
                          "tmp_path" : "/tmp/tmp-4952tVZ6rI71862n.jpg",
                          "type" : "image/jpeg"
                      }
                  }
              }
          ],
          "variants" : [
              {
                  "price" : "69.3",
                  "compare_price" : "70",
                  "sku" : "339286",
                  "barcode" : "339286",
                  "weight" : "1",
                  "inventory_management" : "automatic",
                  "inventory_allow_out_of_stock" : "0",
                  "inventory_quantity" : "0",
                  "options" : [
                      {
                          "name" : "Weight",
                          "value" : "300 Grams"
                      }
                  ],
                  "variant_id" : "300 Grams",
                  "id" : 66336
              }
          ],
          "options" : [
              {
                  "name" : "Weight",
                  "values" : [
                      "300 Grams"
                  ],
                  "_id" : "58f87e4ba0f774d3140d1947"
              }
          ],
          "default_variant" : {
              "price" : "69.3",
              "compare_price" : "70",
              "sku" : "339286",
              "barcode" : "339286",
              "weight" : "1",
              "inventory_management" : "automatic",
              "inventory_allow_out_of_stock" : "0",
              "inventory_quantity" : "0",
              "options" : [
                  {
                      "name" : "Weight",
                      "value" : "300 Grams"
                  }
              ],
              "variant_id" : "300 Grams",
              "id" : 66336
          },
          "available" : 0,
          "attributes" : [
              {
                  "name" : "_brand",
                  "value" : "ID",
                  "group" : "default",
                  "_id" : "58f87e4ba0f774d3140d1948"
              }
          ],
          "uniquesku" : [
              "339286"
          ],
          "approve" : "approved",
          "seller" : "58537f24bf9b36aa0700a022",
          "alias" : "id-wheat-parota",
          "sort_order" : 306,
          "created_on" : ISODate("2017-01-20T17:40:35.957Z"),
          "updated_on" : ISODate("2017-04-20T09:24:27.781Z"),
          "_updated_by" : "585b7f4ba7636cc77ca96861",
          "inventory_management_level" : "variant",
          "collections" : [ ],
          "SEO" : {
              
          },
          "features" : [ ],
          "files" : [ ],
          "description" : "",
          "Request" : "Monday",
          "metafields" : {
              "loyalty_points" : "1"
          }
      }
      

      So my question is if that there is no idli word in first record. but still it is showing that record in result on first place.

      Thanks
      Sachin Garg

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: