3.7.1版本 CriteriaQuery 排序无效的问题

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

近期我更新了项目的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

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

GenericBaseCommonDao.java (31.06 KB, 下载次数: 41)

CriteriaQuery.java (19 KB, 下载次数: 34)

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

admin 发表于 2017-10-31 15:57
已修复，请替换附件两个类

好使了