Adding Notes Column to existing reports
Hi I have a report I have an existing report that I would like to add a column for for notes. Using postgresql please see below for existing report.
.
SELECT cd.CATEGORYNAME AS "Category", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", wo.TITLE AS "Subject", wotodesc.FULLDESCRIPTION AS "Description", urgdef.NAME AS "Urgency", ti.FIRST_NAME AS "Technician", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", longtodate(wo.CREATEDTIME) AS "Created Time", longtodate(wo.DUEBYTIME) AS "DueBy Time", longtodate(wo.RESPONDEDTIME) AS "Responded Date", longtodate(wo.COMPLETEDTIME) AS "Completed Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID 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 UrgencyDefinition urgdef ON wos.URGENCYID=urgdef.URGENCYID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((((qd.QUEUENAME = 'SAP HR') OR ((((((dpt.DEPTNAME = 'Corporate Human Resources') OR (dpt.DEPTNAME = 'Human Resource')) OR (dpt.DEPTNAME = 'Operations Human Resource')) OR (dpt.DEPTNAME = 'People & Performance')) OR (dpt.DEPTNAME = 'Remuneration & Benefits')) OR (dpt.DEPTNAME = 'Talent & Organisational D'))) AND (((std.STATUSNAME = 'Onhold') OR (std.STATUSNAME = 'Open')) OR (std.STATUSNAME::TEXT IS NULL))) AND (((longtodate(wo.CREATEDTIME) >= datetolong('1401631200000') AND ((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL))) AND ((longtodate(wo.CREATEDTIME) <= datetolong('4125995999000') AND (((longtodate(wo.CREATEDTIME) != 0) AND (longtodate(wo.CREATEDTIME) IS NOT NULL)) AND (longtodate(wo.CREATEDTIME) != -1))))) AND wo.ISPARENT='1' ORDER BY 1 NULLS FIRST