V_QUERY_PAGESECTIONS
Provides support for querying on page sections.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PAGEID | uniqueidentifier | Page ID | |
| ID | uniqueidentifier | yes | ID |
| CAPTION | nvarchar(max) | yes | Caption |
| VISIBLE | nvarchar(max) | yes | Visible |
| HIDECAPTION | nvarchar(max) | yes | Hide caption |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | Caption resource key |
| HELPKEY | nvarchar(max) | yes | Help key |
| SECTIONTYPE | varchar(16) | yes | Section type |
| SECTIONCONTEXTTYPE | varchar(21) | Context type | |
| PAGEEXPRESSIONFIELDID | nvarchar(max) | yes | Page expression field |
| EXPRESSION | nvarchar(max) | yes | Expression |
| SECTIONDATALISTID | uniqueidentifier | yes | Data list record |
| SECTIONDATALISTNAME | nvarchar(60) | yes | Data list name |
| DATALISTSHOWBORDER | int | yes | Show border |
| AUTOLOADLIST | int | yes | Auto-load list |
| AUTODISPLAYFILTERS | int | yes | Auto display filters |
| SHOWROWTOTALS | nvarchar(max) | yes | Show row totals |
| ALLOWSORT | nvarchar(max) | yes | Allow sort |
| DATALISTRENDERSTYLE | varchar(10) | yes | Render style |
| DATALISTAUTOSIZE | int | yes | Auto size |
| DEFAULTSORTORDER | nvarchar(10) | yes | Default sort order |
| DETAILFORMDEFINITION | nvarchar(max) | yes | Detail form definition |
| DETAILFORMID | varchar(40) | yes | Detail form record |
| DETAILFORMNAME | nvarchar(60) | yes | Detail form name |
| DETAILFORMDOCKSTYLE | nvarchar(50) | yes | |
| LEGENDDEFINED | bit | yes | Legend defined |
| EXPANDFIRSTLEVELNODES | int | yes | Expand first level nodes |
| EXPANDALLONLOAD | int | yes | Expand all on load |
| SECTIONDATAFORMID | uniqueidentifier | yes | Data form record |
| SECTIONDATAFORMNAME | nvarchar(60) | yes | Data form name |
| DATAFORMSHOWBORDER | int | yes | Show border |
| DATAFORMSECTIONISSCROLLABLE | int | yes | Is scrollable |
| SECTIONREPORTID | uniqueidentifier | yes | Report record |
| SECTIONREPORTNAME | nvarchar(100) | yes | Report name |
| DISPLAYPROMPTAREA | int | yes | Display prompt area |
| DISPLAYDOCUMENTMAP | int | yes | Display document map |
| DISPLAYTOOLBAR | int | yes | Display toolbar |
| HISTORYID | nvarchar(max) | yes | History ID |
| CUSTOMCOMPONENTSECTIONASSEMBLYNAME | nvarchar(max) | yes | Assembly name |
| CUSTOMCOMPONENTSECTIONCLASSNAME | nvarchar(max) | yes | Class name |
| CUSTOMCOMPONENTSHOWBORDER | int | yes | Show border |
| CUSTOMCOMPONENTSECTIONISSCROLLABLE | int | yes | Is scrollable |
| SECTIONDASHBOARDID | uniqueidentifier | yes | Dashboard record |
| SECTIONDASHBOARDNAME | nvarchar(60) | yes | Dashboard name |
| DASHBOARDSECTIONISSCROLLABLE | int | yes | Is scrollable |
| SECTIONCALENDARID | uniqueidentifier | yes | Calendar record |
| SECTIONCALENDARNAME | nvarchar(100) | yes | Calendar name |
| SECTIONRELATIONSHIPMAPID | uniqueidentifier | yes | Relationship map record |
| SECTIONRELATIONSHIPMAPNAME | nvarchar(100) | yes | Relationship map name |
| DISPLAYSTYLE | nvarchar(max) | yes | |
| COLLAPSIBLE | int | yes | |
| COLLAPSED | int | yes | |
| HIDEFILTERS | nvarchar(max) | yes | |
| ITEMSPERPAGE | int | yes | |
| DATALISTPARAMETERSECTIONID | uniqueidentifier | yes | |
| DATALISTHIDEOWNFILTERS | int | yes | |
| AUTOLOAD | int | yes | |
| SECTIONCALENDARDEFAULTDATE | date | yes | |
| SECTIONUIWIDGETID | uniqueidentifier | yes | |
| SECTIONUIWIDGETNAME | nvarchar(100) | yes | |
| UIWIDGETSHOWBORDER | int | yes | |
| UIWIDGETAUTOHEIGHT | int | yes | |
| UIWIDGETPARAMETERSECTIONID | uniqueidentifier | yes | |
| UIWIDGETHIDEOWNFILTERS | int | yes | |
| WEBPAGESECTIONURL | nvarchar(max) | yes | |
| WEBPAGESECTIONISSCROLLABLE | int | yes | |
| WEBPAGESECTIONALLOWNAVIGATION | int | yes | |
| WEBPAGESECTIONALLOWWEBBROWSERDROP | int | yes | |
| WEBPAGESECTIONISWEBBROWSERCONTEXTMENUENABLED | int | yes | |
| WEBPAGESECTIONSCRIPTERRORSSUPPRESSED | int | yes | |
| WEBPAGESECTIONSCROLLBARSENABLED | int | yes | |
| WEBPAGESECTIONWEBBROWSERSHORTCUTSENABLED | int | yes | |
| WEBPAGESECTIONUSEHTTPGETANDLOADMANUALLY | int | yes | |
| WEBPAGESECTIONPROVIDECREDENTIALSFROMLOGIN | int | yes | |
| CUSTOMUIMODELSECTIONASSEMBLYNAME | nvarchar(max) | yes | |
| CUSTOMUIMODELSECTIONCLASSNAME | nvarchar(max) | yes | |
| CUSTOMUIMODELSHOWBORDER | int | yes | |
| CUSTOMUIMODELSECTIONISSCROLLABLE | int | yes | |
| LISTBUILDERSECTIONQUERYVIEWID | uniqueidentifier | yes | |
| LISTBUILDERSECTIONQUERYVIEWNAME | nvarchar(255) | yes | |
| LISTBUILDERSECTIONAUTODISPLAYFILTERS | int | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:56 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PAGESECTIONS AS
with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
select
P.ID as PAGEID,
page.section.value('@ID', 'uniqueidentifier') as ID,
page.section.value('@Caption', 'nvarchar(max)') as CAPTION,
coalesce(page.section.value('@Visible', 'nvarchar(max)'), 'True') as VISIBLE,
coalesce(page.section.value('@HideCaption', 'nvarchar(max)'), 'False') as HIDECAPTION,
page.section.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
page.section.value('(tns:HelpKey)[1]', 'nvarchar(max)') as HELPKEY,
case
when page.section.exist('tns:DataForm') = 1 then 'Data form'
when page.section.exist('tns:DataList') = 1 then 'Data list'
when page.section.exist('tns:Report') = 1 then 'Report'
when page.section.exist('tns:CustomComponent') = 1 then 'Custom component'
when page.section.exist('tns:Dashboard') = 1 then 'Dashboard'
when page.section.exist('tns:Calendar') = 1 then 'Calendar'
when page.section.exist('tns:RelationshipMap') = 1 then 'Relationship map'
when page.section.exist('tns:UIWidget') = 1 then 'UI widget'
when page.section.exist('tns:WebPage') = 1 then 'Web page'
when page.section.exist('tns:CustomUIModel') = 1 then 'Custom UI model'
when page.section.exist('tns:ListBuilder') = 1 then 'List builder'
end as SECTIONTYPE,
case
when page.section.exist('common:SectionContext/common:PageExpressionField') = 1 then 'Page expression field'
when page.section.exist('common:SectionContext/common:Expression') = 1 then 'Expression'
else 'Page context'
end as SECTIONCONTEXTTYPE,
page.section.value('(common:SectionContext/common:PageExpressionField)[1]', 'nvarchar(max)') as PAGEEXPRESSIONFIELDID,
page.section.value('(common:SectionContext/common:Expression)[1]', 'nvarchar(max)') as EXPRESSION,
page.section.value('(tns:DataList/@ID)[1]', 'uniqueidentifier') AS SECTIONDATALISTID,
(select D.UINAME
from dbo.DATALISTCATALOG as D
where D.ID = page.section.value('(tns:DataList/@ID)[1]', 'uniqueidentifier'))
as SECTIONDATALISTNAME,
coalesce(page.section.value('(tns:DataList/@ShowBorder)[1]', 'bit'), 0) AS DATALISTSHOWBORDER,
coalesce(page.section.value('(tns:DataList/@AutoLoadList)[1]', 'bit'), 1) AS AUTOLOADLIST,
coalesce(page.section.value('(tns:DataList/@AutoDisplayFilters)[1]', 'bit'), 0) AS AUTODISPLAYFILTERS,
coalesce(page.section.value('(tns:DataList/@ShowRowTotals)[1]', 'nvarchar(max)'), 'True') AS SHOWROWTOTALS,
coalesce(page.section.value('(tns:DataList/@AllowSort)[1]', 'nvarchar(max)'), 'True') AS ALLOWSORT,
case
when page.section.exist('tns:DataList/tns:RenderStyle/tns:StandardView') = 1 then 'Standard'
when page.section.exist('tns:DataList/tns:RenderStyle/tns:GroupedView') = 1 then 'Grouped'
when page.section.exist('tns:DataList/tns:RenderStyle/tns:RepeaterView') = 1 then 'Repeater'
when page.section.exist('tns:DataList/tns:RenderStyle/tns:RelationalView') = 1 then 'Relational'
end as DATALISTRENDERSTYLE,
case
when page.section.exist('tns:DataList/tns:RenderStyle/tns:StandardView') = 1 then
coalesce(page.section.value('(tns:DataList/tns:RenderStyle/tns:StandardView/@AutoSize)[1]', 'bit'), 0)
when page.section.exist('tns:DataList/tns:RenderStyle/tns:RelationalView') = 1 then
coalesce(page.section.value('(tns:DataList/tns:RenderStyle/tns:RelationalView/@AutoSize)[1]', 'bit'), 0)
end as DATALISTAUTOSIZE,
case when page.section.exist('tns:DataList/tns:RenderStyle/tns:GroupedView') = 1 then
coalesce(page.section.value('(tns:DataList/tns:RenderStyle/tns:GroupedView/@DefaultSortOrder)[1]', 'nvarchar(10)'), 'Ascending')
end as DEFAULTSORTORDER,
page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@ViewDataFormID)[1]', 'nvarchar(max)') as DETAILFORMDEFINITION,
case
when left(ltrim(page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@ViewDataFormID)[1]', 'nvarchar(max)')), 1) = '=' then null
else ltrim(page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@ViewDataFormID)[1]', 'uniqueidentifier'))
end as DETAILFORMID,
(select INSTANCE.UINAME
from dbo.DATAFORMINSTANCECATALOG as INSTANCE
where
left(ltrim(page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@ViewDataFormID)[1]', 'nvarchar(max)')), 1) <> '=' and
INSTANCE.ID = ltrim(page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@ViewDataFormID)[1]', 'uniqueidentifier')))
as DETAILFORMNAME,
page.section.value('(tns:DataList/tns:RenderStyle/*/tns:DetailViewForm/@DockStyle)[1]', 'nvarchar(50)') as DETAILFORMDOCKSTYLE,
page.section.exist('tns:DataList/tns:RenderStyle/*/tns:Legend') as LEGENDDEFINED,
coalesce(page.section.value('(tns:DataList/@ExpandFirstLevelNodes)[1]', 'bit'), 1) AS EXPANDFIRSTLEVELNODES,
coalesce(page.section.value('(tns:DataList/@ExpandAllOnLoad)[1]', 'bit'), 0) AS EXPANDALLONLOAD,
page.section.value('(tns:DataForm/@ID)[1]', 'uniqueidentifier') AS SECTIONDATAFORMID,
(select INSTANCE.UINAME
from dbo.DATAFORMINSTANCECATALOG as INSTANCE
where INSTANCE.ID = page.section.value('(tns:DataForm/@ID)[1]', 'uniqueidentifier'))
as SECTIONDATAFORMNAME,
coalesce(page.section.value('(tns:DataForm/@ShowBorder)[1]', 'bit'), 0) AS DATAFORMSHOWBORDER,
coalesce(page.section.value('(tns:DataForm/@IsScrollable)[1]', 'bit'), 0) AS DATAFORMSECTIONISSCROLLABLE,
page.section.value('(tns:Report/@ID)[1]', 'uniqueidentifier') AS SECTIONREPORTID,
(select R.UINAME
from dbo.REPORTCATALOG as R
where R.ID = page.section.value('(tns:Report/@ID)[1]', 'uniqueidentifier'))
as SECTIONREPORTNAME,
coalesce(page.section.value('(tns:Report/@DisplayPromptArea)[1]', 'bit'), 0) AS DISPLAYPROMPTAREA,
coalesce(page.section.value('(tns:Report/@DisplayDocumentMap)[1]', 'bit'), 0) AS DISPLAYDOCUMENTMAP,
coalesce(page.section.value('(tns:Report/@DisplayToolbar)[1]', 'bit'), 1) AS DISPLAYTOOLBAR,
page.section.value('(tns:Report/@HistoryID)[1]', 'nvarchar(max)') AS HISTORYID,
page.section.value('(tns:CustomComponent/@AssemblyName)[1]', 'nvarchar(max)') as CUSTOMCOMPONENTSECTIONASSEMBLYNAME,
page.section.value('(tns:CustomComponent/@ClassName)[1]', 'nvarchar(max)') as CUSTOMCOMPONENTSECTIONCLASSNAME,
coalesce(page.section.value('(tns:CustomComponent/@ShowBorder)[1]', 'bit'), 0) AS CUSTOMCOMPONENTSHOWBORDER,
coalesce(page.section.value('(tns:CustomComponent/@IsScrollable)[1]', 'bit'), 1) AS CUSTOMCOMPONENTSECTIONISSCROLLABLE,
page.section.value('(tns:Dashboard/@ID)[1]', 'uniqueidentifier') AS SECTIONDASHBOARDID,
(select D.NAME
from dbo.DASHBOARDCATALOG as D
where D.ID = page.section.value('(tns:Dashboard/@ID)[1]', 'uniqueidentifier'))
as SECTIONDASHBOARDNAME,
coalesce(page.section.value('(tns:Dashboard/@IsScrollable)[1]', 'bit'), 1) AS DASHBOARDSECTIONISSCROLLABLE,
page.section.value('(tns:Calendar/@ID)[1]', 'uniqueidentifier') AS SECTIONCALENDARID,
(select C.NAME
from dbo.CALENDARCATALOG as C
where C.ID = page.section.value('(tns:Calendar/@ID)[1]', 'uniqueidentifier'))
as SECTIONCALENDARNAME,
page.section.value('(tns:RelationshipMap/@ID)[1]', 'uniqueidentifier') AS SECTIONRELATIONSHIPMAPID,
(select R.NAME
from dbo.RELATIONSHIPMAPCATALOG as R
where R.ID = page.section.value('(tns:RelationshipMap/@ID)[1]', 'uniqueidentifier'))
as SECTIONRELATIONSHIPMAPNAME,
coalesce(page.section.value('@DisplayStyle', 'nvarchar(max)'), 'Block') AS DISPLAYSTYLE,
coalesce(page.section.value('@Collapsible', 'bit'), 0) as COLLAPSIBLE,
coalesce(page.section.value('@Collapsed', 'bit'), 0) as COLLAPSED,
coalesce(page.section.value('(tns:DataList/@HideFilters)[1]', 'nvarchar(max)'), 'False') AS HIDEFILTERS,
coalesce(page.section.value('(tns:DataList/@ItemsPerPage)[1]', 'int'), '50') AS ITEMSPERPAGE,
page.section.value('(tns:DataList/tns:ParameterSection/@ID)[1]', 'uniqueidentifier') AS DATALISTPARAMETERSECTIONID,
coalesce(page.section.value('(tns:DataList/tns:ParameterSection/@HideOwnFilters)[1]', 'bit'), 0) AS DATALISTHIDEOWNFILTERS,
coalesce(page.section.value('(tns:Report/@AutoLoad)[1]', 'bit'), 0) AS AUTOLOAD,
page.section.value('(tns:Calendar/@DefaultDate)[1]', 'date') AS SECTIONCALENDARDEFAULTDATE,
page.section.value('(tns:UIWidget/@ID)[1]', 'uniqueidentifier') AS SECTIONUIWIDGETID,
(select U.NAME
from dbo.UIWIDGETCATALOG as U
where U.ID = page.section.value('(tns:UIWidget/@ID)[1]', 'uniqueidentifier'))
as SECTIONUIWIDGETNAME,
coalesce(page.section.value('(tns:UIWidget/@ShowBorder)[1]', 'bit'), 0) AS UIWIDGETSHOWBORDER,
coalesce(page.section.value('(tns:UIWidget/@AutoHeight)[1]', 'bit'), 0) AS UIWIDGETAUTOHEIGHT,
page.section.value('(tns:UIWidget/tns:ParameterSection/@ID)[1]', 'uniqueidentifier') AS UIWIDGETPARAMETERSECTIONID,
coalesce(page.section.value('(tns:UIWidget/tns:ParameterSection/@HideOwnFilters)[1]', 'bit'), 0) AS UIWIDGETHIDEOWNFILTERS,
page.section.value('(tns:WebPage/@Url)[1]', 'nvarchar(max)') AS WEBPAGESECTIONURL,
coalesce(page.section.value('(tns:WebPage/@IsScrollable)[1]', 'bit'), 0) AS WEBPAGESECTIONISSCROLLABLE,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@AllowNavigation)[1]', 'bit'), 1) AS WEBPAGESECTIONALLOWNAVIGATION,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@AllowWebBrowserDrop)[1]', 'bit'), 1) AS WEBPAGESECTIONALLOWWEBBROWSERDROP,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@IsWebBrowserContextMenuEnabled)[1]', 'bit'), 1) AS WEBPAGESECTIONISWEBBROWSERCONTEXTMENUENABLED,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@ScriptErrorsSuppressed)[1]', 'bit'), 0) AS WEBPAGESECTIONSCRIPTERRORSSUPPRESSED,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@ScrollBarsEnabled)[1]', 'bit'), 1) AS WEBPAGESECTIONSCROLLBARSENABLED,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@WebBrowserShortcutsEnabled)[1]', 'bit'), 1) AS WEBPAGESECTIONWEBBROWSERSHORTCUTSENABLED,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@UseHttpGetAndLoadManually)[1]', 'bit'), 0) AS WEBPAGESECTIONUSEHTTPGETANDLOADMANUALLY,
coalesce(page.section.value('(tns:WebPage/tns:WinUIOptions/@ProvideCredentialsFromLogin)[1]', 'bit'), 0) AS WEBPAGESECTIONPROVIDECREDENTIALSFROMLOGIN,
page.section.value('(tns:CustomUIModel/@AssemblyName)[1]', 'nvarchar(max)') as CUSTOMUIMODELSECTIONASSEMBLYNAME,
page.section.value('(tns:CustomUIModel/@ClassName)[1]', 'nvarchar(max)') as CUSTOMUIMODELSECTIONCLASSNAME,
coalesce(page.section.value('(tns:CustomUIModel/@ShowBorder)[1]', 'bit'), 0) AS CUSTOMUIMODELSHOWBORDER,
coalesce(page.section.value('(tns:CustomUIModel/@IsScrollable)[1]', 'bit'), 1) AS CUSTOMUIMODELSECTIONISSCROLLABLE,
page.section.value('(tns:ListBuilder/@QueryViewID)[1]', 'uniqueidentifier') AS LISTBUILDERSECTIONQUERYVIEWID,
(select Q.DISPLAYNAME
from dbo.QUERYVIEWCATALOG as Q
where Q.ID = page.section.value('(tns:ListBuilder/@QueryViewID)[1]', 'uniqueidentifier'))
as LISTBUILDERSECTIONQUERYVIEWNAME,
coalesce(page.section.value('(tns:ListBuilder/@AutoDisplayFilters)[1]', 'bit'), 1) AS LISTBUILDERSECTIONAUTODISPLAYFILTERS
/*#EXTENSION*/
from dbo.PAGEDEFINITIONCATALOG as P
cross apply P.PAGEDEFINITIONSPEC.nodes('//tns:Section') as page(section)