USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DATALISTS_2

CREATE procedure dbo.USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_DATALISTS_2
(
  @SYSTEMROLEID uniqueidentifier,
  @ONLYASSIGNED bit = 0,
  @ONLYDISPLAYED bit = 0
)
/*
Used by the SecurityGetRoleFeaturePermTreeRequest web service
*/
as

  set nocount on;

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