Range index query not yielding results

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
},
},
],
},
},
},
]

Any clue as to why?

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.

2 Likes

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.

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.