islee 发表于 2017-10-25 11:21:43

3.7.1版本 CriteriaQuery 排序无效的问题

近期我更新了项目的jeecg版本，之前用的是很老的 3.4，但是更新到3.7后出现了排序无效的问题。代码如下：

public void datagrid(MeetingInfoEntity meetingInfo, HttpServletRequest request, HttpServletResponse response, DataGrid dataGrid) {
   CriteriaQuery cq = new CriteriaQuery(MeetingInfoEntity.class, dataGrid);
   cq.addOrder("createDate", SortDirection.desc);
   //查询条件组装器
   org.jeecgframework.core.extend.hqlsearch.HqlGenerateUtil.installHql(cq, meetingInfo, request.getParameterMap());
   this.meetingInfoService.getDataGridReturn(cq, true);
   TagUtil.datagrid(response, dataGrid);
}

跟踪生成的SQL如下：
SELECT
        this_.ID AS ID26_0_,
        this_.ADDRESS AS ADDRESS26_0_,
        this_.ARCHIVE_STSTUS AS ARCHIVE3_26_0_,
        this_.BEGIN_DATE AS BEGIN4_26_0_,
        this_.CONTENT AS CONTENT26_0_,
        this_.CREATE_DATE AS CREATE6_26_0_,
        this_.EMCEE AS EMCEE26_0_,
        this_.END_DATE AS END8_26_0_,
        this_.MEETING_DATE AS MEETING9_26_0_,
        this_.PARENT_ID AS PARENT10_26_0_,
        this_. STATUS AS STATUS26_0_,
        this_.SUBTITLE AS SUBTITLE26_0_,
        this_.TITLE AS TITLE26_0_
FROM
        meet_meeting_info this_
LIMIT 10000

可以看到其中排序字段根本就没有产生效果。这是个BUG吧！


admin 发表于 2017-10-30 18:04:15

已经收录，非常感谢

admin 发表于 2017-10-31 15:57:09

已修复，请替换附件两个类

lchniao 发表于 2017-11-13 23:36:51

admin 发表于 2017-10-31 15:57 static/image/common/back.gif
已修复，请替换附件两个类

好使了
页: [1]
查看完整版本: 3.7.1版本 CriteriaQuery 排序无效的问题