Hi,
I have a query:
The field is defined in the index (abbreviated):
“Series”: {
“dynamic”: true,
“fields”: {
“Size”: {
“type”: “number”
},
A query in the collection does yield results, but the index query doesn’t:
Collection query: {“Series.Size”: {$lte: 13}}
Index query:
[
{
$search: {
index: “Article”,
compound: {
must: [
{
range: {
path: “Series.Size”,
lte: 13
},
},
],
},
},
},
]
Hi @Pedro_04153 , can you share a sample document? Also, what data type is Series.size? Atlas Search does not support Decimal128, which could be a reason why you’re not seeing results.
For situations like these, I find it helpful to use the Search Playground, which allows you to share a snapshot (upper right) containing your documents, index definition and query.
Thanks for sharing the search playground tool, indeed might be useful in the future.
Indeed it seems that the issue is that range queries for Decimal128 just isn’t supported, which is rather annoying.