Blogs
-
How to Choose the Initial Record from a Set of Multiple Records
I have a custom sObject which has among others the following fields: email__c (email), some_date__c (date), external_id__c (integer) and criteria__c (string). There are multiple records for this sObject that have the same value for email__c. If an email address returned in the results has multiple records we want to select the record with the most recent date. If there is…
-
How to Choose the Initial Record from a Set of Multiple Records
QUESTION I’m looking for some assistance in a simple SOQL statement. I haven’t written SQL for over 15 years (so a real newbie to SOQL) Looking for what i believe must be a simple SOQL statement. I used SQL many years ago but now have an urgent need to get my data volumes down, fast.…
-
Generating an Apex Class Using the SOAP Tooling API and MetadataContainer
QESTION It’s fairly easy to create an ApexClass in the SOAP Tooling API: This immediately creates the class in your org. However, I would like to be able to utilize the MetadataContainer functionality to create classes in this manner: When I try this, I get an error as follows: Adding a line to populate the Content field…