USP_DATALIST_PAGES

Displays the Pages defined in the system.

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	IN	Record type

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PAGES    (@RECORDTYPEID uniqueidentifier = null)
as
    set nocount on;

    select PAGE.ID,
           PAGE.UINAME as [NAME],
           PAGE.DESCRIPTION,
           (select [NAME] from dbo.RECORDTYPE where ID = PAGE.CONTEXTRECORDTYPEID) as 'Record Type',
           coalesce(PAGE.PAGEDEFINITIONSPEC.value('declare namespace bbpage="bb_appfx_pagedefinition";
                                                   /bbpage:PageDefinitionSpec[1]/@IsCustomizable', 'bit'), 1)                      
    from dbo.V_INSTALLED_PAGEDEFINITIONCATALOG as PAGE
    where
        (
            (@RECORDTYPEID is null) or (PAGE.CONTEXTRECORDTYPEID = @RECORDTYPEID)
        )
    order by PAGE.UINAME