pears.NetOwnerGetFavTitles [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.NetOwnerGetFavTitles ======
<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"."NetOwnerGetFavTitles"( in "pWebUserID" char(20) ) 
/* RESULT( column_name column_type, ... ) */
begin
  select "Description" as "Descrip","FavouritesID" as "Value" from "favourites" where not("Description" = '') and "Staffid" = "userStaffID"
end /* DOC
2016-12-01 PC doc and test
2019-07-09 ET updated to use userStaffID

Inputs:
pWebUserID

Outputs:
unnamed

Tests:
invalid pWebUserID
valid pWebUserID

*/
/* TEST
call NetTestSetup('');
update iqxnetuserlink set employmentid=null where IQXNetUserLinkID in ('test.client','test.agency','test.candidate','test.owner');
update iqxnetuserlink set employmentid='TEST' where IQXNetUserLinkID='test.owner';
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST', null, null, 'TEST', '', 'H');
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST2', 'TEST', 'TEST', 'TEST', 'test', 'P');
select * from NetOwnerGetFavTitles(null);
expect EOF;
select * from NetOwnerGetFavTitles('test.owner') order by Descrip asc;
expect Descrip=test,Value=TEST2;
expect EOF;
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerGetFavTitles" IS 
{create PROCEDURE pears."NetOwnerGetFavTitles"( in "pWebUserID" char(20) )
/* RESULT( column_name column_type, ... ) */
BEGIN
    select Description as Descrip, FavouritesID as Value from favourites where not(Description = '') and Staffid = userStaffID;
END

/* DOC
2016-12-01 PC doc and test
2019-07-09 ET updated to use userStaffID

Inputs:
    pWebUserID

Outputs:
    unnamed

Tests:
    invalid pWebUserID
    valid pWebUserID

*/

/* TEST
call NetTestSetup('');
update iqxnetuserlink set employmentid=null where IQXNetUserLinkID in ('test.client','test.agency','test.candidate','test.owner');
update iqxnetuserlink set employmentid='TEST' where IQXNetUserLinkID='test.owner';
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST', null, null, 'TEST', '', 'H');
insert into Favourites (FavouritesID, Parent, ID, Staffid, Description, Type) on existing skip values ('TEST2', 'TEST', 'TEST', 'TEST', 'test', 'P');
select * from NetOwnerGetFavTitles(null);
expect EOF;
select * from NetOwnerGetFavTitles('test.owner') order by Descrip asc;
expect Descrip=test,Value=TEST2;
expect EOF;
*/
}
</code>