Please study the corrections marked by Fred onto the following 07.04.00.SqlDataProvider located in /Providers\DataProviders\SqlDataProvider folder and comment:
Thanks again, I was able to fix the duplicate index problem by making 2 changes to 07.04.00.sqldataprovider. See comments /* Fred.. */ below:
07.04.00.SqlDataProvider file contents:
/* Remove Review action and add Approve, Reject */
DECLARE @NotificationTypeId INT
SELECT @NotificationTypeId = NotificationTypeId
FROM
{databaseOwner}{objectQualifier}CoreMessaging_NotificationTypes
WHERE Name = 'ContentWorkflowNotification'
IF @NotificationTypeId IS NOT NULL
BEGIN
/* Delete Review notification action added int 7.3.0 */
DELETE FROM {databaseOwner} {objectQualifier}CoreMessaging_NotificationTypeActions WHERE NotificationTypeId = @NotificationTypeId AND NameResourceKey = 'Review'
/* Add Approve notification action */
INSERT INTO {databaseOwner}{objectQualifier}
CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationTypeId,
'Approve',
'Approve',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Approve',
-1,
GETDATE(),
-1,
GETDATE()
)
/* Add Reject notification action */
INSERT INTO
{databaseOwner}{objectQualifier}CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationTypeId,
'Reject',
'Reject',
NULL,
2, /* changed by Fred 2-9-2015 old value 1, */
'DesktopModules/InternalServices/API/ContentWorkflowService/Reject',
-1,
GETDATE(),
-1,
GETDATE()
)
END
GO
/* Add action to Start Workflow Notification */
DECLARE @NotificationStartWorkflowTypeId INT
SELECT @NotificationStartWorkflowTypeId = NotificationTypeId
FROM {databaseOwner} {objectQualifier}CoreMessaging_NotificationTypes
WHERE Name = 'ContentWorkflowStartWorkflowNotification'
IF @NotificationStartWorkflowTypeId IS NOT NULL
BEGIN
/* Add Submit notification action */
/* also uses the existing Approve method */
INSERT INTO {databaseOwner}{objectQualifier}
CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationStartWorkflowTypeId,
'Submit',
'Submit',
NULL,
1,
'DesktopModules/InternalServices/API/ContentWorkflowService/Approve',
-1,
GETDATE(),
-1,
GETDATE()
)
/* Add Discard notification action */
/* also uses the existing Reject method */
INSERT INTO
{databaseOwner} {objectQualifier}
CoreMessaging_NotificationTypeActions(
[NotificationTypeID],
[NameResourceKey],
[DescriptionResourceKey],
[ConfirmResourceKey],
[Order],
[APICall],
[CreatedByUserID],
[CreatedOnDate],
[LastModifiedByUserID],
[LastModifiedOnDate])
VALUES(
@NotificationStartWorkflowTypeId,
'Discard',
'Discard',
NULL,
2, /* changed by Fred 2-9-2015 old value 1, */
'DesktopModules/InternalServices/API/ContentWorkflowService/Reject',
-1,
GETDATE(),
-1,
GETDATE()
)
END
GO
Panagiotis Mylonas
Managing Director
InteliBrain
http://InteliBrain.gr
|