USP_DATALIST_EVENTGROUPTASKS

Displays the tasks for the given event group.
Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DATEFILTER	tinyint	IN	Tasks
@INCLUDECOMPLETED	bit	IN	Include completed
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_EVENTGROUPTASKS(
                    @MAINEVENTID uniqueidentifier,
                    @DATEFILTER tinyint = 1, 
                    @INCLUDECOMPLETED bit = 0
                    )
                as
                    set nocount on;

                    declare @DATE datetime
                    declare @STARTDATE datetime
                    declare @ENDDATE datetime

                    set @DATE = getdate();

                    if @DATEFILTER = 0        -- all

                        begin
                            set @STARTDATE = null
                            set @ENDDATE = null
                        end

                    if @DATEFILTER = 1        -- this week

                        begin
                            set @STARTDATE = dbo.UFN_DATE_THISWEEK_FIRSTDAY(@DATE, 0)
                            set @ENDDATE = dbo.UFN_DATE_THISWEEK_LASTDAY(@DATE, 0)
                        end

                    if @DATEFILTER = 2        -- this month

                        begin
                            set @STARTDATE = dbo.UFN_DATE_THISMONTH_FIRSTDAY(@DATE, 0)
                            set @ENDDATE = dbo.UFN_DATE_THISMONTH_LASTDAY(@DATE, 0)
                        end

                    if @DATEFILTER = 3        -- this quarter

                        begin
                            set @STARTDATE = dbo.UFN_DATE_THISQUARTER_FIRSTDAY(@DATE, 0)
                            set @ENDDATE = dbo.UFN_DATE_THISQUARTER_LASTDAY(@DATE, 0)
                        end

                    select 
                        EVENTTASK.ID,
                        case when EVENTTASK.STATUSCODE = 0 and datediff(day, @DATE, EVENTTASK.COMPLETEBYDATE) < 0 then 
                            1
                        else 
                            0
                        end,
                        case when EVENTTASK.STATUSCODE = 0 and datediff(day, @DATE, EVENTTASK.COMPLETEBYDATE) < 0 then 
                            'RES:warning'
                        when EVENTTASK.STATUSCODE = 1 then 
                            'RES:checkmark'
                        else 
                            'RES:lv_spacer'
                        end,                                    
                        EVENTTASK.COMPLETEBYDATE,
                        EVENTTASK.NAME,
                        dbo.UFN_CONSTITUENT_BUILDNAME(EVENTTASK.OWNERID),
                        EVENTTASK.DATECOMPLETED,
                        EVENTTASK.STATUSCODE, 
                        EVENTTASK.COMMENT,
                        EVENT.NAME,
                        EVENT.ID
                    from 
                        dbo.EVENTTASK 
                        inner join dbo.EVENT on EVENT.ID = EVENTTASK.EVENTID                        
                    where 
                        (EVENT.MAINEVENTID = @MAINEVENTID  or EVENT.ID = @MAINEVENTID) and 
                        ((@STARTDATE is null) or (EVENTTASK.STATUSCODE = 0 and datediff(day, @DATE, EVENTTASK.COMPLETEBYDATE) < 0) or (EVENTTASK.COMPLETEBYDATE is null or EVENTTASK.COMPLETEBYDATE between @STARTDATE and @ENDDATE)) and
                        ((EVENTTASK.STATUSCODE = 0) or (@INCLUDECOMPLETED = 1))                  
                    order by
                        EVENTTASK.STATUS asc,
                        EVENTTASK.COMPLETEBYDATE asc,
                        EVENTTASK.DATECOMPLETED asc