USP_DATAFORMTEMPLATE_VIEW_QUEUEPROCESS_MOSTRECENTSTATUS

The load procedure used by the view dataform template "Queue Process most recent status 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.
@STATUSCODE	tinyint	INOUT	Status Code
@STATUS_IS_COMPLETED	bit	INOUT	Status Is Completed
@STATUS_IS_RUNNING	bit	INOUT	Status Is Running
@STATUS_IS_DID_NOT_FINISH	bit	INOUT	Status Is Did Not Finish
@STATUS_IS_RESULTS_CLEARED	bit	INOUT	Status Is Results Cleared
@HASEXCEPTIONS	bit	INOUT	Has Exceptions
@STARTEDON	datetime	INOUT	Started
@ENDEDON	datetime	INOUT	Ended
@STATUSTEXT	nvarchar(25)	INOUT	Status text
@SERVERNAME	nvarchar(255)	INOUT	Server name
@LASTMESSAGE	nvarchar(max)	INOUT	Last message
@STATUS_IS_AVAILABLE	bit	INOUT	Status is available

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_QUEUEPROCESS_MOSTRECENTSTATUS

@ID uniqueidentifier,
@DATALOADED bit = 0 output,

@STATUSCODE     tinyint = NULL  output
/*
0=Completed
1=Running
2=Did not Finish
3=Results Cleared
*/
,

@STATUS_IS_COMPLETED bit=null output,
@STATUS_IS_RUNNING bit=null output,
@STATUS_IS_DID_NOT_FINISH bit=null output,
@STATUS_IS_RESULTS_CLEARED bit=null output,

@HASEXCEPTIONS bit=null output,

@STARTEDON datetime = null output,

@ENDEDON datetime = null output,

@STATUSTEXT nvarchar(25)= null output,

@SERVERNAME nvarchar(255)=null output,

@LASTMESSAGE nvarchar(max)=null output,

@STATUS_IS_AVAILABLE bit=null output


as

    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    declare @r int;

    exec @r = 
    dbo.USP_QUEUEPROCESS_GET_MOST_RECENT_STATUS
    @QUEUEPROCESSID=@ID,
    @STATUS_AVAILABLE=@DATALOADED output,
    @STATUSCODE     = @STATUSCODE  output
    /*
    0=Completed
    1=Running
    2=Did not Finish
    3=Results Cleared
    */
    ,

    @STATUS_IS_COMPLETED =@STATUS_IS_COMPLETED output,
    @STATUS_IS_RUNNING =@STATUS_IS_RUNNING output,
    @STATUS_IS_DID_NOT_FINISH =@STATUS_IS_DID_NOT_FINISH output,
    @STATUS_IS_RESULTS_CLEARED =@STATUS_IS_RESULTS_CLEARED output,
    @HASEXCEPTIONS =@HASEXCEPTIONS output,
    @STARTEDON = @STARTEDON output,
    @ENDEDON = @ENDEDON output,
    @STATUSTEXT = @STATUSTEXT output,
    @SERVERNAME =@SERVERNAME output,
    @LASTMESSAGE =@LASTMESSAGE output;

SET @STATUS_IS_AVAILABLE=@DATALOADED;

IF @DATALOADED =0
  SELECT @DATALOADED=1 from dbo.QUEUEPROCESS WHERE ID=@ID;

    return @r;