Monday, July 23, 2018
Friday, July 20, 2018
Options and settings when building relationship fields in Salesforce
Lookup relationship options
When you create a lookup field on an object, you can choose whether the lookup field is required or optional. If the lookup field is optional, you can specify one of three behaviors to occur if the lookup record is deleted:- Clear the value of this field: This is a default option and is a good choice when the field does not have to contain a value from the associated lookup record.
- Don’t allow deletion of the lookup record that’s part of a lookup relationship: This option prevents the lookup record from being deleted and is a good choice for restricting deletions if you have dependencies, such as workflow rules, based on the lookup relationship.
- Delete this record also: This option works similar to the master-detail relationship and deletes the record whenever the lookup record is deleted. Choosing this option can result in a cascade-delete. A cascade-delete bypasses security and sharing settings, which means users can delete records when the target lookup record is deleted even if they don’t have access to the records. To prevent records from being accidentally deleted, cascade-delete is disabled by default. Contact Salesforce to get the cascade-delete option enabled for your organization.
This option is only available within custom objects and is not available for standard objects. However, the lookup field object can be either a standard or custom object.
Master-detail relationship options
- Allow reparenting option: By default, records in master-detail relationships cannot be reparented. However, you can allow child records in a master-detail relationship to be reparented to a different parent by selecting Allow reparenting option in the master-detail relationship definition.
Other links for references:
- One to one relationship: http://biswajeetsamal.com/blog/create-one-to-one-relationship-in-salesforce/
- Imitate rollup summary in a lookup relationship: http://biswajeetsamal.com/blog/rollup-summary-trigger-for-a-lookup-relationship/
- Difference between hierarchical relationship and self relationship: https://success.salesforce.com/answers?id=90630000000CuhyAAC
Wednesday, July 18, 2018
Salesforce Enterprise Territory Management: running assignment rules via API
Enterprise Territory Management is an account-sharing model that grants access to accounts based on the attributes of the accounts. A territory is a collection of the account records and business users where the users have minimum read access to the accounts, irrespective of who owns the account records. By enabling territory settings, users can get read, read/write, or owner-like access to the accounts in that territory. For comprehensive instructions for implementing this feature, see the Enterprise Territory Management Implementation Guide.
Salesforce allows you to add accounts manually to territories or define account assignment rules that assign accounts to territories for you. If you want the rule to run automatically when a user creates or updates an account, then you need to understand how the dynamic assignment will work when an account record is updated via UI or API.
1. If the account is updated via the UI, "Evaluate this account against territory rules on save" checkbox needs to be selected. You can refer the article below to add this checkbox to the page layout:
https://help.salesforce.com/articleView?id=000004725&type=1
2. If the account is updated via API,
AssignmentRuleHeader
must be specified in the update()
call of an Account for the territory assignment rules to be applied as per the SOAP API Developer Guide.Make sure that the Active checkbox is selected on the rule edit page, or else rules won't run automatically.
To test the automatic assignment of territories using the 2nd approach, I created a territory assignment rule DEMO_TERRITORY. I configured this rule in such a way that it will assign an account record to a territory with the same name, i.e. DEMO_TERRITORY, in my territory hierarchy.
I also created a custom field "Account Territory" on Account object; when this field is populated with the name of the territory, a trigger is invoked which will then call a future method.
trigger AccountAfterUpdate on Account (after update) {
List<Id> accountIds = new List<Id>();
for (Account acc : Trigger.new) {
if (acc.Run_Territory__c) {
accountIds.add(acc.Id);
}
}
if (accountIds.size() > 0) {
Territory2Controller.runTerritoryRulesFuture(accountIds, UserInfo.getSessionId());
}
}
All territory assignment rules are applied for the account(s) if for the element name
useDefaultRule
, value is true. If the value is false, then no territory assignment rules are applied.This is the source code of the future method.
I also updated
Run_Territory__c
to false
in the webservice call to prevent recursive future calls as I was getting System.CalloutException: Callout loop not allowed
exception.Please remember that the maximum records in an update request can be 200. You can't just dump in thousands of records in an API call.
Subscribe to:
Posts (Atom)