SupportCenter Plus Reporting - Notes
Hi there,
I have been able to build the report I need but am missing one column.
I need to include 'Notes' in the report and so far have not been able to find that ability.
Can I get some help on this? Thanks
QUERY
SELECT std.STATUSNAME "Request Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Contact",org.NAME "Account",wo.TITLE "Subject",longtodate(wo.CREATEDTIME) "Created Time",cd.CATEGORYNAME "Category",std.STATUSNAME "Request Status",longtodate(wo.LASTUPDATED) "Last Updated",ocontact.EMAILID "Account Email",ti.FIRST_NAME "Support Rep" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.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 StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Account woacc ON wo.WORKORDERID=woacc.WORKORDERID LEFT JOIN Customer cust ON woacc.ACCOUNTID=cust.CUSTOMER_ID LEFT JOIN AaaOrganization org ON cust.CUSTOMER_ID=org.ORG_ID LEFT JOIN AaaOrgContactInfo org_contact ON org.ORG_ID=org_contact.ORG_ID LEFT JOIN AaaContactInfo ocontact ON org_contact.CONTACTINFO_ID=ocontact.CONTACTINFO_ID WHERE ((((std.STATUSNAME = 'Onhold') OR (std.STATUSNAME = 'Open')) OR (std.STATUSNAME = 'Pending Publisher Confirmation')) AND (wo.DEPARTMENTID = 1)) AND wo.ISPARENT='1' ORDER BY 1
I have been able to build the report I need but am missing one column.
I need to include 'Notes' in the report and so far have not been able to find that ability.
Can I get some help on this? Thanks
QUERY
SELECT std.STATUSNAME "Request Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Contact",org.NAME "Account",wo.TITLE "Subject",longtodate(wo.CREATEDTIME) "Created Time",cd.CATEGORYNAME "Category",std.STATUSNAME "Request Status",longtodate(wo.LASTUPDATED) "Last Updated",ocontact.EMAILID "Account Email",ti.FIRST_NAME "Support Rep" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.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 StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Account woacc ON wo.WORKORDERID=woacc.WORKORDERID LEFT JOIN Customer cust ON woacc.ACCOUNTID=cust.CUSTOMER_ID LEFT JOIN AaaOrganization org ON cust.CUSTOMER_ID=org.ORG_ID LEFT JOIN AaaOrgContactInfo org_contact ON org.ORG_ID=org_contact.ORG_ID LEFT JOIN AaaContactInfo ocontact ON org_contact.CONTACTINFO_ID=ocontact.CONTACTINFO_ID WHERE ((((std.STATUSNAME = 'Onhold') OR (std.STATUSNAME = 'Open')) OR (std.STATUSNAME = 'Pending Publisher Confirmation')) AND (wo.DEPARTMENTID = 1)) AND wo.ISPARENT='1' ORDER BY 1