USP_DATALIST_CORRESPONDENCECODE

This datalist returns the correspondence code datalist.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN
@SECURITYFEATUREID	uniqueidentifier	IN	Input parameter indicating the ID of the feature to use for site security checking.
@SECURITYFEATURETYPE	tinyint	IN	Input parameter indicating the type of the feature to use for site security checking.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CORRESPONDENCECODE
                (
                    @INCLUDEINACTIVE bit = 1,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null       
                )
                as
                    set nocount on;

                    select 
                        CORRESPONDENCECODE.ID,
                        CORRESPONDENCECODE.NAME,
                        CORRESPONDENCECODE.DESCRIPTION,
                        CORRESPONDENCECODE.ISACTIVE,
                        CORRESPONDENCECATEGORYCODE.DESCRIPTION,
                        SITE.NAME SITE
                    from 
                        dbo.CORRESPONDENCECODE
                        left outer join dbo.CORRESPONDENCECATEGORYCODE
                            on CORRESPONDENCECODE.CATEGORYCODEID = CORRESPONDENCECATEGORYCODE.ID
                        left outer join dbo.SITE
                            on SITE.ID = CORRESPONDENCECODE.SITEID
                    where
                        (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[CORRESPONDENCECODE].[SITEID] or (SITEID is null and [CORRESPONDENCECODE].[SITEID] is null)))
                        and
                        (
                            @SITEFILTERMODE = 0
                                or CORRESPONDENCECODE.SITEID in ( 
                                    select SITEID
                                    from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
                                )
                        ) and
                        (CORRESPONDENCECODE.ISACTIVE = 1 OR @INCLUDEINACTIVE = 1)
                    order by NAME;