USP_MKTEXPORTDEFINITIONOUTPUTFIELD_SAVE

Saves an export definition output field.

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN
@NAME	nvarchar(255)	IN
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@CUSTOMQUERYVIEWCATALOGID	uniqueidentifier	IN
@QUERYFIELD	nvarchar(255)	IN
@TYPECODE	tinyint	IN
@SEQUENCE	int	IN
@VIEWPATH	nvarchar(4000)	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTEXPORTDEFINITIONOUTPUTFIELD_SAVE]
(
  @CHANGEAGENTID uniqueidentifier = null,    
  @EXPORTDEFINITIONID uniqueidentifier,
  @NAME nvarchar(255),
  @QUERYVIEWCATALOGID uniqueidentifier,
  @CUSTOMQUERYVIEWCATALOGID uniqueidentifier,
  @QUERYFIELD nvarchar(255),
  @TYPECODE tinyint,
  @SEQUENCE int,
  @VIEWPATH nvarchar(4000)
)
as
  set nocount on;

  declare @ID uniqueidentifier;
  declare @CURRENTDATE datetime;

  begin try
    set @ID = NewID();

    if @CHANGEAGENTID is null
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    set @CURRENTDATE = GetDate();

    /* Save the output field */
    insert into dbo.[MKTEXPORTDEFINITIONOUTPUTFIELD] (
      [ID],
      [EXPORTDEFINITIONID],
      [NAME],
      [QUERYVIEWCATALOGID],
      [CUSTOMQUERYVIEWCATALOGID],
      [QUERYFIELD],
      [TYPECODE],
      [SEQUENCE],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED],
      [VIEWPATH]
    ) values (
      @ID,
      @EXPORTDEFINITIONID,
      @NAME,
      case when @QUERYVIEWCATALOGID = 'B453E917-6B30-4B7C-B83A-E3444B18A318' and (@QUERYFIELD = 'RECEIPTNUMBER' or @QUERYFIELD = 'RECEIPTDATE' or @QUERYFIELD = 'LETTER')
           then 'D67B643B-F31A-4A6A-88DD-5992DD670D26'
           else @QUERYVIEWCATALOGID end,
      @CUSTOMQUERYVIEWCATALOGID,
      @QUERYFIELD,
      @TYPECODE,
      @SEQUENCE,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE,
      @VIEWPATH
    );
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

return 0;