Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
When architecting a solution, I often find myself wanting to know which (of the less-used) standard objects support triggers.
Does anyone know of a single compiled list of standard objects that are not triggerable, for quick reference?
The emphasis here is on quick reference.
Following Standard objects don't support trigger, I have gathered so far as of Spring' 17 release.
UPDATED list, with a script to retrieve all non-triggerable objects on demand.
Run this and check the debug log to find out which standard objects are not triggerable:
Map<String, Schema.SObjectType> gd = Schema.getGlobalDescribe();
List<Schema.DescribeSObjectResult> standardObjDescs = new List<Schema.DescribeSObjectResult>();
for (Schema.SObjectType sobj : gd.values()) {
Schema.DescribeSObjectResult sobjDesc = sobj.getDescribe();
if (!sobjDesc.isCustom()) {
standardObjDescs.add(sobjDesc);
}
}
List<String> triggerableList = new List<String>();
List<String> NOTtriggerableList = new List<String>();
for (Schema.DescribeSObjectResult schemaDesc : standardObjDescs) {
String sobjStruct = JSON.serialize(schemaDesc);
DescribeSobjectResultJSON sobjProps = (DescribeSobjectResultJSON)JSON.deserialize(sobjStruct, DescribeSobjectResultJSON.class);
if (sobjProps.triggerable) {
triggerableList.add(sobjProps.name);
} else {
NOTtriggerableList.add(sobjProps.name);
}
}
NOTtriggerableList.sort();
for (String notTrigble : NOTtriggerableList) {
System.debug(notTrigble);
}
public class DescribeSobjectResultJSON {
public String name {get;set;}
public Boolean triggerable {get;set;}
}
(I remembered that you can expose private object properties that the API doesn't expose via getters by serializing and deserializing, so you can run the following script that uses the triggerable property on Schema.DescribeSObjectResult to get the list.)
Add to @Santanu Boral 's helpful list:
Though seeing how long this list is, it might make more sense to do a search than reference a comprehensive list...
Just as latest update, we can now develop trigger on some object given above like WorkOrder and WorkOrderLineItem.
I just developed a good workaround to list such items. Even you can use this code to filter out some other types objects (deleteable, searchable...) as well.
Add your org base URL in a remote site setting and run below given code in dev console:
String endpoint = URL.getSalesforceBaseUrl().toExternalForm()+'/services/data/v41.0/sobjects/';
HttpRequest req = new HttpRequest();
endpoint += '';
req.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
req.setHeader('Content-Type', 'application/json');
req.setEndpoint(endpoint);
req.setMethod('GET');
Http httpreq = new Http();
HttpResponse res = httpreq.send(req);
Map<String, Object> m = (Map<String, Object>)JSON.deserializeUntyped(res.getBody());
List<Object> ob = (List<Object>)m.get('sobjects');
string csv = '';
for(Object o : ob){
Map<String, Object> real = (Map<String, Object>)o;
if((Boolean)real.get('triggerable')){
csv+= real.get('name')+',';
}
}
system.debug(csv);
