USP_TASKREMINDERALERT_GETAPPUSERINFORMATION
Gets App User information for the 'Task reminder alert'.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPUSERID | uniqueidentifier | IN | |
| @ALERTENABLED | bit | INOUT | |
| @EMAILADDRESS | nvarchar(100) | INOUT |
Definition
Copy
create procedure dbo.USP_TASKREMINDERALERT_GETAPPUSERINFORMATION
(
@APPUSERID uniqueidentifier
, @ALERTENABLED bit = 0 output
, @EMAILADDRESS nvarchar(100) = null output
)
as
begin
set nocount on;
if exists (select top(1) ID from dbo.APPUSERALERTTYPESETTING where (APPUSERID = @APPUSERID) and (ALERTTYPEID = '02863BF9-BA85-481E-8AA0-CC60758C6789') and (ENABLED = 1))
set @ALERTENABLED = 1
else
set @ALERTENABLED = 0
set @EMAILADDRESS = dbo.UFN_APPUSER_GETALERTEMAILADDRESS(@APPUSERID);
return 0;
end