您好:视图过滤,写上sql语句,如果视图选择分页显示,前台就报错,如图视图不分页显示,前台可以正常显示的问题,建议您修改对应的sql语句,改为SELECT DOMAINID,NAME,NAME as ITEM_NAME,FIELD1 as ITEM_WORKNO,ID AS ITEM_ID FROM obpm.dbo.T_USER WHERE ID IN (SELECT USERID FROM obpm.dbo.T_USER_DEPARTMENT_SET WHERE DEPARTMENTID='657c96b0-badc-4cd8-9d70-28279c284382') AND STATUS=1 ORDER BY NAME
增加一个没有别名的Name字段列,因为你order by 是name字段。 |