pears.NetOwnerGetFavTitles

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;
*/
}