USP_REPORT_APPEALPROFILE_DESIGNATIONS

CREATE procedure dbo.USP_REPORT_APPEALPROFILE_DESIGNATIONS
(
    @APPEALID uniqueidentifier = null,
    @SHOW bit = null,
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;

begin try            
    if @SHOW = 1
    begin
        declare @USERGRANTEDDESIGNATIONPAGE bit = 1;
        -- NOTE: Be sure to update AppealProfileReportSectionsHaveData.View.xml if you modify

        -- the joins/constraints of the below query.

        if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) <> 1 and @CURRENTAPPUSERID is not null
            select @USERGRANTEDDESIGNATIONPAGE = [dbo].[UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE](@CURRENTAPPUSERID, '4EADC264-0A44-4DF5-8C8C-D89A1C48746C')

        select
            case when @USERGRANTEDDESIGNATIONPAGE = 1
            then
                'http://www.blackbaud.com/DESIGNATIONID?DESIGNATIONID=' + CONVERT(nvarchar(36),DESIGNATION.ID)
            else
                null
            end as [DESIGNATIONID],
            DESIGNATION.USERID, 
            DESIGNATION.[NAME]
        from dbo.DESIGNATION
        inner join dbo.APPEALDESIGNATION
        on DESIGNATION.ID = APPEALDESIGNATION.DESIGNATIONID
        where APPEALID = @APPEALID
        order by DESIGNATION.[USERID];
    end
end try

begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch

return 0;