SELECT cd.CATEGORYNAME "分类",
wo.WORKORDERID "请求ID",
scd.NAME "子分类",
wo.TITLE "主题",
urgdef.NAME "紧急度",
wof.UDF_CHAR1 "影响范围",
cri.FIRST_NAME "创建者",
aau.FIRST_NAME "请求人",
ti.FIRST_NAME "作业技术员",
wof.UDF_CHAR5 "OPS值班人",
wos.ISOVERDUE "逾期状态",
std.STATUSNAME "请求状态",
wotodesc.FULLDESCRIPTION "描述",
rrs.RESOLUTION "解决方法",
longtodate(wo.CREATEDTIME) "创建时间",
longtodate(wo.COMPLETEDTIME) "完成时间",
longtodate(wo.FR_DUETIME) "响应逾期时间",
wos.IS_FR_OVERDUE "首次响应逾期状态"
FROM WorkOrder wo
LEFT JOIN ModeDefinition mdd
ON wo.MODEID = mdd.MODEID
LEFT JOIN SDUser sdu
ON wo.REQUESTERID = sdu.USERID
LEFT JOIN AaaUser aau
ON sdu.USERID = aau.USER_ID
LEFT JOIN SDUser crd
ON wo.CREATEDBYID = crd.USERID
LEFT JOIN AaaUser cri
ON crd.USERID = cri.USER_ID
LEFT JOIN WorkOrderStates wos
ON wo.WORKORDERID = wos.WORKORDERID
LEFT JOIN CategoryDefinition cd
ON wos.CATEGORYID = cd.CATEGORYID
LEFT JOIN SDUser td
ON wos.OWNERID = td.USERID
LEFT JOIN AaaUser ti
ON td.USERID = ti.USER_ID
LEFT JOIN WorkOrder_Queue woq
ON wo.WORKORDERID = woq.WORKORDERID
LEFT JOIN SubCategoryDefinition scd
ON wos.SUBCATEGORYID = scd.SUBCATEGORYID
LEFT JOIN WorkOrder_Fields wof
ON wo.WORKORDERID = wof.WORKORDERID
LEFT JOIN UrgencyDefinition urgdef
ON wos.URGENCYID = urgdef.URGENCYID
LEFT JOIN StatusDefinition std
ON wos.STATUSID = std.STATUSID
LEFT JOIN WorkOrderToDescription wotodesc
ON wo.WORKORDERID = wotodesc.WORKORDERID
LEFT JOIN RequestResolver rrr
ON wo.WORKORDERID = rrr.REQUESTID
LEFT JOIN RequestResolution rrs
ON rrr.REQUESTID = rrs.REQUESTID
WHERE wo.CREATEDTIME >= datetolong('2020-09-01')
and wo.CREATEDTIME < datetolong('2020-09-05')
and cd.CATEGORYNAME <> 'IT 服务问题'
SELECT cd.CATEGORYNAME "分类",
wo.WORKORDERID "请求ID",
scd.NAME "子分类",
wo.TITLE "主题",
urgdef.NAME "紧急度",
wof.UDF_CHAR1 "影响范围",
cri.FIRST_NAME "创建者",
aau.FIRST_NAME "请求人",
ti.FIRST_NAME "作业技术员",
wof.UDF_CHAR5 "OPS值班人",
wos.ISOVERDUE "逾期状态",
std.STATUSNAME "请求状态",
wotodesc.FULLDESCRIPTION "描述",
rrs.RESOLUTION "解决方法",
longtodate(wo.CREATEDTIME) "创建时间",
longtodate(wo.COMPLETEDTIME) "完成时间",
longtodate(wo.FR_DUETIME) "响应逾期时间",
wos.IS_FR_OVERDUE "首次响应逾期状态"
FROM WorkOrder wo
LEFT JOIN ModeDefinition mdd
ON wo.MODEID = mdd.MODEID
LEFT JOIN SDUser sdu
ON wo.REQUESTERID = sdu.USERID
LEFT JOIN AaaUser aau
ON sdu.USERID = aau.USER_ID
LEFT JOIN SDUser crd
ON wo.CREATEDBYID = crd.USERID
LEFT JOIN AaaUser cri
ON crd.USERID = cri.USER_ID
LEFT JOIN WorkOrderStates wos
ON wo.WORKORDERID = wos.WORKORDERID
LEFT JOIN CategoryDefinition cd
ON wos.CATEGORYID = cd.CATEGORYID
LEFT JOIN SDUser td
ON wos.OWNERID = td.USERID
LEFT JOIN AaaUser ti
ON td.USERID = ti.USER_ID
LEFT JOIN WorkOrder_Queue woq
ON wo.WORKORDERID = woq.WORKORDERID
LEFT JOIN SubCategoryDefinition scd
ON wos.SUBCATEGORYID = scd.SUBCATEGORYID
LEFT JOIN WorkOrder_Fields wof
ON wo.WORKORDERID = wof.WORKORDERID
LEFT JOIN UrgencyDefinition urgdef
ON wos.URGENCYID = urgdef.URGENCYID
LEFT JOIN StatusDefinition std
ON wos.STATUSID = std.STATUSID
LEFT JOIN WorkOrderToDescription wotodesc
ON wo.WORKORDERID = wotodesc.WORKORDERID
LEFT JOIN RequestResolver rrr
ON wo.WORKORDERID = rrr.REQUESTID
LEFT JOIN RequestResolution rrs
ON rrr.REQUESTID = rrs.REQUESTID
WHERE wo.CREATEDTIME >= datetolong('2020-09-01')
and wo.CREATEDTIME < datetolong('2020-09-05')
and cd.CATEGORYNAME <> 'IT 服务问题'