USP_PAGEDEFINITION_GETLIST

Returns a list of page definitions based on a given record type.
Parameters

Parameter	Parameter Type	Mode	Description
@FILTERRECORDTYPE	nvarchar(50)	IN
Definition

Copy


            CREATE procedure dbo.USP_PAGEDEFINITION_GETLIST(@FILTERRECORDTYPE nvarchar(50) = '')
            as
                set nocount on;

                with xmlnamespaces('bb_appfx_pagedefinition' as p)
                select 
                    PAGEDEFINITIONCATALOG.ID, 
                    PAGEDEFINITIONCATALOG.NAME, 
                    PAGEDEFINITIONCATALOG.DESCRIPTION, 
                    COALESCE(RECORDTYPE.NAME, '') as 'RECORDTYPE',
                    cast(case PAGEDEFINITIONCATALOG.PAGEDEFINITIONSPEC.value('/p:PageDefinitionSpec[1]/@IsCustomizable','nvarchar(10)')
                            when 'false' then 0
                            when '0' then 0
                            when 'true' then 1
                            when '1' then 1
                            else  1
                        end as bit) as ISCUSTOMIZABLE,
                    PAGEDEFINITIONCATALOG.UINAME
                from 
                    dbo.PAGEDEFINITIONCATALOG
                left outer join dbo.RECORDTYPE on 
                    PAGEDEFINITIONCATALOG.CONTEXTRECORDTYPEID = RECORDTYPE.ID
                where 
                    ((@FILTERRECORDTYPE = '') or (RECORDTYPE.NAME = @FILTERRECORDTYPE))    
                order by
                    PAGEDEFINITIONCATALOG.UINAME;

                return 0;