V_SEARCH_RE7BBNCPAGE

Fields

Field	Field Type	Null	Description
ID	int
DESCRIPTION	nvarchar(100)	yes

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  2/6/2025 8:50:37 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_RE7BBNCPAGE AS



      with [RANKEDPAGES] ([PAGE_LOCALID], [NAME], [SEQUENCE]) as
      (
        select 
          [PAGE_LOCALID], 
          [NAME], 
          row_number() over(partition by [PAGE_LOCALID] order by [DATELASTVISIT] desc)
        from
          dbo.[RE7_BBNCPERSONALPAGES] where [PAGE_LOCALID] > 0 and [NAME] is not null
      )
      select
        [PAGE_LOCALID] [ID],
        [NAME] [DESCRIPTION]
      from [RANKEDPAGES]
      where
      [SEQUENCE] = 1