New nested_filter for sorting an object based on an array of nested objects

Elastic Stack Elasticsearch
1

I'm trying out a new feature for sorting an object based on its nested
objects using the new 'nested_filter' field.
I'm on elasticsearch version 20.6
I cannot get it to work so far, it doesn't sort at all when using the
nested object as the field and including a filter for another nested object
field.

Does this work in version 20.6?

This is the query and sort:
{
"query": {
"match_all": {}
},
"sort": [
{
"nested.field": {
"mode": "avg",
"order": "asc",
"nested_filter": {
"term": {
"nested.otherfield.id": 14
}
}
}
}
]
}
It doesn't seem to be sorting at all and I tried including the
"nested_path": "nested" field but it doesn't like it.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

2

Sorting on fields inside nested objects is a 0.90 only feature. It doesn't
work in ES version 0.20.6

On 28 March 2013 11:59, David davidrockett@gmail.com wrote:

I'm trying out a new feature for sorting an object based on its nested
objects using the new 'nested_filter' field.
I'm on elasticsearch version 20.6
I cannot get it to work so far, it doesn't sort at all when using the
nested object as the field and including a filter for another nested object
field.

Does this work in version 20.6?

This is the query and sort:
{
"query": {
"match_all": {}
},
"sort": [
{
"nested.field": {
"mode": "avg",
"order": "asc",
"nested_filter": {
"term": {
"nested.otherfield.id": 14
}
}
}
}
]
}
It doesn't seem to be sorting at all and I tried including the
"nested_path": "nested" field but it doesn't like it.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Met vriendelijke groet,

Martijn van Groningen

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

3

Do you plan to include it in a stable release?

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

4

Yes, in the 0.90 GA release (expected in the coming weeks). It is not
planned to be included in a 0.20.x release.

On 28 March 2013 13:29, David davidrockett@gmail.com wrote:

Do you plan to include it in a stable release?

--
Met vriendelijke groet,

Martijn van Groningen

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.