pears.NetOwnerCandidateSelect [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetOwnerCandidateSelect ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
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;
*/
}
</code>