USP_DATAFORMTEMPLATE_ADD_BUSINESSPROCESSEXPORTGROUPS_2

The save procedure used by the add dataform template "Business Process Export Group Files Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSEXPORTCONTEXT	nvarchar(4000)	IN	Input parameter indicating the context ID for the record being added.
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@OUTPUTPATH	nvarchar(2047)	IN	Output path
@COLUMNNAME	nvarchar(255)	IN	Group by
@GROUPS	nvarchar(max)	IN	Groups
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EXPORTFORMAT	nvarchar(5)	IN	Export format
@TABLEKEY	nvarchar(50)	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_BUSINESSPROCESSEXPORTGROUPS_2]
(
  @BUSINESSPROCESSEXPORTCONTEXT nvarchar(4000),
  @ID uniqueidentifier = null output,
  @OUTPUTPATH nvarchar(2047) = null,
  @COLUMNNAME nvarchar(255) = null,
  @GROUPS nvarchar(max) = null,
  @CHANGEAGENTID uniqueidentifier = null,
  @EXPORTFORMAT nvarchar(5) = 'csv',
  @TABLEKEY nvarchar(50) = ''
)
as
  set nocount on;

  declare @BUSINESSPROCESSSTATUSID uniqueidentifier;
  set @BUSINESSPROCESSSTATUSID = convert(uniqueidentifier, @BUSINESSPROCESSEXPORTCONTEXT);

  -- WI37358

  -- the XML describing the groups is now stored in the database, since it can be too long to be passed to CustomFileDownload.ashx as a query string parameter


  update dbo.[BUSINESSPROCESSOUTPUT] set [DOWNLOADPARAMETERS] = isnull(@GROUPS, '') where [BUSINESSPROCESSSTATUSID] = @BUSINESSPROCESSSTATUSID and [TABLEKEY] = @TABLEKEY;

  -- set the return ID so the platform thinks everything worked

  set @ID = newid();

  return 0;