Nested fields sort query returns erroneous ordering results
Example:
{ "kind": "osdu:wks:master-data--Wellbore:1.0.0", "field": ["nested(data.VerticalMeasurements, VerticalMeasurement, max)"], "order": ["DESC"] }
Response:
1st record
"VerticalMeasurements": [
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "MD",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:Measured%20Depth:",
"VerticalMeasurement": 396.2,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:Total%20Depth:",
"VerticalMeasurementUnitOfMeasureID": "osdu-openness:reference-data--UnitOfMeasure:M:"
},
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "GL",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:ELEV:",
"VerticalMeasurement": 20.28,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:GL:"
}
],
2nd record
"VerticalMeasurements": [
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "MD",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:Measured%20Depth:",
"VerticalMeasurement": 20,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:Total%20Depth:",
"VerticalMeasurementUnitOfMeasureID": "osdu-openness:reference-data--UnitOfMeasure:M:"
},
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "GL",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:ELEV:",
"VerticalMeasurement": 50,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:osdu-openness:reference-data--VerticalMeasurementType:DF:"
}
],
3rd record
"VerticalMeasurements": [
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "MD",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:Measured%20Depth:",
"VerticalMeasurement": 2387,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:Total%20Depth:",
"VerticalMeasurementUnitOfMeasureID": "osdu-openness:reference-data--UnitOfMeasure:M:"
},
{
"VerticalCRSID": "osdu-openness:reference-data--CoordinateReferenceSystem:VerticalCRS::EPSG::5714:",
"VerticalMeasurementSourceID": "osdu-openness:reference-data--VerticalMeasurementSource:DRL:",
"VerticalMeasurementID": "GL",
"VerticalMeasurementPathID": "osdu-openness:reference-data--VerticalMeasurementPath:ELEV:",
"VerticalMeasurement": 223.1,
"VerticalMeasurementTypeID": "osdu-openness:reference-data--VerticalMeasurementType:osdu-openness:reference-data--VerticalMeasurementType:RT:"
}
]
```,