USP_DATAFORMTEMPLATE_VIEW_EXPORTPROCESS

The load procedure used by the view dataform template "Export Process 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.
@QUERYNAME	nvarchar(255)	INOUT	Query name\Export definition
@QUERYTYPE	nvarchar(255)	INOUT	Export type
@NAME	nvarchar(255)	INOUT	Name
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	Business process catalog ID
@PARAMETERSID	uniqueidentifier	INOUT	Parameters ID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EXPORTPROCESS(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @QUERYNAME nvarchar(255) = null output,
    @QUERYTYPE nvarchar(255) = null output,
    @NAME nvarchar(255) = null output,
    @DESCRIPTION nvarchar(1000) = null output,
    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
    @PARAMETERSID uniqueidentifier = null output)
with execute as caller
as
    set nocount on;

    begin try
        set @DATALOADED = 0

        select @DATALOADED = 1,
            @PARAMETERSID = EXPORTPROCESS.ID,
            @QUERYNAME = case when ADHOCQUERY.NAME is null then case when SMARTQUERYINSTANCE.NAME is null then EXPORTDEFINITION.NAME else SMARTQUERYINSTANCE.NAME end else ADHOCQUERY.NAME end,
            @QUERYTYPE = case when ADHOCQUERY.NAME is null then case when SMARTQUERYINSTANCE.NAME is null then 'Export definition' else 'Smart Query Instance' end else 'Ad-hoc Query' end,
            @NAME = EXPORTPROCESS.NAME,
            @DESCRIPTION = EXPORTPROCESS.DESCRIPTION,
            @BUSINESSPROCESSCATALOGID = '64FAA344-9C75-4C98-AFE3-A40EC2DF9249'
        from dbo.EXPORTPROCESS
        left join dbo.ADHOCQUERY on EXPORTPROCESS.ADHOCQUERYID = ADHOCQUERY.ID
        left join dbo.SMARTQUERYINSTANCE on EXPORTPROCESS.SMARTQUERYINSTANCEID = SMARTQUERYINSTANCE.ID
        left join dbo.EXPORTDEFINITION on EXPORTPROCESS.EXPORTDEFINITIONID = EXPORTDEFINITION.ID
        where EXPORTPROCESS.ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch;

    return 0;