Detached or Delayed Table Level Scripts are a type of script that is executed within a predefined amount of time after a record is inserted, updated, or deleted on a specified table. We are announcing that this feature will be deprecated in Sage CRM 2024 R1 and eventually removed from Sage CRM.
Detached Table Level Scripts are a complex feature that can severely reduce performance if not used carefully. Escalation Rules provide a more efficient and reliable way to achieve the same results.
If you are using Detached Table Level Scripts in your Sage CRM system, you will need to migrate them to Escalation Rules before the feature is removed.
To establish whether Detached Table Level Scripts are used in your system you can check this within the database.
select * from Custom_Scripts where CScr_ScriptType = 'tlsdetached';
This will report the tables the scripts are defined against.
To refactor or rewrite a business rule expressed in a Detached Table Level Script in Sage CRM into an Escalation Rule, you will need to:
- Identify the event that will trigger the Escalation Rule. This will typically be the same event that triggers the Detached Table Level Script, such as the insertion, update, or deletion of a record on a specific table.
- Identify the conditions that must be met for the Escalation Rule to be executed. These conditions will typically be the same conditions that are used in the Detached Table Level Script.
- Identify the actions that should be taken when the Escalation Rule executes. These actions will typically be the same actions that are performed by the Detached Table Level Script.
Once you have identified these three things, you can create the Escalation Rule in Sage CRM.
We recommend that you investigate migrating your Delayed Table Level Scripts to Escalation Rules as soon as possible.
If you need assistance with migrating your Delayed Table Level Scripts, please contact our support team or post a query within Sage City.
Note: Other types of Table and Entity Level Scripts are not affected by this change.
This advisory applies to Sage CRM stand-alone and when integrated with Sage accounting products: Sage 50, Sage 100, Sage 200, Sage 300, Sage X3 and Sage Intacct.