USP_SIMPLELIST_NO_CONSTITUENTNAMEFORMATS

Returns the name formats for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	CONSTITUENTID
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN
@NAMINGOPPORTUNITYRECOGNITIONID	uniqueidentifier	IN	NAMINGOPPORTUNITYRECOGNITIONID

Definition

Copy



CREATE procedure dbo.USP_SIMPLELIST_NO_CONSTITUENTNAMEFORMATS
(
  @CONSTITUENTID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @NAMINGOPPORTUNITYRECOGNITIONID uniqueidentifier = null
)
as
  select
    ID as [VALUE],
    FORMATTEDNAME as [LABEL]
  from
  (
    select
      ID,
      FORMATTEDNAME,
      SEQUENCE
    from
      dbo.NAMEFORMAT 
    where 
      CONSTITUENTID = @CONSTITUENTID
      and (SITEID is null or (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[NAMEFORMAT].[SITEID] or (SITEID is null and [NAMEFORMAT].[SITEID] is null))))

    union

    select
      NAMEFORMAT.ID,
      NAMEFORMAT.FORMATTEDNAME,
      NAMEFORMAT.SEQUENCE
    from
      dbo.NAMINGOPPORTUNITYRECOGNITION
    inner join
      dbo.NAMEFORMAT on NAMEFORMAT.ID = NAMINGOPPORTUNITYRECOGNITION.CONSTITUENTNAMEFORMATID
    where
      NAMINGOPPORTUNITYRECOGNITION.ID = @NAMINGOPPORTUNITYRECOGNITIONID
  ) as NAMEFORMATS
  order by
    SEQUENCE;