pears.NetOwnerContactSelect

CREATE PROCEDURE "pears"."NetOwnerContactSelect"( IN "pWebUserID" CHAR(20) ) 
RESULT( "value" CHAR(5),"name" CHAR(25) ) 
BEGIN
  IF(SELECT "count"() FROM "iqxnetuser" WHERE "iqxnetuserid" = "pWebUserID") = 0 THEN
    SELECT '',''
  ELSE
    SELECT 'L','Contact' AS "name" UNION SELECT '%','All' AS "name" ORDER BY "name" ASC
  --select companystatusid,name from companystatus union select '%','All' as name order by name
  END IF
END /* DOC
2016-09-22 PC IW-4 provide filter dropdown for Contact status select box
2018-04-01 PC IW-465  Search Contacts - restrict to candidates of state L
 
tests:
null pWebUserID
invalid pWebUserID
valid pWebUserID
add test status with sort order 0
*/
/* TEST
call NetTestSetup('');
select string('!',value,'!'),string('!',name,'!') from NetOwnerContactSelect(null);
expect !!,!!;
select string('!',value,'!'),string('!',name,'!') from NetOwnerContactSelect('z99');
expect !!,!!;
select value,name from NetOwnerContactSelect('test.owner');
expect value=%,name=All;
expect value=L,name=Contact;
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerContactSelect" IS 
{CREATE PROCEDURE pears."NetOwnerContactSelect"(IN pWebUserID CHAR(20))
RESULT(VALUE CHAR(5),name CHAR(25))
BEGIN
    IF (SELECT COUNT(*) FROM iqxnetuser WHERE iqxnetuserid=pWebUserID) = 0 THEN
        SELECT '','';
    ELSE
        SELECT 'L','Contact' AS name UNION SELECT '%','All' AS name ORDER BY name
        --select companystatusid,name from companystatus union select '%','All' as name order by name
    END IF;
END
 
/* DOC
2016-09-22 PC IW-4 provide filter dropdown for Contact status select box
2018-04-01 PC IW-465  Search Contacts - restrict to candidates of state L
 
tests:
    null pWebUserID
    invalid pWebUserID
    valid pWebUserID
    add test status with sort order 0
*/
 
/* TEST
call NetTestSetup('');
select string('!',value,'!'),string('!',name,'!') from NetOwnerContactSelect(null);
expect !!,!!;
select string('!',value,'!'),string('!',name,'!') from NetOwnerContactSelect('z99');
expect !!,!!;
select value,name from NetOwnerContactSelect('test.owner');
expect value=%,name=All;
expect value=L,name=Contact;
 
*/
}