USP_DATAFORMTEMPLATE_VIEW_EMAILFINDERPAGEEXPRESSION

The load procedure used by the view dataform template "EmailFinder Page Expression 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.
@FILEUPLOADED	bit	INOUT	File uploaded
@FILEAVAILABLE	bit	INOUT	File available
@FILEDOWNLOADED	bit	INOUT	File downloaded
@EMAILFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	EmailFinder submit process ID
@EMAILFINDERGETPROCESSID	uniqueidentifier	INOUT	EmailFinder get process ID
@STEPCODE	tinyint	INOUT	Step code
@NAME	nvarchar(150)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@SITEID	uniqueidentifier	INOUT	Site ID
@SITENAME	nvarchar(150)	INOUT	Site name
@PAGECAPTION	nvarchar(300)	INOUT	Page caption
@BATCHID	uniqueidentifier	INOUT	Batch Id
@BATCHSTATUSCODE	tinyint	INOUT	Batch status code
@ALLOWCOMMIT	bit	INOUT	Allow commit

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EMAILFINDERPAGEEXPRESSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @FILEUPLOADED bit = null output,
    @FILEAVAILABLE bit = null output,
    @FILEDOWNLOADED bit = null output,
    @EMAILFINDERSUBMITPROCESSID uniqueidentifier = null output,
    @EMAILFINDERGETPROCESSID uniqueidentifier = null output,
    @STEPCODE tinyint = null output,
    @NAME nvarchar(150) = null output,
    @DESCRIPTION nvarchar(250) = null output,
    @SITEID uniqueidentifier = null output,
    @SITENAME nvarchar(150) = null output,
    @PAGECAPTION nvarchar(300) = null output,
    @BATCHID uniqueidentifier = null output,
    @BATCHSTATUSCODE tinyint = null output,
    @ALLOWCOMMIT bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
        @FILEUPLOADED = EMAILFINDER.FILEUPLOADED,
        @FILEAVAILABLE = EMAILFINDER.FILEAVAILABLE,
        @FILEDOWNLOADED = EMAILFINDER.FILEDOWNLOADED,
        @EMAILFINDERSUBMITPROCESSID = SUBMIT.ID,
        @EMAILFINDERGETPROCESSID = GET.ID,
        @STEPCODE = EMAILFINDER.STEPCODE,
        @NAME = EMAILFINDER.NAME,
        @DESCRIPTION = EMAILFINDER.DESCRIPTION,
        @SITEID = EMAILFINDER.SITEID,
        @SITENAME = SITE.NAME,
        @PAGECAPTION = coalesce(SITE.NAME + ' - ', '') + coalesce(EMAILFINDER.NAME, ''),
        @BATCHID = EMAILFINDER.BATCHID,
        @BATCHSTATUSCODE = dbo.UFN_BATCH_GETSTATUSCODE(EMAILFINDER.BATCHID)
    from 
        dbo.EMAILFINDER
    inner join
        dbo.EMAILFINDERSUBMITPROCESS SUBMIT on SUBMIT.EMAILFINDERID = EMAILFINDER.ID
    inner join
        dbo.EMAILFINDERGETPROCESS GET on GET.EMAILFINDERID = EMAILFINDER.ID
    left join
        dbo.SITE on EMAILFINDER.SITEID = SITE.ID
    where
        EMAILFINDER.ID = @ID;

    if @DATALOADED = 1
        select 
            @ALLOWCOMMIT = BATCHWORKFLOWSTATE.ALLOWCOMMIT
        from 
            dbo.BATCHWORKFLOWSTATE
        inner join 
            dbo.BATCHWORKFLOW on BATCHWORKFLOW.ID = BATCHWORKFLOWSTATE.BATCHWORKFLOWID
        where
            BATCHWORKFLOW.BATCHTYPECATALOGID = 'df0f31dd-eecd-4688-8b56-1dce8051e967'

    return 0;