QueryServiceHelper.queryDataSet查询报错。creator已经包含在select和order里面了。

报错：[外排序]select field务必包含order by属性creator, all=[creator, zhuf_materiel.number], RowMeta=RowMeta[saledeptid, INNER_zhuf_materiel, salepeopleid, MaterialNo, MaterialName].

at kd.bos.orm.query.optimize.QueryOptimizater.finallyMultiQuery(QueryOptimizater.java:448)

at kd.bos.orm.query.optimize.QueryOptimizater.query(QueryOptimizater.java:110)

at kd.bos.orm.query.multi.MultiQuery.getDataSet(MultiQuery.java:258) at kd.bos.orm.query.multi.MultiQuery.query(MultiQuery.java:253)

at... OQL:

SELECT creator.id salepeopleid,zhuf_saledept.id saledeptid,zhuf_materiel.number MaterialNo,zhuf_materiel.name MaterialName FROM zhuf_customerht WHERE (zhuf_htstatus = 'A' AND zhuf_saledept.id

in ('1255973493611189270')) AND zhuf_period = '120220050' ORDER BY creator.id,zhuf_materiel.number

关键代码：

String selectfiles = "creator.id salepeopleid,zhuf_saledept.id saledeptid,zhuf_materiel.number MaterialNo,zhuf_materiel.name MaterialName";
//过滤条件
QFilter[] filter = new QFilter[2];
filter[0] = new QFilter("zhuf_htstatus", QCP.equals, "A").and(new QFilter("zhuf_saledept.id", QCP.in, deptList));
filter[1] = new QFilter("zhuf_period", QCP.equals, periodId);
DataSet contractDatas = QueryServiceHelper.queryDataSet(this.getClass().getName() + "contractDatas", "zhuf_customerht", selectfiles, filter, "creator.id,zhuf_materiel.number");

产品问题外排序]select field务必包含order by属性

产品问题 外排序]select field务必包含order by属性

恭喜您！

产品问题
外排序]select field务必包含order by属性

产品问题外排序]select field务必包含order by属性