groupby 日期分组后排序混乱

528887914

    grid.groupBy("date","desc");  

数据在返回前做了排序 ,日期在返回客户端之前已做格式化

但是分组显示出现错误（应该为降序  ）。
  

felt

请提供你这个表格的数据来重现问题。
你的排序字段date的数据是格式，另外表格的列上可以设置指定数据类型，dataType="date“

528887914

felt 发表于 2017-6-13 13:04
请提供你这个表格的数据来重现问题。
你的排序字段date的数据是格式，另外表格的列上可以设置指定数据类型 ...

"[{"dtmapplytime":"2017-06-13","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"61E2732F-0E4F-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":1,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"啊实打实大撒"},{"dtmapplytime":"2017-06-13","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"63E2732F-0E4F-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":1,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"啊实打实大"},{"dtmapplytime":"2017-06-13","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"60E2732F-0E4F-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":-1,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasdsad啊实打实大撒"},{"dtmapplytime":"2017-06-12","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"E6B3D166-154F-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"测试"},{"dtmapplytime":"2017-06-10","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"446341EB-154F-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"sdasdsadasd"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"9F3F1484-DE4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"需求1"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A03F1484-DE4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"需求2"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A13F1484-DE4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"需求3"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A23F1484-DE4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"需求4"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"7CFF04F3-DF4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"啊实打实大撒的"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"7DFF04F3-DF4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"啊实打实大撒"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"7EFF04F3-DF4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"阿斯顿撒旦撒"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"7FFF04F3-DF4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"是的说法是f"},{"dtmapplytime":"2017-06-09","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"80FF04F3-DF4C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"梵蒂冈反对"},{"dtmapplytime":"2017-06-08","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"44CCF892-C94C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"分2"},{"dtmapplytime":"2017-06-01","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A091EE0F-E24C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":1,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasdas"},{"dtmapplytime":"2017-06-01","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A191EE0F-E24C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasdasda"},{"dtmapplytime":"2017-06-01","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"A291EE0F-E24C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasdas"},{"dtmapplytime":"2017-05-31","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"BEA9B01A-E24C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":1,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasdas"},{"dtmapplytime":"2017-05-31","dtmcreatetime":"2017-06-09","guidcreateid":"CC04EA09-9471-E611-A3D8-005056C00008","guiduserid":"CC04EA09-9471-E611-A3D8-005056C00008","guidworkbookid":"BDA9B01A-E24C-E711-BF7B-000C29A7154C","guidworkbooktypeid":"4AE12386-C94C-E711-BF7B-000C29A7154C","intflag":0,"inttask":0,"nickname":"超级管理员","strcontent":"","strworkname":"asdasd"}]"


数据是这个 用dtmapplytime分组 这里不是日期类型 单纯的是字符串比较

jialiang

528887914 发表于 2017-6-13 15:07
"[{"dtmapplytime":"2017-06-13","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8 ...

你再时间列中添加dataType="date"；就可以了

felt

528887914 发表于 2017-6-13 15:07
"[{"dtmapplytime":"2017-06-13","dtmcreatetime":"2017-06-12","guidcreateid":"CC04EA09-9471-E611-A3D8 ...

如图mm的数据加载，就按字符串的方式排列，顺序也是正确的。

你可以用我们在线的js测试一下是不是版本问题，如果是版本问题，那么你需要更新到最新版本。
<script src="http://www.miniui.com/scripts/boot.js" type="text/javascript"></script>

528887914

jialiang 发表于 2017-6-13 15:24
你再时间列中添加dataType="date"；就可以了

<div field="dtmapplytime"  width="100"  align="center" dataType="date"
                                                        headerAlign="center">提出时间</div>

  我这里设置了的 没什么效果

felt

528887914 发表于 2017-6-13 15:26
提出时间

  我这里设置了的 没什么效果

你的数据只是字符串，不是date，dataType指定无效，如5楼，就按字符串的方式排列也是正确的。