|
|
近期我更新了项目的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吧！
|
|
窥视卡
雷达卡
发表于 2017-10-25 11:21:43
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡
发表于 2017-10-30 18:04:15
