USP_DATALIST_PAGEEXPRESSIONFORMS

Displays the additional expression forms defined for the given page.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PAGEEXPRESSIONFORMS
(
    @PAGEID uniqueidentifier
)
as
    set nocount on;

    with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
    select 
        INSTANCE.ID,
        INSTANCE.UINAME as NAME,
        TEMPLATE.DESCRIPTION,
        RT.NAME as RECORDTYPE
    from dbo.PAGEDEFINITIONCATALOG as P
        cross apply P.PAGEDEFINITIONSPEC.nodes('tns:PageDefinitionSpec/tns:PageExpressionForms/tns:PageExpressionForm') as page(expressionforms)
        inner join dbo.DATAFORMINSTANCECATALOG as INSTANCE on page.expressionforms.value('@DataFormInstanceID', 'uniqueidentifier') = INSTANCE.ID
        inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
        left join dbo.RECORDTYPE as RT on TEMPLATE.RECORDTYPEID = RT.ID
    where P.ID = @PAGEID