V_QUERY_PAGEACTIONS

Provides support for querying on page actions.

Fields

Field	Field Type	Null	Description
PAGEID	uniqueidentifier		Page ID
ID	uniqueidentifier	yes	ID
CAPTION	nvarchar(max)	yes	Caption
SHOWCAPTIONONTOOLBAR	bit	yes	Show caption on toolbar
IMAGEKEY	nvarchar(max)	yes	Image key
TOOLTIPTEXT	nvarchar(max)	yes	Tool tip text
DEFAULTACTION	nvarchar(max)	yes	Default action
VISIBLE	nvarchar(max)	yes	Visible
ENABLED	nvarchar(max)	yes	Enabled
APPENDSEPARATOR	nvarchar(max)	yes	Append separator
LINKFIELDID	nvarchar(max)	yes	Link field ID
CAPTIONRESOURCEKEY	nvarchar(max)	yes	Caption resource key
TOOLTIPRESOURCEKEY	nvarchar(max)	yes	Tool tip resource key
HELPKEY	nvarchar(max)	yes	Help key
ACTIONTYPE	varchar(29)	yes	Action type
ACTIONCONTEXTTYPE	varchar(24)		Context type
PAGEEXPRESSIONFIELDID	nvarchar(max)	yes	Page expression field
SECTIONFIELDID	nvarchar(max)	yes	Section field
EXPRESSION	nvarchar(max)	yes	Expression
SEARCHLISTID	uniqueidentifier	yes	Search list record
SEARCHLISTNAME	nvarchar(60)	yes	Search list name
POSTACTIONEVENTTYPE	varchar(22)		Post action event type
POSTACTIONFUNCTIONALAREANAME	nvarchar(100)	yes	Functional area name
POSTACTIONSPECIFICPAGEID	uniqueidentifier	yes	Specific page record
POSTACTIONSPECIFICPAGENAME	nvarchar(60)	yes	Specific page name
POSTACTIONCUSTOMSECTIONMETHOD	nvarchar(max)	yes	Custom section method
CLRACTIONASSEMBLYNAME	nvarchar(max)	yes	Assembly name
CLRACTIONCLASSNAME	nvarchar(max)	yes	Class name
SCRIPTIDENTIFIERURL	nvarchar(max)	yes	Script identifier Url
SCRIPTIDENTIFIEROBJECTNAME	nvarchar(max)	yes	Script identifier object name
CUSTOMSECTIONMETHOD	nvarchar(max)	yes	Custom section method
RECORDOPERATIONID	uniqueidentifier	yes	Record operation record
RECORDOPERATIONNAME	nvarchar(60)	yes	Record operation name
RECORDOPERATIONSHOWPROMPT	int	yes	Show prompt
ADDDATAFORMID	uniqueidentifier	yes	Data form record
ADDDATAFORMNAME	nvarchar(60)	yes	Data form name
DATAFORMID	uniqueidentifier	yes	Data form record
DATAFORMNAME	nvarchar(60)	yes	Data form name
SHOWPAGEID	uniqueidentifier	yes	Page record
SHOWPAGENAME	nvarchar(60)	yes	Page name
REPORTID	uniqueidentifier	yes	Report record
REPORTNAME	nvarchar(100)	yes	Report name
REPORTACTIONCAPTION	nvarchar(max)	yes	Caption
SHOWINNEWWINDOW	int	yes	Show in new window
DISPLAYPROMPTAREA	int	yes	Display prompt area
DISPLAYDOCUMENTMAP	int	yes	Display document map
DISPLAYTOOLBAR	int	yes	Display toolbar
EXPORTTYPE	nvarchar(5)	yes	Export type
REPORTACTIONCAPTIONRESOURCEKEY	nvarchar(max)	yes	Caption resource key
BUSINESSPROCESSID	uniqueidentifier	yes	Business process record
BUSINESSPROCESSNAME	nvarchar(60)	yes	Business process name
BUSINESSPROCESSSTATUSPAGEID	uniqueidentifier	yes	Business process status page record
BUSINESSPROCESSSTATUSPAGENAME	nvarchar(60)	yes	Business process status page name
BUSINESSPROCESSPREPROCESSEDITFORMID	uniqueidentifier	yes	Business process preprocess edit form record
BUSINESSPROCESSPREPROCESSEDITFORMNAME	nvarchar(60)	yes	Business process preprocess edit form name
ACTIONCONTAINER	varchar(17)
SECTIONMODELACTION	nvarchar(max)	yes
BROWSEQUERYRESULTSPAGEID	uniqueidentifier	yes
BROWSEQUERYRESULTSPAGENAME	nvarchar(60)	yes
BROWSEQUERYRESULTSQUERYTYPE	varchar(20)	yes
BROWSEQUERYRESULTSQUERYNAME	nvarchar(255)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:30:55 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PAGEACTIONS AS



