How to sort couchbase document based on value of Doc in Array

SQL++
1

How can we sort using N1QL query to the following json based on the score value inside schemas array ->dimension …

{
"Message": {
"Vendor": "Test",

"Schemas": [
{
"Id": "111",
"Dimensions": [
{
"Name": "Model1",
"Score": "79"
}

]
},
{
"Id": "222",
"Dimensions": [
{
"Name": "Model1",
"Score": "80"
}
]
}
],
"CreatedOn": "2020-07-14T00:00:09.0016947+00:00"
},
}
2

This is single document no sort. If you need to sort on multiple documents which score value (there are multiple inside the document) you are looking sort.
If you need each Dimensions Array sort Use Subquery expressions. As it so nested getting exact structure will be complex.

SELECT m.*,
      (SELECT s.*,
             (SELECT d.*
              FROM s.Dimensions AS d
              WHERE ....
              ORDER BY d.score) AS Dimensions
         FROM m.Schemas AS s
         WHERE .....) AS Schemas
FROM messages m
WHERE ...;