USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_RECORDOPERATIONS

                CREATE procedure [dbo].[USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_RECORDOPERATIONS]
                @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 
                    CAT.ID,
                    CAT.DISPLAYNAME, 
                    CAT.SECURITYUIFOLDER, 
                    PERM.GRANTORDENY,
                    CAT.DESCRIPTION,
                    PERM.ID AS PERMISSIONID,
                    cast(coalesce(CAT.RECORDOPERATIONSPECXML.value('declare namespace bbfa="bb_appfx_recordoperation";/bbfa:RecordOperationSpec[1]/@SecurityUIDisplayFeature','bit'), 1) as bit) DISPLAYFEATURE,
                    CAT.RECORDOPERATIONSPECXML as SPECXML
                from 
                    dbo.RECORDOPERATIONCATALOG as CAT
                left outer join 
                    (
                    select 
                        ID,
                        GRANTORDENY,
                        RECORDOPERATIONCATALOGID 
                    from  
                        dbo.SYSTEMROLEPERM_RECORDOPERATION
                    where 
                        SYSTEMROLEID=@SYSTEMROLEID
                    )
                    as PERM on CAT.ID=PERM.RECORDOPERATIONCATALOGID
                where  
                    (PERM.ID is not null) or (@ONLYASSIGNED=0)
                order by 
                    CAT.SECURITYUIFOLDER, CAT.DISPLAYNAME;