UFN_MKTRECORDSOURCE_GETFIELDDISPLAYNAME

Returns the display name for a given field in a given record source.

Return

Return Type
nvarchar(4000)

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDSOURCEID	uniqueidentifier	IN
@FIELDNAME	nvarchar(128)	IN

Definition

Copy



create function [dbo].[UFN_MKTRECORDSOURCE_GETFIELDDISPLAYNAME]
(
  @RECORDSOURCEID uniqueidentifier,
  @FIELDNAME sysname
)
returns nvarchar(4000)
as begin
  declare @ret nvarchar(4000);

  select
    @ret=(select isnull(T.c.value('(@Caption)[1]','nvarchar(255)'), T.c.value('(@Name)[1]','nvarchar(255)')) 
          from [QUERYVIEWCATALOG].OUTPUTDEFINITIONXML.nodes('declare namespace QV="bb_appfx_queryview";/QueryViewOutput/QV:OutputFields/QV:OutputField') T(c)
          where T.c.value('(@Name)[1]','nvarchar(255)')=@FIELDNAME) 
  from dbo.[QUERYVIEWCATALOG]
  where [QUERYVIEWCATALOG].[ID]=@RECORDSOURCEID;

  return @ret;
end;