[Search] Sort on multiple attributes not working as expected
For all below queries we used partition as “slb-osdu-dev-des-prod-testing”
Working cases
**Case 1 **: { "kind": "default-prod-des-prod-testing:petrelcsv:wellbore:2.0.0", "sort": { "field": ["data.OPERATOR"], "order": ["ASC"] }, "limit": 20 }
Case 2: { "kind": "default-prod-des-prod-testing:petrelcsv:wellbore:2.0.0", "sort": { "field": ["data.LEASE"], "order": ["ASC"] }, "limit": 20 }
Case 3: { "kind": "default-prod-des-prod-testing:petrelcsv:wellbore:2.0.0", "sort": { "field": ["data.ELEVATION", "data.FIELD"], "order": ["ASC", "ASC"] }, "limit": 20 }
Not working case
**Case 1 **: { "kind": "default-prod-des-prod-testing:petrelcsv:wellbore:2.0.0", "sort": { "field": ["data.LEASE", "data.OPERATOR"], "order": ["ASC", "ASC"] }, "limit": 20 }
For all such queries we get following error.
{
"code": 400,
"reason": "Bad Request",
"message": "Sort is not supported for one or more of the requested fields"
}