USP_DATALIST_MKTDUPLICATEFIELD

Displays a list of all duplicate criteria fields for a record source.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTDUPLICATEFIELD]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTDUPLICATEFIELD].[ID],
    [MKTDUPLICATEFIELD].[SEQUENCE],
    dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([MKTDUPLICATE].[QUERYVIEWCATALOGID], [MKTDUPLICATEFIELD].[FIELDNAME]),
    [MKTDUPLICATEFIELD].[FIELDLENGTH]
  from
    dbo.[MKTDUPLICATEFIELD]
  inner join
    dbo.[MKTDUPLICATE]
  on
    [MKTDUPLICATE].[ID] = [MKTDUPLICATEFIELD].[DUPLICATEID]
  where
    [MKTDUPLICATE].[QUERYVIEWCATALOGID] = @ID
  order by
    [MKTDUPLICATEFIELD].[SEQUENCE];

  return 0;