pears.NetOwnerCandidateSelect

CREATE PROCEDURE "pears"."NetOwnerCandidateSelect"( IN "pWebUserID" CHAR(20) ) 
RESULT( "value" CHAR(5),"name" CHAR(25),"sortorder" INTEGER ) 
// IQXWeb
BEGIN
  SELECT "status" AS "PK","name" AS "Title","sortorder" FROM "status" WHERE "type" = 'P' AND "PublishToWeb" = 1 UNION
  SELECT '%' AS "PK",'All' AS "name",-99999 AS "sortorder"
    ORDER BY "sortorder" ASC
END /* DOC
2016-09-22 PC
Ref:IW4 
provide filter dropdown for Candidate status select box
2018-5-1 MHS simplify and simplify test
 
inputs:
pWebUserID
 
outputs:
PK - select code
Title - text for dropdown box
 
tests:
null pWebUserID
invalid pWebUserID
valid pWebUserID
add test status with sort order 0
*/
/* TEST
select value,name from NetOwnerCandidateSelect('test.owner');
expect %,All;
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerCandidateSelect" IS 
{CREATE PROCEDURE pears."NetOwnerCandidateSelect"(IN pWebUserID CHAR(20))
RESULT("value" CHAR(5),"name" CHAR(25),sortorder INTEGER)
// IQXWeb
BEGIN
    SELECT STATUS AS PK,name AS Title,sortorder FROM STATUS WHERE TYPE='P' AND PublishToWeb=1 
    UNION
    SELECT '%' AS PK,'All' AS name,-99999 AS sortorder
    ORDER BY sortorder
END
 
/* DOC
2016-09-22 PC
Ref:IW4 
provide filter dropdown for Candidate status select box
2018-5-1 MHS simplify and simplify test
 
inputs:
    pWebUserID
 
outputs:
    PK - select code
    Title - text for dropdown box
 
tests:
    null pWebUserID
    invalid pWebUserID
    valid pWebUserID
    add test status with sort order 0
*/
 
/* TEST
select value,name from NetOwnerCandidateSelect('test.owner');
expect %,All;
*/
}