Reporting on Custom Field (Not Common)
MSSQL SDP 9.4 Build 9419
Hi i would like to run the below query but i need to include a field called "Category of the Request" with the below details:
API Field Name Type Column Name
udf_pick_1216 Pick List - - UDF_CHAR32
SELECT "wo"."WORKORDERID" AS "Request ID", "scf"."GUDF_CHAR2" AS "PR Priority", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "cd"."CATEGORYNAME" AS "Category", "wo"."TITLE" AS "Subject", "cri"."FIRST_NAME" AS "Created By", "ti"."FIRST_NAME" AS "Technician", "sdo"."NAME" AS "Site", "appStDef"."STATUSNAME" AS "Approval Status", "std"."STATUSNAME" AS "Request Status", "std"."ISPENDING" AS "Pending Status", "wo"."CREATEDTIME" AS "Created Time", "scf"."GUDF_CHAR1" AS "Assigned to Buyer:" 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 "SDUser" "crd" ON "wo"."CREATEDBYID"="crd"."USERID" LEFT JOIN "AaaUser" "cri" ON "crd"."USERID"="cri"."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 "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "ApprovalStatusDefinition" "appStDef" ON "wos"."APPR_STATUSID"="appStDef"."STATUSID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" LEFT JOIN "ServiceCatalog_Fields" "scf" ON "wo"."WORKORDERID"="scf"."WORKORDERID" WHERE ("cd"."CATEGORYNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Purchase Request') AND wo.ISPARENT='1'
Hi i would like to run the below query but i need to include a field called "Category of the Request" with the below details:
API Field Name Type Column Name
udf_pick_1216 Pick List - - UDF_CHAR32
SELECT "wo"."WORKORDERID" AS "Request ID", "scf"."GUDF_CHAR2" AS "PR Priority", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "cd"."CATEGORYNAME" AS "Category", "wo"."TITLE" AS "Subject", "cri"."FIRST_NAME" AS "Created By", "ti"."FIRST_NAME" AS "Technician", "sdo"."NAME" AS "Site", "appStDef"."STATUSNAME" AS "Approval Status", "std"."STATUSNAME" AS "Request Status", "std"."ISPENDING" AS "Pending Status", "wo"."CREATEDTIME" AS "Created Time", "scf"."GUDF_CHAR1" AS "Assigned to Buyer:" 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 "SDUser" "crd" ON "wo"."CREATEDBYID"="crd"."USERID" LEFT JOIN "AaaUser" "cri" ON "crd"."USERID"="cri"."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 "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "ApprovalStatusDefinition" "appStDef" ON "wos"."APPR_STATUSID"="appStDef"."STATUSID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" LEFT JOIN "ServiceCatalog_Fields" "scf" ON "wo"."WORKORDERID"="scf"."WORKORDERID" WHERE ("cd"."CATEGORYNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Purchase Request') AND wo.ISPARENT='1'