pears.NetOwnerTimesheetCandidateSearch

CREATE PROCEDURE "pears"."NetOwnerTimesheetCandidateSearch"( IN "pWebUserID" CHAR(20),IN "SearchValue" CHAR(20) DEFAULT '%' ) 
RESULT( "PersonID" CHAR(20),"Name" CHAR(61),"Address" CHAR(82) ) 
BEGIN
  DECLARE "DivID" CHAR(20);
  DECLARE "CurrentStates" CHAR(30);
  SET "DivID" = (SELECT FIRST "staff"."divisionid" FROM "iqxnetuser" KEY JOIN "staff" WHERE "iqxnetuser"."iqxnetuserid" = "pWebUserID");
  SET "CurrentStates" = "string"('[',(SELECT FIRST "PersonCurrentStates" FROM "params"),']');
  SET "SearchValue" = "replace"("SearchValue",'*','%');
  SELECT "person"."personid" AS "PersonID",
    "person"."forenames"+' '+"person"."surname" AS "Name",
    "GetPersonAddressOnLine"("person"."personid") AS "Address"
    FROM "person"
    WHERE "person"."divisionid" = "DivID" AND "person"."status" LIKE "CurrentStates" AND "person"."keyname" LIKE "SearchValue"+'%'
    ORDER BY "KeyName" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerTimesheetCandidateSearch" IS 
{CREATE PROCEDURE pears."NetOwnerTimesheetCandidateSearch"( IN "pWebUserID" CHAR(20),IN "SearchValue" CHAR(20) DEFAULT '%' ) 
RESULT( "PersonID" CHAR(20),"Name" CHAR(61),"Address" CHAR(82) ) 
BEGIN
  DECLARE "DivID" CHAR(20);
  DECLARE "CurrentStates" CHAR(30);
  SET "DivID" = (SELECT FIRST "staff"."divisionid" FROM "iqxnetuser" KEY JOIN "staff" WHERE "iqxnetuser"."iqxnetuserid" = "pWebUserID");
  SET "CurrentStates" = "string"('[',(SELECT FIRST "PersonCurrentStates" FROM "params"),']');
  SET "SearchValue" = "replace"("SearchValue",'*','%');
  SELECT "person"."personid" AS "PersonID",
    "person"."forenames"+' '+"person"."surname" AS "Name",
    "GetPersonAddressOnLine"("person"."personid") AS "Address"
    FROM "person"
    WHERE "person"."divisionid" = "DivID" AND "person"."status" LIKE "CurrentStates" AND "person"."keyname" LIKE "SearchValue"+'%'
    ORDER BY "KeyName" ASC
END
}