Hot answers tagged

5

My answer is that it doesn't matter for this example as the volume of data you are dealing with - 340 records - is small so optimization is way down the priorities. My priority list is ballpark this if there is nothing extreme about the code: Code that works Tests that prove the code works Code that doesn't run into query or CPU or heap governor limits Code ...


3

There is no way to load more than a total of 50K records in a given synchronous session/transaction (as per the documentation), and certainly no way to do this in a trigger. The only way to deal with this sort of thing is to use async processing such as in a Batchable as you mentioned. It is possible to execute certain types of aggregate query across more ...


2

One possible solution would be to write a query to copy everything from your data extension into a new data extension. You could then check the new data extension against the original to see if any values have changed. This could all be run inside of an automation to run at an interval of your choosing. The first query in the automation will check to see if ...


2

I don't think that using an aggregate query on Agent is the right approach here. Aggregate functions and the GROUP BY keyword are meant to aggregate data about a group of records (what is the maximum value of field X for this group of records?) rather than pull out a single record from a group. What you're looking for here, assuming that CaseId is a lookup ...


1

I don't think you need a batch class for this. At the data volume you mentioned I expect somewhere between 100-200 records for Country. and maybe 500-1000 records for City you should be able to handle this with a couple of quick queries and run updates: Map<Id, Continent__c> continentsToUpdate = new Map<Id, Continent__c>(); // First, find ...


1

You should put ' ', but you don't need to escape them try that one https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+Id+from+Contact+where+Email='apple+super@gmail.com'. If you want IN you can use it like this https://{myWorkplaceDomainUsed}--sandbox.cs67.my.salesforce.com/services/data/v42.0/query/?q=select+...


Only top voted, non community-wiki answers of a minimum length are eligible