Just to clarify, I've omitted some "useless" data from snippets above (i.e. all properties mappings)
No, nested objects is not supported by the standard installation.
By currenlty I'm able to use nested facets and filters.
To clearify: You can use nested objects for searching/faceting (although there is no API support for that). What is not supported is sorting.
Thank you, Henrik.
I do use faceting/filtering by nested objects (I've made simple extension for find API).
But still can't understand why standard ElasticSearc feature is disabled by epi find service, that was a greate surprise :)
And this is really a pain in my case when I have product with multiple prices (each price has time range when it is active) and want to sort products by "actual" price (that mets current time condition).
I think that is very common case for e-commerce application; for instance, EPiServer Commerce does support multiple prices, but find provider it has does calculate actual price during indexing. So reindexing of catalog (in my case 40 000+) products is required at least every day.
Only options I see do sorting/paging on client or reindex all my products every day. But I still don't want to go with this "ugly" solutions and afraid performance degradation they may lead to.
To whomever like me gets this as the first result in Google: please note that this post was answered in 2014 and back then it was not possible to do it. In the latest versions of the Find API this is totally possible:
Hope it helps!
According to ES documentation: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-request-sort.html
That is possible to sort documents by "nested objects".
Does ES instance provided by episerver find supports this?
Or I doing something wrong below?
Mapping that was build in my index (extracted from it):
Hits from index (I have only 2 documents there)
Hits are not sorted, and "sort" fields equals 0 for both of them.