USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMADHOCQUERY_PRELOAD
The load procedure used by the edit dataform template "Export Process From Ad-hoc Query Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADHOCQUERYID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @QUERYNAME | nvarchar(255) | INOUT | Ad-hoc query |
| @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_FROMADHOCQUERY_PRELOAD(
@ADHOCQUERYID uniqueidentifier,
@QUERYNAME nvarchar(255) = null output,
@CURRENTAPPUSERID uniqueidentifier = null,
@SITEID uniqueidentifier = null output)
as
set nocount on;
select @QUERYNAME = NAME from dbo.ADHOCQUERY where ID = @ADHOCQUERYID;
select
@SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
return 0;