USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DATALISTS

                CREATE procedure [dbo].[USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DATALISTS]
                @SYSTEMROLEID uniqueidentifier,
                @ONLYASSIGNED bit=0

                /*
                Used by the SecurityGetRoleFeaturePermTreeRequest web service

                */
                as

                set nocount on;

                if @SYSTEMROLEID is null 
                    begin
                    raiserror('@SYSTEMROLEID is required',16,10);
                    return 9;
                    end;

                select 
                    DL.ID,
                    DL.NAME as DISPLAYNAME, 
                    DL.SECURITYUIFOLDER,
                    DL.DESCRIPTION,
                    PERM.GRANTORDENY, 
                    PERM.ID as PERMISSIONID,
                    cast(coalesce(DL.DATALISTSPEC.value('declare namespace bbfa="bb_appfx_datalist";/bbfa:DataListSpec[1]/@SecurityUIDisplayFeature','bit'), 1) as bit) DISPLAYFEATURE,
                    DL.DATALISTSPEC as SPECXML
                from 
                    dbo.DATALISTCATALOG AS DL
                left outer join 
                    (
                    select 
                        ID,
                        GRANTORDENY,
                        DATALISTCATALOGID 
                    from  
                        dbo.SYSTEMROLEPERM_DATALIST as PERM
                    where 
                        SYSTEMROLEID=@SYSTEMROLEID
                    )
                    as PERM on DL.ID=PERM.DATALISTCATALOGID
                where  
                    (PERM.ID is not null) or (@ONLYASSIGNED=0)
                order by 
                    DL.SECURITYUIFOLDER, DL.NAME;