Range index query not yielding results

Pedro_04153 · 2024-12-19T13:23:25.923Z

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?

amyjian · 2024-12-19T15:53:58.960Z

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.

Pedro_04153 · 2025-01-21T10:08:09.600Z

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.

system · 2025-01-26T10:08:21.090Z

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