USP_DATALIST_SIMPLELISTDATAFORMREFERENCES
Displays information about the data forms that use the given simple data list.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@SIMPLEDATALISTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SIMPLELISTDATAFORMREFERENCES
(
@SIMPLEDATALISTID 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_SIMPLEDATALIST_DATAFORMREFERENCES(@SIMPLEDATALISTID) 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;