V_QUERY_PAGEACTIONGROUPS
Provides support for querying on page action groups.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PAGEID | uniqueidentifier | Page ID | |
| ID | uniqueidentifier | yes | ID |
| CAPTION | nvarchar(max) | yes | Caption |
| VISIBLE | nvarchar(max) | yes | Visible |
| IMAGEKEY | nvarchar(256) | yes | Image key |
| DEFAULTCOLLAPSED | nvarchar(max) | yes | Default collapsed |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | Caption resource key |
| RENDERLOCATION | varchar(12) | ||
| RENDERLOCATIONTABID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:52 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PAGEACTIONGROUPS AS
with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
select
P.ID as PAGEID,
page.actiongroup.value('@ID', 'uniqueidentifier') as ID,
page.actiongroup.value('@Caption', 'nvarchar(max)') as CAPTION,
coalesce(page.actiongroup.value('@Visible', 'nvarchar(max)'), 'True') as VISIBLE,
page.actiongroup.value('@ImageKey', 'nvarchar(256)') as IMAGEKEY,
coalesce(page.actiongroup.value('@DefaultCollapsed', 'nvarchar(max)'), 'False') as DEFAULTCOLLAPSED,
page.actiongroup.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
case
when page.actiongroup.exist('tns:RenderLocation/tns:Tab') = 1 then 'Tab'
else 'Explorer bar'
end as RENDERLOCATION,
case when page.actiongroup.exist('tns:RenderLocation/tns:Tab') = 1 then
page.actiongroup.value('(tns:RenderLocation/tns:Tab/@ID)[1]', 'uniqueidentifier')
else null
end as RENDERLOCATIONTABID
/*#EXTENSION*/
from dbo.PAGEDEFINITIONCATALOG as P
cross apply P.PAGEDEFINITIONSPEC.nodes('tns:PageDefinitionSpec/tns:PageActionGroups/tns:PageActionGroup') as page(actiongroup)