如何在MarkLogic中对字符串格式的年月组合进行排序？

我来帮你解决这个MarkLogic里年月字符串排序的问题！你现在遇到的是默认字母排序不符合实际时间顺序的情况，这很常见，下面给你两种靠谱的解决方案：

核心思路是把"YYYY Month"格式的字符串转换成标准的日期类型，利用日期本身的排序规则来实现正确的时间顺序。具体步骤是拆分字符串提取年份和月份名，将月份名转为数字，构造出每月1号的日期，再按这个日期排序。

let $full-month-names := ("January", "February", "March", "April", "May", "June", 
                          "July", "August", "September", "October", "November", "December")
let $target-strings := ("2018 April", "2018 Dec", "2018 Feb", "2018 Nov")

return
for $str in $target-strings
let $parts := tokenize($str, "\s+")
let $year := $parts[1]
// 自动适配缩写和全称的月份名
let $month-name := if (string-length($parts[2]) = 3) then 
                      $full-month-names[index-of(("Jan", "Feb", "Mar", "Apr", "May", "Jun", 
                                                   "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"), $parts[2])]
                   else $parts[2]
let $month-num := index-of($full-month-names, $month-name)
let $sort-date := xs:date(concat($year, "-", format-number($month-num, "00"), "-01"))
order by $sort-date
return $str

运行这段代码后，返回的顺序就是正确的时间序列："2018 Feb", "2018 April", "2018 Nov", "2018 Dec"。这种方法的好处是自动处理跨年份的排序，比如"2017 Dec"会排在"2018 Jan"前面，非常省心。

如果不想构造日期，也可以直接用「年份+月份数字」作为排序键。先创建一个月份名称（含缩写）到数字的映射，然后提取每个字符串的年份和对应月份数字，按这两个值排序。

let $month-map := map:map()
// 同时添加全称和缩写，适配不同格式的输入
let $_ := map:put($month-map, "jan", 1), map:put($month-map, "january", 1)
let $_ := map:put($month-map, "feb", 2), map:put($month-map, "february", 2)
let $_ := map:put($month-map, "mar", 3), map:put($month-map, "march", 3)
let $_ := map:put($month-map, "apr", 4), map:put($month-map, "april", 4)
let $_ := map:put($month-map, "may", 5), map:put($month-map, "may", 5)
let $_ := map:put($month-map, "jun", 6), map:put($month-map, "june", 6)
let $_ := map:put($month-map, "jul", 7), map:put($month-map, "july", 7)
let $_ := map:put($month-map, "aug", 8), map:put($month-map, "august", 8)
let $_ := map:put($month-map, "sep", 9), map:put($month-map, "september", 9)
let $_ := map:put($month-map, "oct", 10), map:put($month-map, "october", 10)
let $_ := map:put($month-map, "nov", 11), map:put($month-map, "november", 11)
let $_ := map:put($month-map, "dec", 12), map:put($month-map, "december", 12)

let $target-strings := ("2018 April", "2018 Dec", "2018 Feb", "2018 Nov")

return
for $str in $target-strings
let $parts := tokenize($str, "\s+")
let $year := xs:integer($parts[1])
let $month-key := lower-case($parts[2])
let $month-num := map:get($month-map, $month-key)
order by $year, $month-num
return $str

这种方法灵活性更高，你可以根据实际数据的月份格式调整映射表，比如如果有其他语言的月份名称，也能轻松扩展。

小提醒 #

如果你的数据里月份名称格式不统一（比如大小写混合、特殊缩写），记得先对月份名做标准化处理，比如转成小写，再去匹配映射表，避免出现找不到对应数字的情况。

内容的提问来源于stack exchange，提问作者Prashant Chauhan