USP_SEARCHLIST_NOEVENTAPPEAL

create procedure dbo.USP_SEARCHLIST_NOEVENTAPPEAL
(
  @CURRENTAPPUSERID uniqueidentifier,
  @EVENTID uniqueidentifier = null,
    @NAME nvarchar(100) = null,
    @MAXROWS smallint = 500,
  @APPEALCATEGORYCODEID uniqueidentifier = null,
  @INCLUDEINACTIVE bit = 0,
  @REPORTCODE uniqueidentifier = null,
  @SITEID uniqueidentifier = null,
  @EXACTMATCHONLY bit = 0,
  @BASECURRENCYID uniqueidentifier = null

)
as
    set @NAME = COALESCE(@NAME,'') + '%' ;

    select top(@MAXROWS)
        A.ID,
        A.NAME,
        A.DESCRIPTION,
        ACC.DESCRIPTION as Category,
    A.ISACTIVE,
    S.NAME as SITE
    from 
        dbo.APPEAL A 
      left join dbo.EVENT E on A.ID = E.APPEALID
    left join dbo.APPEALCATEGORYCODE ACC on A.APPEALCATEGORYCODEID = ACC.ID
    left join dbo.SITE S on A.SITEID = S.ID
    where
     dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, A.SITEID) = 1 and (E.ID is null or E.ID = @EVENTID)
         and (A.NAME LIKE @NAME) 
     and (@SITEID is null or A.SITEID = @SITEID ) 
     and (@APPEALCATEGORYCODEID is null or A.APPEALCATEGORYCODEID = @APPEALCATEGORYCODEID)
     and (@INCLUDEINACTIVE = 0 OR A.ISACTIVE = @INCLUDEINACTIVE)
     and (@REPORTCODE is null or A.APPEALREPORT1CODEID = @REPORTCODE)
    order by 
        NAME asc