USP_DATALIST_SCHEDULINGCONFLICTS

This datalist returns the scheduling conflicts for the program.

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@SHOWUNCONFLICTED	bit	IN	Only show events which no longer conflict

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_SCHEDULINGCONFLICTS
            (
                @PROGRAMID uniqueidentifier,
                @SHOWUNCONFLICTED bit=0
            )
            as 
                set nocount on;

            select
                EVENTCONFLICT.ID,
                'cfd5de7d-866d-4d7d-bcb8-c42a83763d5b' as [VIEWFORMID],
                dbo.UFN_EVENTCONFLICT_NOCONFLICTS(EVENTCONFLICT.ID) AS NOCONFLICTS,
                case 
                    when dbo.UFN_EVENTCONFLICT_NOCONFLICTS(EVENTCONFLICT.ID) = 1 then 
                        'RES:info'
                    else 
                        'RES:lv_spacer'
                    end as SHOWNOCONFLICTS,
                dbo.UFN_EVENTCONFLICT_ALLOWUNDOLASTRUN(EVENTCONFLICT.ID) as ALLOWUNDO,
                --dbo.UFN_EVENTCONFLICT_GETADDEDBY(EVENTCONFLICT.ID) as ADDEDAT,

                EVENTCONFLICT.DATEADDED as ADDEDAT,
                EVENTCONFLICT.NAME as EVENTNAME,
                EVENTCONFLICT.STARTDATE,
                dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENTCONFLICT.STARTTIME) + ' - ' + dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENTCONFLICT.ENDTIME) as EVENTTIMESPAN,
                dbo.UFN_EVENTCONFLICT_GETLOCATIONNAME(EVENTCONFLICT.ID) AS EVENTLOCATION
            from dbo.EVENTCONFLICT
            where 
                PROGRAMID=@PROGRAMID and
                (
                    (@SHOWUNCONFLICTED=0) or 
                    (@SHOWUNCONFLICTED = 1 and dbo.UFN_EVENTCONFLICT_NOCONFLICTS(EVENTCONFLICT.ID) = 1)
                )
            order by EVENTCONFLICT.STARTDATE, EVENTCONFLICT.STARTTIME