USP_MKTEXPORTDEFINITIONOUTPUTFIELD_GETADDITIONALINFO

Returns additional information about an output field needed to create the preview datalist spec.

Parameters

Parameter	Parameter Type	Mode
@QUERYVIEWCATALOGID	uniqueidentifier	IN
@QUERYFIELD	nvarchar(255)	IN
@QUERYVIEWNAME	nvarchar(255)	INOUT
@CURRENCYFIELDID	nvarchar(255)	INOUT

Definition

Copy



create procedure dbo.[USP_MKTEXPORTDEFINITIONOUTPUTFIELD_GETADDITIONALINFO]
(
  @QUERYVIEWCATALOGID uniqueidentifier,
  @QUERYFIELD nvarchar(255),
  @QUERYVIEWNAME nvarchar(255) output,
  @CURRENCYFIELDID nvarchar(255) output
)
as
  set nocount on;

  set @QUERYVIEWNAME = '';
  set @CURRENCYFIELDID = '';

  select
    @QUERYVIEWNAME   = [OBJECTNAME],
    @CURRENCYFIELDID = isnull((select T.c.value('(@CurrencyFieldID)[1]', 'nvarchar(255)')
                                from [OUTPUTDEFINITIONXML].nodes(
                                  'declare namespace QV="bb_appfx_queryview";
                                  /QueryViewOutput/QV:OutputFields/QV:OutputField/QV:CurrencyField') as T(c)
                                where T.c.value('(../@Name)[1]', 'nvarchar(255)') = @QUERYFIELD), '')
  from dbo.[QUERYVIEWCATALOG]
  where [ID] = @QUERYVIEWCATALOGID;

  return 0;