pears.NetAgencyCandidateProgressHistory

CREATE PROCEDURE "pears"."NetAgencyCandidateProgressHistory"( IN "pWebUserID" CHAR(20),IN "pProgressID" CHAR(20) ) 
RESULT( "ActionName" CHAR(100),"ActionDate" CHAR(10),"ActionTime" CHAR(10),"StaffName" CHAR(60) ) 
-- 20120817 modified for NetOleProgress
BEGIN
  SELECT "s"."name" AS "ActionName",
    "HistoryDate" AS "ActionDate",
    "HistoryTime" AS "ActionTime",
    "st"."name" AS "StaffName"
    FROM "progress" AS "p"
      LEFT OUTER JOIN "progressHistory" AS "ph"
      JOIN "status" AS "s" ON "ph"."status" = "s"."status"
      JOIN "staff" AS "st" ON "ph"."staffid" = "st"."staffid"
    WHERE "s"."type" = 'R'
    AND "s"."publishtoweb" = '1'
    AND "p"."progressid" = "pProgressID"
    ORDER BY "Historydate" DESC,"HistoryTime" DESC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyCandidateProgressHistory" IS 
{CREATE PROCEDURE pears."NetAgencyCandidateProgressHistory"( IN "pWebUserID" CHAR(20),IN "pProgressID" CHAR(20) ) 
RESULT( "ActionName" CHAR(100),"ActionDate" CHAR(10),"ActionTime" CHAR(10),"StaffName" CHAR(60) ) 
-- 20120817 modified for NetOleProgress
BEGIN
  SELECT "s"."name" AS "ActionName",
    "HistoryDate" AS "ActionDate",
    "HistoryTime" AS "ActionTime",
    "st"."name" AS "StaffName"
    FROM "progress" AS "p"
      LEFT OUTER JOIN "progressHistory" AS "ph"
      JOIN "status" AS "s" ON "ph"."status" = "s"."status"
      JOIN "staff" AS "st" ON "ph"."staffid" = "st"."staffid"
    WHERE "s"."type" = 'R'
    AND "s"."publishtoweb" = '1'
    AND "p"."progressid" = "pProgressID"
    ORDER BY "Historydate" DESC,"HistoryTime" DESC
END
}