Glad you got it working
Not for a range
query, no. You could write a script
query to do this but similarly to script sorting, the performance of the query would not be as good as using the range
query, but the performance might be acceptable for your use case. You can write a compound query however that combines
- a
range
query onshipment_date
with aterm
query on thesale*
_index
(both asfilter
clauses in abool
query)
with
- a
range
query oncreated_date
with aterm
query on theorder*
_index
(both asfilter
clauses in abool
query)
both as should
clauses in a bool
query. Here's something similar as an example.