USP_DATALIST_LOCALFUNDRAISINGGROUPS

CREATE procedure dbo.USP_DATALIST_LOCALFUNDRAISINGGROUPS
(
  @NFGCAMPAIGNID uniqueidentifier,
  @GROUPNAME nvarchar(250) = null,
  @EVENTNAME nvarchar(250) = null,
  @LEVEL uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    select 
    TFT.ID,
    TFT.NAME,
    case when TX.TYPECODE in (1,2) then TFT.GOAL else TX.TARGETFUNDRAISINGGOAL end as GOAL,
    FGS.TOTALFUNDRAISE as TOTALAMOUNTRAISED,
    TX.TYPE as ROLE,
    dbo.UFN_NFGLEVEL_GETFULLPATHNAME(LVL.ID, '/', 0) as GROUPLEVEL,
    E.NAME as EVENTNAME
  from TEAMFUNDRAISINGTEAM TFT (nolock) 
    inner join TeamExtension TX (nolock) on TX.TEAMFUNDRAISINGTEAMID = TFT.ID
    inner join FAFNFGCampaignLevel LVL (nolock) on LVL.ID = TX.NFGCAMPAIGNLEVELID
    inner join FAFNFGCAMPAIGN NFG (nolock) on NFG.ID = LVL.NFGCAMPAIGNID
    left join [EVENT] E (nolock) on E.ID = TX.EVENTID
    left join dbo.FAFGROUPSUMMARYINFORMATION FGS (nolock) on FGS.ID = TFT.ID
  where
    NFG.ID = @NFGCAMPAIGNID
    and E.ID in (select EVENTID from EVENTEXTENSION where FAFPROGRAMID = NFG.CAMPAIGNID)
    and ( E.NAME like @EVENTNAME + '%' OR @EVENTNAME is null) 
    and ( TFT.NAME like @GROUPNAME + '%' OR @GROUPNAME is null)
    and ( LVL.ID = @LEVEL OR @LEVEL is null)
  order by LVL.HIERARCHYPATH