Query Report to show the leave details of the technicians in a report (PGSQL)
Columns :
- leaveid
- createdby
- createddate
- technician & technician id
- backup technician & backup technician id
- comments
- leavedate
- leavetype
Query :
SELECT tu.LEAVEID,tu.CREATEDBY, LONGTODATE(tu.CREATEDDATE) AS CREATEDDATE,tu.TECHNICIANID,au.first_name AS technician, tu.LEAVETYPEID,tu.BACKUPTECHNICIANID,bu.first_name AS backup_technician,tu.COMMENTS,tu.TECHNICIANID_AUTOID,tu.BACKUPTECHNICIANID_AUTOID,LONGTODATE(du.LEAVEDATE) AS LEAVEDATE,ltd.NAME AS leavetype FROM TechUnavailability tu LEFT JOIN DateUnAvailability du ON tu.LEAVEID = du.LEAVEID LEFT JOIN LeaveTypeDefinition ltd ON tu.LEAVETYPEID = ltd.LEAVETYPEID LEFT JOIN aaauser au ON tu.TECHNICIANID = au.user_id LEFT JOIN aaauser bu ON tu.BACKUPTECHNICIANID = bu.user_id order by du.LEAVEDATE;
New to ADSelfService Plus?
Related Articles
Query to show Technician leave details (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date", ta.comments "Leave Comments" from techunavailability ta left join aaauser au on ...Query to show purchase order full details (PGSQL)
Tested in PGSQL build (14300) SELECT po.POCUSTOMID AS "Order No.",poi.serialno "S.No", poaddfield.UDF_CHAR1 AS "Legal Entity", po.PONAME AS "PO Name", pos.STATUSNAME AS "PO Status", cy.currencyname "Currency", paao.NAME AS "Vendor Name", po.SHIPTO AS ...Query to show request details along with technician's and requester's department (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Along with technician's department: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", qd.QUEUENAME AS ...Query to show technicians associated accounts, sites and Support groups - (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 1.Technicians and associated Accounts/Sites: select aau.User_id, aau.first_name "First Name", sdu.lastname "Last Name", aal.name "Login Name", AaaContactInfo.EMAILID "Email Address",sdu.jobtitle "Job ...Query to show technicians and associated groups (Not working )
Doesnt work in builds from PGSQL (14300) ERROR: missing FROM-clause entry for table "helpdeskcrew" SELECT AaaUser.FIRST_NAME "Technician Name", (sdo.NAME) "Associated Site", array_to_string(array_agg(distinct(qd.queuename)), ',') "Associated Group" ...