USP_SIMPLEDATALIST_PAGEDEFINITIONS

Returns a list of page definitions for a given record type.

Parameters

Parameter	Parameter Type	Mode	Description
@BASETABLENAME	nvarchar(128)	IN	Base table name

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_PAGEDEFINITIONS
                (
                    @BASETABLENAME nvarchar(128)
                )
                as
                    set nocount on;

                    select
                        V_INSTALLED_PAGEDEFINITIONCATALOG.ID as VALUE,
                        V_INSTALLED_PAGEDEFINITIONCATALOG.UINAME as LABEL
                    from
                        dbo.V_INSTALLED_PAGEDEFINITIONCATALOG
                    where
                        V_INSTALLED_PAGEDEFINITIONCATALOG.CONTEXTRECORDTYPEID = dbo.UFN_RECORDTYPE_GETIDBYBASETABLENAME(@BASETABLENAME)
                    order by
                        V_INSTALLED_PAGEDEFINITIONCATALOG.UINAME;