USP_DATALIST_SEARCHLISTDATAFORMREFERENCES

Displays information about the data forms that use the given search list.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SEARCHLISTDATAFORMREFERENCES
(
    @SEARCHLISTID uniqueidentifier
)
as
    set nocount on;

    select distinct
        INSTANCE.ID,
        INSTANCE.UINAME as NAME,
        TEMPLATE.DESCRIPTION,
        RT.NAME as RECORDTYPE
    from dbo.DATAFORMINSTANCECATALOG as INSTANCE
        inner join dbo.UFN_SEARCHLIST_DATAFORMREFERENCES(@SEARCHLISTID) as T on INSTANCE.ID = T.DATAFORMINSTANCEID
        inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
        left join dbo.RECORDTYPE as RT on TEMPLATE.RECORDTYPEID = RT.ID
    order by INSTANCE.UINAME;