USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSELECTION_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SELECTIONID | uniqueidentifier | IN | |
| @SELECTIONNAME | nvarchar(300) | INOUT | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SITEID | uniqueidentifier | INOUT | |
| @RECORDTYPEID | uniqueidentifier | INOUT | |
| @RECORDTYPENAME | nvarchar(50) | INOUT |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_EXPORTPROCESS_FROMSELECTION_PRELOAD]
(
@SELECTIONID uniqueidentifier,
@SELECTIONNAME nvarchar(300) = null output,
@CURRENTAPPUSERID uniqueidentifier = null,
@SITEID uniqueidentifier = null output,
@RECORDTYPEID uniqueidentifier = null output,
@RECORDTYPENAME nvarchar(50) = null output
)
as begin
set nocount on;
select
@SELECTIONNAME = [IDSETREGISTER].[NAME],
@RECORDTYPEID = [IDSETREGISTER].[RECORDTYPEID],
@RECORDTYPENAME = [RECORDTYPE].[NAME]
from dbo.[IDSETREGISTER]
inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [IDSETREGISTER].[RECORDTYPEID]
where [IDSETREGISTER].[ID] = @SELECTIONID;
select @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
return 0;
end