- 注册时间
- 2017-6-9
- 最后登录
- 1970-1-1
- 阅读权限
- 10
- 积分
- 47
- 精华
- 0
- 帖子
- 0
|
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分组 这里不是日期类型 单纯的是字符串比较 |
|