I've run the query with the smallest possible subset and the query is
returning the results in the expected order so it appears to be correct.
The biggest question that I have is does the second sort condition know to
run on the *first* projected valuation that had the max date from the first
I have a mapping with the following (omitted other properties for brevity):
{
index-name : {
mappings : {
index-type : {
properties : {
history : {
properties : {
valuations : {
type : nested,
include_in_root