hasokeric
10/4/2017 - 12:57 PM

SysTaskLogQueryJoinSysTaskEpicor.cs

SysTaskLogQueryJoinSysTaskEpicor.cs

SELECT * FROM Ice.SysTaskLog LEFT JOIN Ice.SysTask ON Ice.SysTaskLog.SysTaskNum = Ice.SysTask.SysTaskNum WHERE StartedOn >= '2017-09-26';

SELECT * FROM Ice.SysTaskLog LEFT JOIN Ice.SysTask ON Ice.SysTaskLog.SysTaskNum = Ice.SysTask.SysTaskNum WHERE MsgText LIKE '%Processing labor rec%';