USP_DATALIST_COMMUNITYMEMBERPAGEVISITSUMMARYBYCONSTITUENT

Returns a summary of Blackbaud Internet Solutions page visits for a community member by their constituent id.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@VIEWFILTER	tinyint	IN	View visits per

Definition

Copy



CREATE procedure dbo.USP_DATALIST_COMMUNITYMEMBERPAGEVISITSUMMARYBYCONSTITUENT
(
    @CONSTITUENTID uniqueidentifier,
    @VIEWFILTER tinyint = 2
)
as
    set nocount on;

        -- Bug 492035 - merging page visit summary

    declare @pageVisitSummary table ([DATE] date,[VISITCOUNT] int );
      create table #NETCOMMUNITYCLIENTUSERIDSTABLE(ROWINDEX int identity(1,1),ID uniqueidentifier);
      declare @ROWINDEX int=1,@ROWCOUNT int =0,@NETCOMMUNITYCLIENTUSERID uniqueidentifier;
    -- SP to populate data in temp table and determine the row count    

    exec dbo.USP_BBNC_GETNETCOMMUNITYCLIENTUSERIDS @CONSTITUENTID,@ROWCOUNT output;

      while(@ROWINDEX<=@ROWCOUNT)
      begin
          select @NETCOMMUNITYCLIENTUSERID = ID from #NETCOMMUNITYCLIENTUSERIDSTABLE where ROWINDEX = @ROWINDEX;

          insert into @pageVisitSummary
                  exec dbo.USP_DATALIST_COMMUNITYMEMBERPAGEVISITSUMMARY @NETCOMMUNITYCLIENTUSERID, @VIEWFILTER;

          set @ROWINDEX = @ROWINDEX + 1;
      end

    drop table #NETCOMMUNITYCLIENTUSERIDSTABLE;
    select [DATE],sum([VISITCOUNT]) from @pageVisitSummary group by [DATE];