|
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
|