SIMPLEDATALIST_LETTERTEMPLATE
Simple data list that returns all letter templates in the system.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
CREATE procedure dbo.SIMPLEDATALIST_LETTERTEMPLATE
(
@CURRENTAPPUSERID uniqueidentifier = null,
@SECURITYFEATUREID uniqueidentifier = null,
@SECURITYFEATURETYPE tinyint = null
)
as
set nocount on;
select
LETTERTEMPLATE.ID as VALUE,
LETTERTEMPLATE.NAME as LABEL
from
dbo.LETTERTEMPLATE
where
(
@CURRENTAPPUSERID is null or
(dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[LETTERTEMPLATE].[SITEID] or (SITEID is null and [LETTERTEMPLATE].[SITEID] is null)))
)