-
Type:
Question
-
Resolution: Works as Designed
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Text Search
-
None
-
None
-
None
-
None
-
None
-
None
-
None
-
None
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