How does Sage CRM clean up deleted escalation rules from Escalations table?

Hi

I was testing Escalation Rules by adding a new one ([WkRl_RuleId]=10182).

Using Sage CRM, I deleted this test escalation rule.

But when I look into Escalations table, the records for [Escl_WorkFlowRuleID]]=10182 are not marked as deleted nor deleted.

I've got Escalation Service running and notifications were working.

Just want to remove traces of my tests.

When does Sage CRM clean up entries in Escalations table.

Thanks

  • 0

    Danny

    I don't think it will. I assume that you created a Notification through the admin screens?

    The escalation table is populated if the view on which the rule is based includes the escalation table. As the rule is checked then the table is populated. The records are only important if they are referenced and included when a rule is checked. If that rule has been deleted then I don't think there is a mechanism to remove those records.

  • 0

    Danny

    Cool. The Escalation table (because of the views) is always used by the rules defined as Notifications under the customization area for Company, Person, Oppo, Case etc.

    1) I divide rules into 2 broad categories

    a) Escalations & Notifications (which are defined as wkrl_ruletype = 'Time') in which the passage of time is the trigger.

    b) User driven - because these create buttons on the screen that have to pressed by a user. These are the Global, Conditional, Transitional and Primary rules.

    2) These are types of rules that you define in the Notification screens.

    1 - On Screen Notification

    2 - Email Notification

    3 - Advanced

    These are defined by the translation caption family 'NotificationType'

  • 0

    Jeff

    Yes I used admin screens.

    Do I delete entries in Escalations table from deleted Workflow Rules using SQL Delete script? (There are many records.)

    A few more questions from my tests:

    1) I tested Time Driven escalations (Quick Escalations & Escalation Rules). What are examples of User Driven Rules? (Source your post from 20 Feb 2008 on Escalation Rules)

    2) What are the WkRl_types: 1, 2, 4?

    Many Thanks