数据库排序问题

这个好像还是没法解决公元前后一个师由大到小，一个是由小到大的问题 😂

模板写好了，现在支持 5 位数年份、年份也不必要是 4 位了（开头的 0 填不填都行）：

.action{ $Year := .年份 }
.action{ if and (eq .公历纪元 "公元前") .年份 }
    .action{ $numYear := sub 99999 (atoi (trimSuffix "年" (regexFind "[0-9]\\d{0,4}年" $Year))) }
    .action{ $numYear = list (trunc (int (sub 5 (len (toString $numYear)))) "00000") $numYear | join "" }
    .action{ $numMonth := sub 99 (atoi (trimSuffix "月" (regexFind "[0-9]\\d{0,1}月" $Year))) }
    .action{ $numMonth = list (trunc (int (sub 2 (len (toString $numMonth)))) "00") $numMonth | join "" }
    .action{ $numDay := sub 99 (atoi (trimSuffix "日" (regexFind "[0-9]\\d{0,1}日" $Year))) }
    .action{ $numDay = list (trunc (int (sub 2 (len (toString $numDay)))) "00") $numDay | join "" }
    .action{ list "1" $numYear $numMonth $numDay | join "" }
.action{ else if and (eq .公历纪元 "公元") .年份 }
    .action{ $numYear := trimSuffix "年" (regexFind "[0-9]\\d{0,4}年" $Year) }
    .action{ $numYear = list (trunc (int (sub 5 (len (toString $numYear)))) "00000") $numYear | join "" }
    .action{ $numMonth := trimSuffix "月" (regexFind "[0-9]\\d{0,1}月" $Year) }
    .action{ $numMonth = list (trunc (int (sub 2 (len (toString $numMonth)))) "00") $numMonth | join "" }
    .action{ $numDay := trimSuffix "日" (regexFind "[0-9]\\d{0,1}日" $Year) }
    .action{ $numDay = list (trunc (int (sub 2 (len (toString $numDay)))) "00") $numDay | join "" }
    .action{ list "2" $numYear $numMonth $numDay | join "" }
.action{ else }
    0
.action{ end }

可以创建一个模板列，粘贴下面代码，然后模板列降序或升序。之后可以隐藏模板列，既不影响查看，也不影响后续插入新数据的排序。

.action{ $formatYear := .年份 }.action{ if eq .公历 "公元前" }.action{ $formatYear = (cat "0" .年份) }.action{ end }.action{ if eq .公历 "公元" }.action{ $formatYear = (cat "1" .年份) }.action{ end }.action{ $formatYear }

注意：把代码中的 .公历 换成你的 公历... 列名，截图中看不列的全名，所以需要自己补充完整。

改进一下，把零都去掉

.action{ $Year := .年份 }
.action{ if eq .公历纪元 "公元前" }
.action{ cat "-" (atoi (trunc 4 $Year))}
.action{ else if eq .公历纪元 "公元" }
.action{ (atoi (trunc 4 $Year))}
.action{ end }