USP_DATALIST_COMMUNITYMEMBERMOSTRECENTPAGES

Lists the Blackbaud Internet Solutions pages most recently visited by a given community member.

Parameters

Parameter	Parameter Type	Mode	Description
@NETCOMMUNITYCLIENTUSERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@MAXPAGES	int	IN	View
@ASOFDATE	datetime	IN	As of

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_COMMUNITYMEMBERMOSTRECENTPAGES
                (
                    @NETCOMMUNITYCLIENTUSERID uniqueidentifier,
                    @MAXPAGES int = 5,
                    @ASOFDATE datetime = null
                )
                as begin
                    set nocount on;

                    if @MAXPAGES is null or @MAXPAGES < 1
                        set @MAXPAGES = 5;
                    else if @MAXPAGES > 500
                        set @MAXPAGES = 500;

                    select top (@MAXPAGES)
                        [NETCOMMUNITYWEBTRAFFIC].[PAGENAME],
                        [NETCOMMUNITYWEBTRAFFIC].[URL],
                        [NETCOMMUNITYWEBTRAFFIC].[REQUESTDATE]
                    from
                        dbo.NETCOMMUNITYWEBTRAFFIC
                    where
                        [NETCOMMUNITYWEBTRAFFIC].[NETCOMMUNITYCLIENTUSERID] = @NETCOMMUNITYCLIENTUSERID
                        and
                        (
                            @ASOFDATE is null
                            or [NETCOMMUNITYWEBTRAFFIC].[REQUESTDATE] <= @ASOFDATE
                        )
                    order by
                        [NETCOMMUNITYWEBTRAFFIC].[REQUESTDATE] desc, [NETCOMMUNITYWEBTRAFFIC].[PAGENAME];

                    return 0;
                end