Please sign in...

Workflow


Label

SELECT web_user.EAF_RequestList1.SubmittedForName, web_user.EAF_RequestList1.TaskIDname, web_user.EAF_RequestList1.Request_id, web_user.EAF_RequestList1.TaskName, web_user.EAF_RequestList1.TaskFor, web_user.EAF_RequestList1.Action, web_user.EAF_RequestList1.SubmitBy, web_user.EAF_RequestList1.ApprovedBy, web_user.EAF_RequestList1.Notes, web_user.EAF_RequestList1.Active, web_user.EAF_RequestList1.TimeStamp, web_user.EAF_RequestList1.RejectedBy, web_user.EAF_RequestList1.Stat_Name, web_user.EAF_RequestList1.Stat_Active, { fn CONCAT(web_user.EAF_OrgTree.lastname, ', ' + web_user.EAF_OrgTree.firstname) } AS SubmittedBy, web_user.EAF_RequestList1.branch FROM web_user.EAF_RequestList1 INNER JOIN web_user.EAF_OrgTree ON web_user.EAF_RequestList1.branch = web_user.EAF_OrgTree.empID WHERE (web_user.EAF_RequestList1.branch = )