Purchase Request details
Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", pr.SHIPPING_DETAILS AS "Shipping Details", au.FIRST_NAME AS "Created By", req_au.FIRST_NAME AS "Requested By", tec_au.FIRST_NAME AS "Technician", prp.NAME AS "Priority", pos.STATUSNAME AS "Status", pri.ITEMNAME AS "Product", pri.QUANTITY AS "Quantity Of Items" FROM PurchaseRequest pr LEFT JOIN SDUser sdu ON pr.CREATEDBY = sdu.USERID LEFT JOIN AAAUser au ON sdu.USERID = au.USER_ID LEFT JOIN SDUser req_sdu ON pr.REQUESTEDBY = req_sdu.USERID LEFT JOIN AAAUser req_au ON req_sdu.USERID = req_au.USER_ID LEFT JOIN SDUser tec_sdu ON pr.TECHNICIANID = tec_sdu.USERID LEFT JOIN AAAUser tec_au ON req_sdu.USERID = tec_au.USER_ID LEFT JOIN PRPriority prp ON pr.PRIORITYID = prp.PRIORITYID LEFT JOIN POStatus pos ON pr.STATUSID = pos.STATUSID LEFT JOIN PRRequestedItems pri ON pr.REQUESTID = pri.REQUESTID
New to ADSelfService Plus?
Related Articles
Purchase details
SELECT po.POCUSTOMID "PO Number", max(po.PONAME) "PO Name", max(po.TERMS) "PO Terms", LONGTODATE(max(po.DATEORDERED)) "Ordered Date", max(pos.STATUSNAME) "PO Status", max(poa.FIRST_NAME) "Purchase Requester", max(po.SHIPTO) "Ship To", max(paao.NAME) ...Purchase Request Approval
SELECT pr.Requestid "Requestid", pr.Subject "Subject", pr.Description "Description", longtodate(pr.Requesteddate) "Requesteddate", longtodate(pr.Daterequired) "Daterequired", longtodate(pr.createddate) "createddate", pr.Shipping_details ...Purchase order approval details
SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", max(poa.FIRST_NAME) AS "Purchase Requester", longtodate(max(po.DATEORDERED)) AS "Ordered Date", longtodate(max(po.DATEREQUIRED)) AS "Required Date", max(pos.STATUSNAME) AS "PO Status", ...Query to list Service Request Approver and Purchase Request Approver (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Select aau.first_name "Name", po.approverstatus "Purchase Request Approver", sr.approverstatus "Service Request Approver", adef.org_name "Account" from aaauser aau left join POApproverDetails po on ...Query for request attachment details (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Requests with Attachment, its name and path SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", sa.ATTACHMENTNAME "Attachment ...