USP_DATALIST_NAMEFORMATPARAMETER

A list of name format parameter sets.

Parameters

Parameter	Parameter Type	Mode	Description
@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_NAMEFORMATPARAMETER]
(
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
  set nocount on;

  select 
    [NAMEFORMATPARAMETER].[ID],
    [NAMEFORMATPARAMETER].[NAME],
    [NAMEFORMATPARAMETER].[DESCRIPTION],
    [NAMEFORMATPARAMETER].[ISDEFAULT],
    coalesce([SITE].[NAME], 'All sites'), /* should be localized */
    [NAMEFORMATPARAMETER].[ISSYSTEM],
    case when [NAMEFORMATPARAMETER].[SITEID] is null 
        then dbo.UFN_SITEALLOWEDFORUSERONFEATURE(@CURRENTAPPUSERID,null,@SECURITYFEATUREID,@SECURITYFEATURETYPE)
        else 1
    end ENABLEEDIT
  from dbo.[NAMEFORMATPARAMETER]
  left outer join dbo.[SITE] on [SITE].[ID] = [NAMEFORMATPARAMETER].[SITEID]
  where
  (
    [NAMEFORMATPARAMETER].[SITEID] is null 
    or (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[NAMEFORMATPARAMETER].[SITEID] or (SITEID is null and [NAMEFORMATPARAMETER].[SITEID] is null))) 
  ) and (
    @SITEFILTERMODE = 0
    or [NAMEFORMATPARAMETER].[SITEID] in ( 
      select [SITEID]
      from dbo.[UFN_SITE_BUILDDATALISTSITEFILTER](@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)
    )
  )
  order by [NAMEFORMATPARAMETER].[NAME]