Query to get list of Request created from Maintenance schedule
Version : 14200
DB : MSSQL / PGSQL
OUTPUT :
Query :
select wo.workorderid AS "Request ID",
wo.title AS "Subject",
wotodesc.FULLDESCRIPTION AS "Description" from pmtasktoworkorder pmtw
INNER JOIN workorder wo ON pmtw.WORKORDERID=wo.WORKORDERID
LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID
wo.title AS "Subject",
wotodesc.FULLDESCRIPTION AS "Description" from pmtasktoworkorder pmtw
INNER JOIN workorder wo ON pmtw.WORKORDERID=wo.WORKORDERID
LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID