USP_DATALIST_MKTLISTLAYOUT_CONSTITUENTFILEIMPORT

A datalist of constituent file import list layouts

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN	Record source
@SITEFILTERMODE	tinyint	IN	Sites
@SITESSELECTED	xml	IN	Sites selected
@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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTLISTLAYOUT_CONSTITUENTFILEIMPORT]
(
  @RECORDSOURCEID uniqueidentifier = null,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  select
    [MKTLISTLAYOUT].[ID],
    [MKTLISTLAYOUT].[NAME],
    [MKTLISTLAYOUT].[DESCRIPTION],
    [QUERYVIEWCATALOG].[DISPLAYNAME],
    dbo.[UFN_TRANSLATIONFUNCTION_SITE_GETNAME]([MKTLISTLAYOUT].[SITEID]) as [SITE]
  from dbo.[MKTLISTLAYOUT]
  left outer join dbo.[MKTRECORDSOURCE] on [MKTLISTLAYOUT].[RECORDSOURCEID] = [MKTRECORDSOURCE].[ID]
  left outer join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
  where 
    (@RECORDSOURCEID is null or @RECORDSOURCEID=[MKTLISTLAYOUT].[RECORDSOURCEID])
    and ((@RECORDSOURCEID is not null and dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT](@RECORDSOURCEID) = 1) or dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTLISTLAYOUT].[RECORDSOURCEID]) = 1)
    and [MKTLISTLAYOUT].[TYPECODE] = 2
    and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTLISTLAYOUT].[SITEID] or (SITEID is null and [MKTLISTLAYOUT].[SITEID] is null)))
    and (@SITEFILTERMODE = 0 or [MKTLISTLAYOUT].[SITEID] in (select [SITEID] from dbo.[UFN_SITE_BUILDDATALISTSITEFILTER](@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED)))
  order by [MKTLISTLAYOUT].[NAME];

  return 0;