1 / 1
Dec 2024

Hi, I am getting no results from my search query. Unable to debug the issue

Index :

{ 'product.productName.*': 'text' }

Sample Document :

{ "product":{ "productName" : { "en-gb" : "Rocket Dog Womens Berry Lewis Boots", "fr-fr" : "Rocket Dog Bottes Berry Lewis" } } }

^^ the locales inside the productName obj can change from product to product, hence the wildcard index

Query :

db.getCollection('products').find({$text:{$search:'Rocket'}})

This works when i do a direct query. Any help debugging this would be greatly appreciated!
Mongod version 7.0.15. And the collection has around 300000+ documents