USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSMARTQUERYINSTANCE_PRELOAD

The load procedure used by the edit dataform template "Export Process From Smart Query Instance Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SMARTQUERYINSTANCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@QUERYNAME	nvarchar(255)	INOUT	Smart query instance
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSMARTQUERYINSTANCE_PRELOAD (
    @SMARTQUERYINSTANCEID uniqueidentifier,
    @QUERYNAME nvarchar(255) = null output,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @SITEID uniqueidentifier = null output)
as
    set nocount on;

    select @QUERYNAME = NAME from dbo.SMARTQUERYINSTANCE where ID = @SMARTQUERYINSTANCEID;

    select 
        @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)

    return 0;