V_SEARCH_RE7BBNCWEBTRAFFICPAGE

Fields

Field	Field Type	Null	Description
ID	int
DESCRIPTION	nvarchar(255)	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_RE7BBNCWEBTRAFFICPAGE AS



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