USP_DATALIST_CODETABLEDATAFORMREFERENCES

Displays information about the data forms that use the given code table.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CODETABLEDATAFORMREFERENCES
(
    @CODETABLEID 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_CODETABLE_DATAFORMREFERENCES(@CODETABLEID) 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;