注册

非法的参数数据

惊蛰 2022/03/17 1253 2 已解决
select count(a.ID,a.WorkflowID ,a.CreatedTime,a.CreatedBy,a.ModifiedBy,a.ModifiedTime ,
(select DisplayPageStepName From AE_WorkflowSteps WHERE WorkflowID =a.WorkflowID and StepName =a.Step) AS Step,
a.Step as InsideStep,
a.StepNo,
a.Title,
"Task,Create User" as UserID,
"Task,ErrorText" as ErrorText,
(select DisplayPageStepName From AE_WorkflowSteps WHERE WorkflowID =a.WorkflowID and StepName =x."Task,PreStep") AS PreStep,
"Task,IsOCR" as IsOCR,
"Task,ReScanMsg" as ReScanMsg,
"Task,ReScanPerson" as ReScanPerson,
(SELECT EndedTime FROM ae_taskstep WHERE TaskID = a.ID AND TaskCreatedTime = a.CreatedTime AND Step = '影像有误待重扫'
ORDER BY StepNo DESC LIMIT 1) as ReScanTime,
(SELECT DISTINCT DisplayPageWorkflowName From AE_WorkflowSteps where WorkflowID =a.WorkflowID ) as WorkflowName,
"Task,ScanUserName" as ScanUserName)
FROM AE_Task a , "Task,K3" x 
where a.ID =x.TaskID and 1=1 and step !='影像废弃' AND WorkflowID = 'a24075ee-b482-4e4b-8ed1-5511cb470097' ORDER BY a.CreatedTime DESC LIMIT 0,10;

最后一行where开始报错

回答 0
暂无回答
扫一扫
联系客服