Dear Developers.

Can you help me please.

I need to add string with "type of request" in this query.  Thanks a lot for the answer.

SELECT wo.WORKORDERID "Request ID",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",wo.TITLE "Subject",sdo.NAME "Site",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.RESPONDEDTIME) "Responded Date",longtodate(wo.RESOLVEDTIME) "Resolved Time",longtodate(wo.COMPLETEDTIME) "Completed Time",longtodate(wo.DUEBYTIME) "DueBy Time",wos.ISOVERDUE "Overdue Status" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID 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_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE  wo.CREATEDTIME >= <from_lastyear> AND wo.CREATEDTIME <= <to_lastyear>

UNION

SELECT arcwo.WORKORDERID "Request ID",arcwo.QUEUENAME "Group",arcTech.FIRST_NAME "Assigned Technician",arcwo.CATEGORYNAME "Category",arcwo.SUBCATEGORYNAME "Subcategory",arcwo.ITEMNAME "Item",arcwo.TITLE "Subject",arcwo.SITENAME "Site",arcRequester.FIRST_NAME "Requester",arcwo.STATUSNAME "Status",longtodate(arcwo.CREATEDTIME) "Created Time",longtodate(arcwo.RESPONDEDTIME) "Responded Date",longtodate(arcwo.RESOLVEDTIME) "Resolved Time", longtodate(arcwo.COMPLETEDTIME) "Completed Time",longtodate(arcwo.DUEBYTIME) "DueBy Time", arcwo.ISOVERDUE "Overdue Status" FROM Arc_WorkOrder arcwo LEFT JOIN AaaUser arcRequester ON arcwo.REQUESTERID=arcRequester.USER_ID LEFT JOIN AaaUser arcTech ON arcwo.OWNERID=arcTech.USER_ID WHERE arcwo.CREATEDTIME >= <from_lastyear> AND arcwo.CREATEDTIME <= <to_lastyear>