USP_DATALIST_VOLUNTEERASSIGNMENTSDAY

This datalist returns all assignments for a volunteer on a specified day.

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@DAY	datetime	IN	Day
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            create procedure dbo.USP_DATALIST_VOLUNTEERASSIGNMENTSDAY (@VOLUNTEERID uniqueidentifier = null, @DAY datetime, @CURRENTAPPUSERID uniqueidentifier = null)
            as
                set nocount on;

                select    VOLUNTEERASSIGNMENT.ID,
                        JOBOCCURRENCE.DESCRIPTION,
                        JOBOCCURRENCE.STARTTIME,
                        JOBOCCURRENCE.ENDTIME
                from dbo.VOLUNTEERASSIGNMENT
                inner join dbo.JOBOCCURRENCE 
                    on dbo.VOLUNTEERASSIGNMENT.JOBOCCURRENCEID = dbo.JOBOCCURRENCE.ID
                inner join dbo.JOB
                    on dbo.JOBOCCURRENCE.JOBID = dbo.JOB.ID
                where VOLUNTEERASSIGNMENT.VOLUNTEERID = @VOLUNTEERID
                        and VOLUNTEERASSIGNMENT.DATE = @DAY
                        and (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID,JOBOCCURRENCE.SITEID) = 1)
                        and (dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID,JOB.SITEID) = 1)
                order by JOBOCCURRENCE.DESCRIPTION;