USP_SHELL_GETRSSFEEDDATALISTS

CREATE procedure [dbo].[USP_SHELL_GETRSSFEEDDATALISTS](@APPUSERID uniqueidentifier)
as

begin
    set nocount on;

    declare @IsSysAdmin bit;

    select @IsSysAdmin = ISSYSADMIN 
        from dbo.APPUSER 
        where ID = @APPUSERID;

    select d.ID,
        d.[NAME],
        d.[DESCRIPTION],
        d.RECORDTYPEID,
        r.DEFAULTSEARCHLISTID
        from dbo.V_INSTALLED_DATALISTCATALOG d left join 
            dbo.RECORDTYPE r on d.RECORDTYPEID = r.ID
        where 
        cast(RSSFEEDDEFINITION as nvarchar(max)) <> '' and
        ((d.RECORDTYPEID is null) or (not r.DEFAULTSEARCHLISTID is null))
        and (@IsSysAdmin = 1 or 
            dbo.UFN_SECURITY_APPUSER_GRANTED_DATALIST_IN_SYSTEMROLE(@APPUSERID, d.ID) = 1)

    return 0;
end