| In the sql script 04.09.01, the object qualifier was not properly coded which would cause the module to fail during module installation in the portal that has object qualifier specified in the web.config file. This is fixed in the 04.09.04 script. |
/****** Object: StoredProcedure {databaseOwner}{objectQualifier}WC_UM_GetRolesByGroup Script Date: 10/30/2008 00:12:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE {databaseOwner}{objectQualifier}WC_UM_GetRolesByGroup
@PortalId int,
@RoleGroupId int = NULL,
@TabModuleID int = NULL
AS
BEGIN
IF NOT EXISTS(SELECT TabModuleID
FROM {databaseOwner}{objectQualifier}WC_UM_RoleSettings
WHERE TabModuleID = @TabModuleID
)
SELECT RoleId,
PortalId,
RoleGroupId,
RoleName,
Description,
ServiceFee,
BillingPeriod,
BillingFrequency,
TrialFee,
TrialPeriod,
TrialFrequency,
ISPublic,
AutoAssignment,
RSVPCode,
IconFile,
Setting
FROM {databaseOwner}{objectQualifier}vw_WC_UM_RoleSettings
WHERE PortalId = @PortalId
AND (RoleGroupId = @RoleGroupId OR RoleGroupId IS NULL AND @RoleGroupId IS NULL)
ORDER BY RoleName
ELSE
BEGIN
IF NOT EXISTS(SELECT TabModuleID
FROM {databaseOwner}{objectQualifier}WC_UM_RoleSettings
WHERE TabModuleID = @TabModuleID
AND Setting = 1)
BEGIN
SELECT RoleId,
PortalId,
RoleGroupId,
RoleName,
Description,
ServiceFee,
BillingPeriod,
BillingFrequency,
TrialFee,
TrialPeriod,
TrialFrequency,
ISPublic,
AutoAssignment,
RSVPCode,
IconFile,
Setting
FROM {databaseOwner}{objectQualifier}vw_WC_UM_RoleSettings
WHERE PortalId = @PortalId
AND (RoleGroupId = @RoleGroupId OR RoleGroupId IS NULL AND @RoleGroupId IS NULL)
AND Setting IS NULL
ORDER BY RoleName
END
ELSE
BEGIN
SELECT RoleId,
PortalId,
RoleGroupId,
RoleName,
Description,
ServiceFee,
BillingPeriod,
BillingFrequency,
TrialFee,
TrialPeriod,
TrialFrequency,
ISPublic,
AutoAssignment,
RSVPCode,
IconFile,
Setting
FROM {databaseOwner}{objectQualifier}vw_WC_UM_RoleSettings
WHERE PortalId = @PortalId
AND (RoleGroupId = @RoleGroupId OR RoleGroupId IS NULL AND @RoleGroupId IS NULL)
AND TabModuleID = @TabModuleID
AND Setting = 1
ORDER BY RoleName
END
END
END
|