【泛微ecology】流程后端路径的创建日期时间sql

流程后端路径的创建日期时间sql

SELECT
relatedid 路径id,
relatedName 流程名称,
operateUserId 操作人,
operateDate 创建日期,
operateTime 创建时间,
clientAddress 客户端地址
FROM
SysMaintenanceLog,
SystemLogItem
WHERE
operateitem = 85
AND operateType = 1
AND ( operatesmalltype IS NULL OR operatesmalltype <> 1 )
AND SysMaintenanceLog.operateItem = SystemLogItem.itemId
ORDER BY
id DESC