The following post explains how to send a complex, stylized table formatted email with data records from your Salesforce system. For this, we will be using Visualforce Email Template, Visualforce Component with an apex custom controller. The visualforce component will be placed in the email template; the custom controller will pull the required data from Salesforce using …
Use LIKE with Collections – SOQL Query
How do we use LIKE in SOQL to find accounts that contain the string ABC? Using the following query List<Account> accList = [SELECT Id FROM Account WHERE Name LIKE %ABC%]; Lets say, there is a set of Account Names with these 3 accounts below (abc, xyz, rst) Set<String> setAccNames = new Set<String>(); setAccNames.add('ABC'); setAccNames.add('XYZ'); setAccNames.add('RST'); And …
