USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_QUERYVIEWS

                CREATE procedure [dbo].[USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_QUERYVIEWS]
                (
                    @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 7;
                end;

                select
                    [CATALOG].ID,
                    [CATALOG].DISPLAYNAME [NAME],
                    [CATALOG].SECURITYUIFOLDER,
                    [PERM].GRANTORDENY,
                    [CATALOG].DESCRIPTION,
                    [PERM].ID as [PERMISSIONID],
                    cast(coalesce(CATALOG.QUERYVIEWSPEC.value('declare namespace bbfa="bb_appfx_queryview";/bbfa:QueryViewSpec[1]/@SecurityUIDisplayFeature','bit'), 1) as bit) DISPLAYFEATURE,
                    [CATALOG].QUERYVIEWSPEC as SPECXML
                from 
                    dbo.QUERYVIEWCATALOG as [CATALOG]
                left outer join
                    (
                        select 
                            ID, 
                            GRANTORDENY, 
                            QUERYVIEWCATALOGID 
                        from 
                            dbo.SYSTEMROLEPERM_QUERYVIEW
                        where 
                            SYSTEMROLEID = @SYSTEMROLEID
                    ) as [PERM] on [PERM].QUERYVIEWCATALOGID = [CATALOG].ID
                where 
                    ([PERM].ID is not null) or (@ONLYASSIGNED = 0)
                order by 
                    [CATALOG].SECURITYUIFOLDER, [CATALOG].DISPLAYNAME;