USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_BUSINESSPROCESSES_2

CREATE procedure dbo.USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_BUSINESSPROCESSES_2
(
  @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
    BP.ID,
    BP.NAME,
    BP.SECURITYUIFOLDER,
    BP.DESCRIPTION,
    PERM.ID as PERMISSIONID,
    PERM.GRANTORDENY
  from
    dbo.V_INSTALLED_BUSINESSPROCESSCATALOG as BP
  left join
    dbo.SYSTEMROLEPERM_BUSINESSPROCESS as PERM on PERM.BUSINESSPROCESSCATALOGID = BP.ID and PERM.SYSTEMROLEID = @SYSTEMROLEID
  where
    (@ONLYASSIGNED = 0 or PERM.ID is not null) 
  order by 
    BP.SECURITYUIFOLDER, BP.NAME;