USP_DATAFORMTEMPLATE_VIEW_PEOPLEFINDERPAGEEXPRESSION

The load procedure used by the view dataform template "PeopleFinder 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
@PEOPLEFINDERSUBMITPROCESSID	uniqueidentifier	INOUT	PeopleFinder submit process ID
@PEOPLEFINDERGETPROCESSID	uniqueidentifier	INOUT	PeopleFinder 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_PEOPLEFINDERPAGEEXPRESSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @FILEUPLOADED bit = null output,
    @FILEAVAILABLE bit = null output,
    @FILEDOWNLOADED bit = null output,
    @PEOPLEFINDERSUBMITPROCESSID uniqueidentifier = null output,
    @PEOPLEFINDERGETPROCESSID 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 = PEOPLEFINDER.FILEUPLOADED,
        @FILEAVAILABLE = PEOPLEFINDER.FILEAVAILABLE,
        @FILEDOWNLOADED = PEOPLEFINDER.FILEDOWNLOADED,
        @PEOPLEFINDERSUBMITPROCESSID = SUBMIT.ID,
        @PEOPLEFINDERGETPROCESSID = GET.ID,
        @STEPCODE = PEOPLEFINDER.STEPCODE,
        @NAME = PEOPLEFINDER.NAME,
        @DESCRIPTION = PEOPLEFINDER.DESCRIPTION,
        @SITEID = PEOPLEFINDER.SITEID,
        @SITENAME = SITE.NAME,
        @PAGECAPTION = coalesce(SITE.NAME + ' - ', '') + coalesce(PEOPLEFINDER.NAME, ''),
        @BATCHID = PEOPLEFINDER.BATCHID,
        @BATCHSTATUSCODE = dbo.UFN_BATCH_GETSTATUSCODE(PEOPLEFINDER.BATCHID)
    from 
        dbo.PEOPLEFINDER
    inner join
        dbo.PEOPLEFINDERSUBMITPROCESS SUBMIT on SUBMIT.PEOPLEFINDERID = PEOPLEFINDER.ID
    inner join
        dbo.PEOPLEFINDERGETPROCESS GET on GET.PEOPLEFINDERID = PEOPLEFINDER.ID
    left join
        dbo.SITE on PEOPLEFINDER.SITEID = SITE.ID
    where
        PEOPLEFINDER.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;