Salesforce的sharing Rule 不支持Lookup型字段解决方案

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

Salesforce 中 sharing rule 并不支持Look up 字段和 formula 字段。但在实际项目中，有时会需要在sharing rule中直接取Look up型字段的值，解决方案就是在目标object上新建一个字段，写trigger,将需要获取的Lookup 字段的value 灌入新字段中(我现在就要取Product Catalog表中的External ID字段的值，当USER每次在 Clm_Presentation_vod__c 表上insert 或者 update 数据时，就将Product_vod__c.External_ID_vod__c的值update到新建的External_ID_vod__c 字段上)。对应代码：

对应代码：

trigger NOV_Clm_Presentation_Before_InsertUpdate on Clm_Presentation_vod__c(before insert, before update){
set<Id> productIdSet=new set<Id>();
system.debug('-----------------------'+productIdSet);
for(Clm_Presentation_vod__c presentation:trigger.new){
if(presentation.Product_vod__c!=null){
productIdSet.add(presentation.Product_vod__c);
system.debug('-----------------------'+productIdSet);
}
}
map<id,Product_vod__c> productMap=new map<id,Product_vod__c>([select id,External_ID_vod__c
from Product_vod__c
where id in:productIdSet
]);
system.debug('-----------------------'+productMap);
for(Clm_Presentation_vod__c presentation:trigger.new){
if(productMap.containsKey(presentation.Product_vod__c)){
presentation.External_ID_vod__c=productMap.get(presentation.Product_vod__c).External_ID_vod__c;
system.debug('-----------------------'+presentation.External_ID_vod__c);
}
}
}