pears.NetOwnerConsultantList

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."NetOwnerConsultantList"( IN "pWebUserID" CHAR(20) ) 
RESULT( "id" CHAR(20),"name" CHAR(100),"isMe" INTEGER ) 
// IQXWeb
BEGIN
  SELECT "staff"."staffid" AS "consultantID",
    "staff"."name" AS "name",
    (IF "staff"."staffid" = "UserStaffID" THEN 1 ELSE 0 endif) AS "isMe"
    FROM "staff"
    WHERE "isnull"("staff"."defunct",0) = 0
    AND "staff"."divisionid" = any(SELECT "divisionid" FROM "dashboardstaffdivisions"())
    ORDER BY "staff"."name" ASC
END /* DOC
 
2019-07-19 ET IW-974 Created new procedure to return a list of cunsultants for which a consultant has division access for.
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerConsultantList" IS 
{CREATE PROCEDURE pears."NetOwnerConsultantList"(IN pWebUserID CHAR(20) )
RESULT(id CHAR(20), name CHAR(100), isMe INTEGER)
 
// IQXWeb
BEGIN
SELECT 
  staff.staffid AS consultantID,
  staff.name AS name,
  (IF staff.staffid=UserStaffID THEN 1 ELSE 0 endif) AS isMe
FROM 
  staff 
WHERE
  isnull(staff.defunct,0)=0 
  AND staff.divisionid IN (SELECT divisionid FROM dashboardstaffdivisions())
ORDER BY 
  staff.name ASC
END
 
/* DOC
 
2019-07-19 ET IW-974 Created new procedure to return a list of cunsultants for which a consultant has division access for.
 
*/
}