V_QUERY_PAGETABS
Provides support for querying on page tabs.
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 |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | Caption resource key |
| LAYOUTURL | nvarchar(max) | yes | |
| LAYOUTMODE | nvarchar(max) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:42 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PAGETABS AS
with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
select
P.ID as PAGEID,
page.tab.value('@ID', 'uniqueidentifier') as ID,
page.tab.value('@Caption', 'nvarchar(max)') as CAPTION,
coalesce(page.tab.value('@Visible', 'nvarchar(max)'), 'True') as VISIBLE,
page.tab.value('@ImageKey', 'nvarchar(256)') as IMAGEKEY,
page.tab.value('@CaptionResourceKey', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
page.tab.value('@LayoutUrl', 'nvarchar(max)') as LAYOUTURL,
coalesce(page.tab.value('@LayoutMode', 'nvarchar(max)'), 'None') AS LAYOUTMODE
/*#EXTENSION*/
from dbo.PAGEDEFINITIONCATALOG as P
cross apply P.PAGEDEFINITIONSPEC.nodes('tns:PageDefinitionSpec/tns:Tabs/tns:Tab') as page(tab)