Mule4中的逆向排序

Question

我有一个类似于dwl脚本变量中类似faashion的数据。

%dw 2.0
output application/json
var test = { "2022-10-19T10:59:00.000Z":[{"kio":"spotage"}] ,
            "2022-10-17T10:59:00.000Z": [{"kio":"spotage"}] ,
            "2022-10-18T10:59:00.000Z": [{"kio":"spotage"}] 
            }
---
test  orderBy $$

需要按日期格式按ASC顺序排序。获取以下响应，这是默认的排序DSC。想要逆转它ASC。尝试了-$$和[-1 to 0]，并尝试了格式化作为LocalDateTime检查，以确定它是否工作。

    {
  "2022-10-17T10:59:00.000Z": [
    {
      "kio": "spotage"
    }
  ],
  "2022-10-18T10:59:00.000Z": [
    {
      "kio": "spotage"
    }
  ],
  "2022-10-19T10:59:00.000Z": [
    {
      "kio": "spotage"
    }
  ]
}

预期答复如下

{
    "2022-10-19T10:59:00.000Z": [
        {
            "kio": "spotage"
        }
    ],
    "2022-10-18T10:59:00.000Z": [
        {
            "kio": "spotage"
        }
    ],
    "2022-10-17T10:59:00.000Z": [
        {
            "kio": "spotage"
        }
    ]
}

如果问题不清楚，请告诉我。有什么想法吗？

Answer 1

$$的类型是Key。因此你不能直接做-$$。您需要将键转换为String，然后转换为DateTime，以便它能够正确地对其进行排序。

%dw 2.0
output application/json
var test = { "2022-10-19T10:59:00.000Z":[{"kio":"spotage"}] ,
            "2022-10-17T10:59:00.000Z": [{"kio":"spotage"}] ,
            "2022-10-18T10:59:00.000Z": [{"kio":"spotage"}] 
            }
---
test orderBy -($$ as String as DateTime)