with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
select 
    P.ID as PAGEID,
    page.action.value('@ID', 'uniqueidentifier') as ID,
    page.action.value('@Caption', 'nvarchar(max)') as CAPTION,
    coalesce(page.action.value('@ShowCaptionOnToolbar', 'bit'), '1') as SHOWCAPTIONONTOOLBAR,
    page.action.value('@ImageKey', 'nvarchar(max)') as IMAGEKEY,
    page.action.value('@ToolTipText', 'nvarchar(max)') as TOOLTIPTEXT,
    coalesce(page.action.value('@DefaultAction', 'nvarchar(max)'), 'False') as DEFAULTACTION,
    coalesce(page.action.value('@Visible', 'nvarchar(max)'), 'True') as VISIBLE,
    coalesce(page.action.value('@Enabled', 'nvarchar(max)'), 'True') as ENABLED,
    coalesce(page.action.value('@AppendSeparator', 'nvarchar(max)'), 'False') as APPENDSEPARATOR,
    page.action.value('@LinkFieldID', 'nvarchar(max)') as LINKFIELDID,
    page.action.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
    page.action.value('@ToolTipResourceKey', 'nvarchar(max)') as TOOLTIPRESOURCEKEY,
    page.action.value('(tns:HelpKey)[1]', 'nvarchar(max)') as HELPKEY,
    case 
        when page.action.exist('common:ExecuteCLRAction') = 1 then 'Execute CLR action'
        when page.action.exist('common:ExecuteCustomSectionMethod') = 1 then 'Execute custom section method'
        when page.action.exist('common:InvokeSectionModelAction') = 1 then 'Invoke section model action'
        when page.action.exist('common:ExecuteRecordOperation') = 1 then 'Execute record operation'
        when page.action.exist('common:ShowAddDataForm') = 1 then 'Show add data form'
        when page.action.exist('common:ShowDataForm') = 1 then 'Show data form'
        when page.action.exist('common:ShowPage') = 1 then 'Show page'
        when page.action.exist('common:ShowReport') = 1 then 'Show report'
        when page.action.exist('common:StartBusinessProcess') = 1 then 'Start business process'
        when page.action.exist('common:BrowseQueryResults') = 1 then 'Browse query results'
        when page.action.exist('tns:ActionGroup') = 1 then 'Action group'
    end as ACTIONTYPE,

    case 
        when page.action.exist('*/common:ActionContext/common:PageContextID') = 1 then 'Page context'
        when page.action.exist('*/common:ActionContext/common:PageExpressionField') = 1 then 'Page expression field'
        when page.action.exist('*/common:ActionContext/common:SectionField') = 1 then 'Section field'
        when page.action.exist('*/common:ActionContext/common:Expression') = 1 then 'Expression'
        when page.action.exist('*/common:ActionContext/common:SearchListReturnValue') = 1 then 'Search list return value'
        else 'None'
    end as ACTIONCONTEXTTYPE,
    page.action.value('(*/common:ActionContext/common:PageExpressionField)[1]', 'nvarchar(max)') as PAGEEXPRESSIONFIELDID,
    page.action.value('(*/common:ActionContext/common:SectionField)[1]', 'nvarchar(max)') as SECTIONFIELDID,
    page.action.value('(*/common:ActionContext/common:Expression)[1]', 'nvarchar(max)') as EXPRESSION,
    page.action.value('(*/common:ActionContext/common:SearchListReturnValue/@SearchListID)[1]', 'uniqueidentifier') AS SEARCHLISTID,
    (select S.NAME
     from dbo.SEARCHLISTCATALOG as S
     where S.ID = page.action.value('(*/common:ActionContext/common:SearchListReturnValue/@SearchListID)[1]', 'uniqueidentifier'))
    as SEARCHLISTNAME,

    case 
        when page.action.exist('*/common:PostActionEvent/common:GoToPage/common:FunctionalArea') = 1 then 'Go to functional area'
        when page.action.exist('*/common:PostActionEvent/common:GoToPage/common:Home') = 1 then 'Go home'
        when page.action.exist('*/common:PostActionEvent/common:GoToPage/common:PreviousPage') = 1 then 'Go to previous page'
        when page.action.exist('*/common:PostActionEvent/common:GoToPage/common:SpecificPage') = 1 then 'Go to specific page'
        when page.action.exist('*/common:PostActionEvent/common:RefreshPage') = 1 then 'Refresh page'
        when page.action.exist('*/common:PostActionEvent/common:RefreshSection') = 1 then 'Refresh section'
        when page.action.exist('*/common:PostActionEvent/common:CustomSectionMethod') = 1 then 'Custom section method'
        when page.action.exist('*/common:PostActionEvent/common:RefreshOtherSections') = 1 then 'Refresh other sections'
        else 'None'
    end as POSTACTIONEVENTTYPE,
    (select F.NAME
     from dbo.FUNCTIONALAREACATALOG as F
     where F.ID = page.action.value('(*/common:PostActionEvent/common:GoToPage/common:FunctionalArea/@FunctionalAreaID)[1]', 'uniqueidentifier'))
    as POSTACTIONFUNCTIONALAREANAME,
    page.action.value('(*/common:PostActionEvent/common:GoToPage/common:SpecificPage/@PageID)[1]', 'uniqueidentifier') as POSTACTIONSPECIFICPAGEID,
    (select P.NAME
     from dbo.PAGEDEFINITIONCATALOG as P
     where P.ID = page.action.value('(*/common:PostActionEvent/common:GoToPage/common:SpecificPage/@PageID)[1]', 'uniqueidentifier'))
    as POSTACTIONSPECIFICPAGENAME,
    page.action.value('(*/common:PostActionEvent/common:CustomSectionMethod/@Method)[1]', 'nvarchar(max)') as POSTACTIONCUSTOMSECTIONMETHOD,

    page.action.value('(common:ExecuteCLRAction/common:ComponentIdentifier/@AssemblyName)[1]', 'nvarchar(max)') as CLRACTIONASSEMBLYNAME,
    page.action.value('(common:ExecuteCLRAction/common:ComponentIdentifier/@ClassName)[1]', 'nvarchar(max)') as CLRACTIONCLASSNAME,    
    page.action.value('(common:ExecuteCLRAction/common:ScriptIdentifier/@Url)[1]', 'nvarchar(max)') as SCRIPTIDENTIFIERURL,    
    page.action.value('(common:ExecuteCLRAction/common:ScriptIdentifier/@ObjectName)[1]', 'nvarchar(max)') as SCRIPTIDENTIFIEROBJECTNAME,

    page.action.value('(common:ExecuteCustomSectionMethod/@Method)[1]', 'nvarchar(max)') as CUSTOMSECTIONMETHOD,

    page.action.value('(common:ExecuteRecordOperation/@RecordOperationID)[1]', 'uniqueidentifier') AS RECORDOPERATIONID,
    (select R.DISPLAYNAME
     from dbo.RECORDOPERATIONCATALOG as R
     where R.ID = page.action.value('(common:ExecuteRecordOperation/@RecordOperationID)[1]', 'uniqueidentifier'))
    as RECORDOPERATIONNAME,
    coalesce(page.action.value('(common:ExecuteRecordOperation/@ShowPrompt)[1]', 'bit'), 1) AS RECORDOPERATIONSHOWPROMPT,

    page.action.value('(common:ShowAddDataForm/@DataFormID)[1]', 'uniqueidentifier') AS ADDDATAFORMID,
    (select INSTANCE.FORMNAME 
     from dbo.DATAFORMINSTANCECATALOG as INSTANCE
     where INSTANCE.ID = page.action.value('(common:ShowAddDataForm/@DataFormID)[1]', 'uniqueidentifier'))
    as ADDDATAFORMNAME,

    page.action.value('(common:ShowDataForm/@DataFormID)[1]', 'uniqueidentifier') AS DATAFORMID,
    (select INSTANCE.FORMNAME 
     from dbo.DATAFORMINSTANCECATALOG as INSTANCE
     where INSTANCE.ID = page.action.value('(common:ShowDataForm/@DataFormID)[1]', 'uniqueidentifier'))
    as DATAFORMNAME,

    page.action.value('(common:ShowPage/@PageID)[1]', 'uniqueidentifier') AS SHOWPAGEID,
    (select P.NAME
     from dbo.PAGEDEFINITIONCATALOG as P
     where P.ID = page.action.value('(common:ShowPage/@PageID)[1]', 'uniqueidentifier'))
    as SHOWPAGENAME,

    page.action.value('(common:ShowReport/@ReportID)[1]', 'uniqueidentifier') AS REPORTID,
    (select R.NAME
     from dbo.REPORTCATALOG as R
     where R.ID = page.action.value('(common:ShowReport/@ReportID)[1]', 'uniqueidentifier'))
    as REPORTNAME,
    page.action.value('(common:ShowReport/@Caption)[1]', 'nvarchar(max)') AS REPORTACTIONCAPTION,
    coalesce(page.action.value('(common:ShowReport/@ShowInNewWindow)[1]', 'bit'), 0) AS SHOWINNEWWINDOW,
    coalesce(page.action.value('(common:ShowReport/@DisplayPromptArea)[1]', 'bit'), 0) AS DISPLAYPROMPTAREA,
    coalesce(page.action.value('(common:ShowReport/@DisplayDocumentMap)[1]', 'bit'), 0) AS DISPLAYDOCUMENTMAP,
    coalesce(page.action.value('(common:ShowReport/@DisplayToolbar)[1]', 'bit'), 1) AS DISPLAYTOOLBAR,
    coalesce(page.action.value('(common:ShowReport/@ExportType)[1]', 'nvarchar(5)'), 'none') AS EXPORTTYPE,
    page.action.value('(common:ShowReport/@CaptionResourceKey)[1]', 'nvarchar(max)') AS REPORTACTIONCAPTIONRESOURCEKEY,

    page.action.value('(common:StartBusinessProcess/@BusinessProcessID)[1]', 'uniqueidentifier') AS BUSINESSPROCESSID,
    (select B.NAME
     from dbo.BUSINESSPROCESSCATALOG as B
     where B.ID = page.action.value('(common:StartBusinessProcess/@BusinessProcessID)[1]', 'uniqueidentifier'))
    as BUSINESSPROCESSNAME,
    page.action.value('(common:StartBusinessProcess/@StatusPageID)[1]', 'uniqueidentifier') AS BUSINESSPROCESSSTATUSPAGEID,
    (select P.NAME
     from dbo.PAGEDEFINITIONCATALOG as P
     where P.ID = page.action.value('(common:StartBusinessProcess/@StatusPageID)[1]', 'uniqueidentifier'))
    as BUSINESSPROCESSSTATUSPAGENAME,
    page.action.value('(common:StartBusinessProcess/@PreprocessEditFormID)[1]', 'uniqueidentifier') AS BUSINESSPROCESSPREPROCESSEDITFORMID,
    (select INSTANCE.FORMNAME
     from dbo.DATAFORMINSTANCECATALOG as INSTANCE
     where INSTANCE.ID = page.action.value('(common:StartBusinessProcess/@PreprocessEditFormID)[1]', 'uniqueidentifier'))
    as BUSINESSPROCESSPREPROCESSEDITFORMNAME,

    case page.action.value('local-name(../..)', 'nvarchar(max)')
        when 'ActionGroup' then 'Action group'
        when 'PageActionGroup' then 'Page action group'
        when 'Section' then 'Section'
        when 'SummarySection' then 'Summary section'
        else 'Unknown'
    end as ACTIONCONTAINER,

    page.action.value('(common:InvokeSectionModelAction/@ActionName)[1]', 'nvarchar(max)') as SECTIONMODELACTION,

    page.action.value('(common:BrowseQueryResults/@PageID)[1]', 'uniqueidentifier') AS BROWSEQUERYRESULTSPAGEID,
    (select PDC.NAME
     from dbo.PAGEDEFINITIONCATALOG as PDC
     where PDC.ID = page.action.value('(common:BrowseQueryResults/@PageID)[1]', 'uniqueidentifier'))
    as BROWSEQUERYRESULTSPAGENAME,
    case coalesce(page.action.value('(common:BrowseQueryResults/@QueryType)[1]', 'nvarchar(20)'), 'AdhocQuery') 
        when 'AdhocQuery' then 'Ad-hoc query'
        when 'SmartQueryInstance' then 'Smart query instance'
    end as BROWSEQUERYRESULTSQUERYTYPE,
    case coalesce(page.action.value('(common:BrowseQueryResults/@QueryType)[1]', 'nvarchar(20)'), 'AdhocQuery')
        when 'AdhocQuery' then
            (select Q.DISPLAYNAME from dbo.QUERYVIEWCATALOG as Q where Q.ID = page.action.value('(common:BrowseQueryResults/@QueryID)[1]', 'uniqueidentifier'))
        when 'SmartQueryInstance' then
            (select Q.NAME from dbo.SMARTQUERYINSTANCE as Q where Q.ID = page.action.value('(common:BrowseQueryResults/@QueryID)[1]', 'uniqueidentifier'))
    end as BROWSEQUERYRESULTSQUERYNAME

/*#EXTENSION*/

from dbo.PAGEDEFINITIONCATALOG as P
  cross apply P.PAGEDEFINITIONSPEC.nodes('//tns:Action') as page(action)