同时使用IgnoreColumns、OrderBy、ToPageListAsync生成的脚本执行报错返回

SqlSugar 沟通中

 2  253

悬赏：0 飞吻

忽略这个ToPageAsync方法，是封装了一层，仍然使用ToPageListAsync方法
生成的SQL语句报错，ORDER BY 子句中的列 "t.CreateDate" 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中，生成的脚本如下

SELECT COUNT(1)

FROM (

SELECT *

FROM (

SELECT [UserId], [Account], [Avatar], [RealName], [Sex]

, [DeptId], [Email], [Mobile], [LastPasswordChange], [LastVisit]

, [PreviousVisit], [LoginCount], [UserType], [DeleteMark], [Status]

, [Remark], [CreateDate], [CreateUserId], [CreateUserName], [ModifyDate]

, [ModifyUserId], [ModifyUserName]

FROM [Sys_User]

WHERE [DeleteMark] = 0

) t

) [t]

LEFT JOIN [Sys_Dept] [b]

ON [t].[DeptId] = [b].[DeptId]

AND [b].[DeleteMark] = 0

WHERE [t].[UserType] = 0

ORDER BY [t].[CreateDate] ASC

热忱回答（2）