USP_DATALIST_MKTLISTLAYOUTFIELDS

Displays a list of fields for a given layout.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTLISTLAYOUTFIELDS]
(
  @ID uniqueidentifier,
  @MAPPINGCODE tinyint = null
)
as
  set nocount on;

  select
    [ID],
    [FIELDNAME],
    [OBJECTNAME],
    [SOURCENAME],
    [FRIENDLYNAME],
    [MAPPINGCODE],
    [DATATYPE],
    [ISIDFIELD],
    [IDTYPECODE],
    [ALTERNATELOOKUPIDTYPECODEID]
  from dbo.[MKTLISTLAYOUTFIELD]
  where [LISTLAYOUTID] = @ID
  and (@MAPPINGCODE is null or [MAPPINGCODE] = @MAPPINGCODE) 
  order by [SEQUENCE];

  return 0;