Gte or null

Elastic Stack Elasticsearch
1

hey guys, maybe someone had same pb as i, i need write request to project that have availiable_date more than today and availiable_date that equal null.

{
query:{
bool:{
filter:{
must:{
range:{
avalible_to:{
lte:"2017-02-06T20:57:22+02:00"
}
}
}
}
}
}
}

2

Hey,

what does equal null mean in this context? If you index a JSON field with the value null, it is dropped by default, unless you configure null_value in your mapping. If you need an open bound, just omit the gte part of your query.

--Alex

3

yep i want have result of data that have defaul null or gte than today

4

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