USP_DATALIST_IMPORTSOURCE

CREATE procedure dbo.USP_DATALIST_IMPORTSOURCE
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEFILTERMODE tinyint = 0,
  @SITESSELECTED xml = null,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
    set nocount on;

    select IMPORTSOURCE.ID,
           IMPORTSOURCE.NAME,
           IMPORTSOURCE.URLORPATH,
       (select count(1) from dbo.IMPORTPROCESS where IMPORTSOURCEID = IMPORTSOURCE.ID) as IMPORTCOUNT,
       coalesce(SITE.NAME,'All Sites') SITES,
       IMPORTSOURCE.IMPORTSOURCETYPECODE
    from dbo.IMPORTSOURCE
  left join dbo.SITE on SITE.ID = IMPORTSOURCE.SITEID
  where (
    (
      (--Check site security

        select count(*) 
        from dbo.UFN_SITEID_MAPFROM_IMPORTSOURCEID(IMPORTSOURCE.ID) as IMPORTSOURCESITE 
        where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[IMPORTSOURCESITE].[SITEID] or (SITEID is null and [IMPORTSOURCESITE].[SITEID] is null)))
      ) > 0
    )
    and (--Apply site filter

      @SITEFILTERMODE = 0
      or IMPORTSOURCE.SITEID in (select SITEID from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED))
    )
  );