USP_SIMPLEDATALIST_EXPORTDEFINITION

Returns a list of export definitions filtered by record type.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	IN	Record type
@SELECTIONID	uniqueidentifier	IN	Selection

Definition

Copy



CREATE procedure dbo.[USP_SIMPLEDATALIST_EXPORTDEFINITION]
(
  @RECORDTYPEID uniqueidentifier = null,
  @SELECTIONID uniqueidentifier = null
)
as
  set nocount on;

  if @RECORDTYPEID is null and @SELECTIONID is null
    select 
      [ID] as [VALUE],
      [NAME] as [LABEL]
    from dbo.[EXPORTDEFINITION]
    where [ISSYSTEM] = 0
    order by [NAME];
  else
    select 
      [ID] as [VALUE],
      [NAME] as [LABEL]
    from dbo.[EXPORTDEFINITION]
    where (@RECORDTYPEID is null or [RECORDTYPEID] = @RECORDTYPEID)
    and (@SELECTIONID is null or [RECORDTYPEID] = (select [RECORDTYPEID] from dbo.[IDSETREGISTER] where [ID] = @SELECTIONID))
    and [ISSYSTEM] = 0
    order by [NAME];

  return 0;