V_QUERY_PAGECONTEXTLINKS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PAGEID | uniqueidentifier | ||
| ID | uniqueidentifier | yes | |
| LINKPAGEID | nvarchar(max) | yes | |
| TABID | nvarchar(max) | yes | |
| CONTEXTID | nvarchar(max) | yes | |
| VISIBLE | nvarchar(max) | yes | |
| IMAGEKEY | nvarchar(256) | yes | |
| CAPTION | nvarchar(max) | yes | |
| LABEL | nvarchar(max) | yes | |
| CAPTIONRESOURCEKEY | nvarchar(max) | yes | |
| LABELRESOURCEKEY | 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_PAGECONTEXTLINKS AS
with xmlnamespaces ('bb_appfx_pagedefinition' as tns, 'bb_appfx_commontypes' as common)
select
P.ID as PAGEID,
page.contextlink.value('@ID', 'uniqueidentifier') as ID,
page.contextlink.value('@PageID', 'nvarchar(max)') as LINKPAGEID,
page.contextlink.value('@TabID', 'nvarchar(max)') as TABID,
page.contextlink.value('@ContextID', 'nvarchar(max)') as CONTEXTID,
coalesce(page.contextlink.value('@Visible', 'nvarchar(max)'), 'True') as VISIBLE,
page.contextlink.value('@ImageKey', 'nvarchar(256)') as IMAGEKEY,
case
when LEN(page.contextlink.value('(tns:Caption)[1]', 'nvarchar(max)')) = 0 then null
else page.contextlink.value('(tns:Caption)[1]', 'nvarchar(max)')
end as CAPTION,
page.contextlink.value('(tns:Caption/@Label)[1]', 'nvarchar(max)') as LABEL,
page.contextlink.value('(tns:Caption/@CaptionResourceKey)[1]', 'nvarchar(max)') as CAPTIONRESOURCEKEY,
page.contextlink.value('(tns:Caption/@LabelResourceKey)[1]', 'nvarchar(max)') as LABELRESOURCEKEY
/*#EXTENSION*/
from dbo.PAGEDEFINITIONCATALOG as P
cross apply P.PAGEDEFINITIONSPEC.nodes('tns:PageDefinitionSpec/tns:PageHeader/tns:ContextLinks/tns:ContextLink') as page(contextlink)