USP_DATAFORMTEMPLATE_VIEW_MKTRECORDSOURCE

The load procedure used by the view dataform template "Record Source View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(255)	INOUT	Name
@CODE	nvarchar(10)	INOUT	Code
@DESCRIPTION	nvarchar(max)	INOUT	Description
@RECORDTYPE	nvarchar(50)	INOUT	Type
@GIFTSOURCEDEFINED	bit	INOUT	Gift source defined
@APPEALSOURCEDEFINED	bit	INOUT	Appeal source defined
@MEMBERSHIPSOURCEDEFINED	bit	INOUT	Membership source defined
@DUPCRITERIADEFINED	bit	INOUT	Duplicate criteria defined
@FIELDMAPPINGSDEFINED	bit	INOUT	Field mappings defined
@SMARTQUERIESEXIST	bit	INOUT	Smart queries exist
@SEGMENTCOUNT	int	INOUT	Segments
@LISTCOUNT	int	INOUT	Lists
@MAILINGCOUNT	int	INOUT	Efforts
@EXPORTCOUNT	int	INOUT	Exports
@QUERYCOUNT	int	INOUT	Selections
@ISBBEC	bit	INOUT	Is BBEC?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Membership renewal efforts installed?
@SOURCEANALYSISRULEID	uniqueidentifier	INOUT	Source analysis rule ID
@SPONSORSHIPSOURCEDEFINED	bit	INOUT
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTRECORDSOURCE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(255) = null output,
  @CODE nvarchar(10) = null output,
  @DESCRIPTION nvarchar(max) = null output,
  @RECORDTYPE nvarchar(50) = null output,
  @GIFTSOURCEDEFINED bit = null output,
  @APPEALSOURCEDEFINED bit = null output,
  @MEMBERSHIPSOURCEDEFINED bit = null output,
  @DUPCRITERIADEFINED bit = null output,
  @FIELDMAPPINGSDEFINED bit = null output,
  @SMARTQUERIESEXIST bit = null output,
  @SEGMENTCOUNT int = null output,
  @LISTCOUNT int = null output,
  @MAILINGCOUNT int = null output,
  @EXPORTCOUNT int = null output,
  @QUERYCOUNT int = null output,
  @ISBBEC bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SOURCEANALYSISRULEID uniqueidentifier = null output,
  @SPONSORSHIPSOURCEDEFINED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select 
    @DATALOADED = 1,
    @NAME = [QUERYVIEWCATALOG].[DISPLAYNAME],
    @CODE = [MKTRECORDSOURCE].[CODE],
    @DESCRIPTION = [QUERYVIEWCATALOG].[DESCRIPTION],
    @RECORDTYPE = [RECORDTYPE].[NAME],
    @FIELDMAPPINGSDEFINED = (case when dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET]([MKTRECORDSOURCE].[ID], 1) = 1 then 1 else 0 end),
    @GIFTSOURCEDEFINED = (case when dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET]([MKTRECORDSOURCE].[ID], 2) = 1 then 1 else 0 end),
    @APPEALSOURCEDEFINED = (case when dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET]([MKTRECORDSOURCE].[ID], 3) = 1 then 1 else 0 end),
    @MEMBERSHIPSOURCEDEFINED = (case when dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET]([MKTRECORDSOURCE].[ID], 4) = 1 then 1 else 0 end),
    @SPONSORSHIPSOURCEDEFINED = (case when dbo.[UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET]([MKTRECORDSOURCE].[ID], 5) = 1 then 1 else 0 end),
    @DUPCRITERIADEFINED = (select case when exists(select [MKTDUPLICATE].[ID] from dbo.[MKTDUPLICATE] inner join dbo.[MKTDUPLICATEFIELD] on [MKTDUPLICATEFIELD].[DUPLICATEID] = [MKTDUPLICATE].[ID] where [MKTDUPLICATE].[QUERYVIEWCATALOGID] = [MKTRECORDSOURCE].[ID]) then 'true' else 'false' end), 
    @SMARTQUERIESEXIST = dbo.[UFN_MKTSELECTION_SMARTQUERIESEXIST](1),
    @SEGMENTCOUNT = [STATS].[SEGMENTCOUNT],
    @LISTCOUNT = [STATS].[LISTCOUNT],
    @MAILINGCOUNT = [STATS].[MAILINGCOUNT],
    @EXPORTCOUNT = [STATS].[EXPORTCOUNT],
    @QUERYCOUNT = [STATS].[QUERYCOUNT],
    @SOURCEANALYSISRULEID = [MKTSOURCEANALYSISRULES].[ID]
  from dbo.[MKTRECORDSOURCE]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
  inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [QUERYVIEWCATALOG].[RECORDTYPEID]
  inner join dbo.[UFN_MKTRECORDSOURCE_GETUSAGESTATISTICS]() [STATS] on [MKTRECORDSOURCE].[ID]=[STATS].[ID]
  left outer join dbo.[MKTDUPLICATE] on [MKTDUPLICATE].[QUERYVIEWCATALOGID] = [MKTRECORDSOURCE].[ID]
  left outer join dbo.[MKTSOURCEANALYSISRULES] on [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] = [MKTRECORDSOURCE].[ID]
  where [MKTRECORDSOURCE].[ID] = @ID and dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1;

  set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);
  set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
  set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();

  return 0;