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