应用场景：

要求从问题中抽取与之关联的已发布任务，要求列出任务的创建时间、状态及相关描述的报表：

此报表在系统默认报表中并不能实现，所以使用SQL语句直接创建查询报表实现，语句请看以下：

SELECT prob.PROBLEMID AS "Problem ID", prob.TITLE AS "Problem Title", ownaaa.FIRST_NAME AS "Technician", longtodate(prob.DUEBYTIME) AS "DueBy Date", longtodate(prob.CLOSEDTIME) AS "Closed Date", itemdef.NAME AS "Item", probdesc.FULL_DESCRIPTION AS "Description", solwork.DESCRIPTION AS "Workaround",taskdet.TASKID AS "Task ID", taskdet.TITLE AS "Task Title", 

longtodate(taskdet.SCHEDULEDSTARTTIME ) AS "Scheduled Start Time", 

longtodate(taskdet.SCHEDULEDENDTIME) AS "Scheduled End Time", taskcreatedby.FIRST_NAME AS "Created By", taskdet.PER_OF_COMPLETION AS "Percentage Of Completion", taskowner.FIRST_NAME AS "task Owner" FROM Problem prob LEFT JOIN SDUser ownsd ON prob.OWNERID=ownsd.USERID LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID LEFT JOIN ItemDefinition itemdef ON prob.ITEMID=itemdef.ITEMID LEFT JOIN ProblemToDescription probdesc ON prob.PROBLEMID=probdesc.PROBLEMID LEFT JOIN SolutionToWorkAround probwork ON prob.PROBLEMID=probwork.PROBLEMID LEFT JOIN Solution solwork ON probwork.SOLUTIONID=solwork.SOLUTIONID 

LEFT JOIN ProblemToTaskDetails probtotaskdet ON prob.PROBLEMID=probtotaskdet.PROBLEMID

LEFT JOIN TaskDetails taskdet  ON probtotaskdet.TASKID=taskdet.TASKID 

LEFT JOIN AaaUser taskcreatedby ON taskdet.CREATEDBY=taskcreatedby.USER_ID LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID order by 1

附件是导出的报表，供参考！