APEX関連

Instantiating an Apex class based on dynamic string name with Type class

saleforce

Somtimes we need to instantiate a Apex class by dynamic value in Salesforce, which can make our program more modular and more readable, such as the below case : 1. Each Contact has its socail fields : “Type__c” and “AccessToken__c” 2. Needs to request its profile via socail api in Apex First we need to […]

read more

Writing a Schedulable Batch Apex in Salesforce

schedule-apex-user-interface

To use batch Apex, you have to create an Apex class that implements interface Database.Batchable in Salesforce, like the following sample code: Execute batch Then you can use Database.executebatch method to execute it. Schedule Apex job To schedule your batch Apex to run at regular intervals, you also need an Apex class that implements interface […]

read more

Using Aggregate SOQL queries/results in Batch Apex

saleforce

In previous post, we had created a schedulable batch apex that implements Database.Batchable<sObject> in Salesforce, but if you want to use SOQL having aggregate functions like SUM(), MAX(), COUNT() on results grouped by “GROUP BY” clause in start execution, changing to interface Database.Batchable<AggregateResult> isn’t a workable way, because it fails with the below compile error […]

read more

Zip attachments only with Apex in Salesforce

Apex zip sample page

Before this post (about 2 years ago), I’d shared a post that is about how to zip attachments with JSZip and Apex in Salesforce, and recently I found a more simple way to do that thing, which is only using an Apex library named “Zippex” ( view on Github). Here is the outline of my […]

read more

To fix MIXED_DML_OPERATION error(setup and non-setup objects) in Salesforce

The following error will be occured if you’re trying to perform DML operation on both setup and non-setup objects in the same transation. ` MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): CustomObject__c, original object: User: [] ` Here is the sample code that […]

read more

Bulk Approval Processing from List View in Salesforce

Bulk Approval Request

I have shared “Approval Processing with Apex in Salesforce” in previous post, and in this post, I’ll continue to share the way of bulk approval processing from Salesforce list view. The outline we need to do is as below : ・Add a custom button for list view ・Set List View Layout ・Add a Apex Class […]

read more

Approval Processing with Apex in Salesforce

Approval Process ER

An approval process is an automated process your organization can use to approve records in Salesforce. Usually we can request/approve an approval process through the standard approval process feature, but we can also do those things with Apex in some cases such as : request/approve from VF Page or from Custom Button. Here is Approval […]

read more

Display Address type field on Visualforce Page

Account BillingAddress Field

Address is an especial type of fields in Salesforce, which is a structured compound data type, that we can’t use it directly on Visualforce page. And there will occure a compile error like “Unsupported type: common.api.soap.wsdl.Address used in expression: record.BillingAddress”, if we did that. As the code sample below, we need to use fields BillingStreet, […]

read more