USP_DATALIST_MKTLISTLAYOUTLISTFINDERFILES

Displays all the finder files that use a specific layout.

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_MKTLISTLAYOUTLISTFINDERFILES]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  select
    [ID],
    [NAME],
    [STATUS],
    [STATUSCODE],
    [DATEADDED]
  from dbo.[MKTFINDERFILEIMPORTPROCESS]
  where [LISTLAYOUTID] = @ID
  order by [NAME], [DATECHANGED] desc;

  return 0;