Are you an LLM? You can read better optimized documentation at /after-insert/add-ons/related-query.md for this page in Markdown format
AfterInsert.RelatedQuery
Query children, siblings or other records once per handler per run, and read them per record with record.getRelated(name).
Signature
apex
public interface RelatedQuery {
Map<String, AfterInsert.RecordsProvider> queryRelatedOnAfterInsert();
}queryRelatedOnAfterInsert(): called at most once per handler per run, at this handler’s firstgetRelated. Returns provider name →RecordsProvider.
Example
apex
public with sharing class ContactWriter implements AfterInsert.Writer, AfterInsert.RelatedQuery {
public Map<String, AfterInsert.RecordsProvider> queryRelatedOnAfterInsert() {
return new Map<String, AfterInsert.RecordsProvider>{ 'accountContacts' => new AccountContactsProvider() };
}
public Boolean writeOnAfterInsertWhen(TriggerTypes.InsertRecord record) {
return record.isNotNull(Contact.AccountId);
}
public void writeOnAfterInsert(TriggerTypes.InsertRecord record, TriggerTypes.UnitOfWork unitOfWork) {
Id accountId = ((Contact) record.getNewSObject()).AccountId;
Integer contactCount = record.getRelated('accountContacts').getAllWhereKeyEquals(accountId).size();
unitOfWork.toInsert(new Task(WhatId = accountId, Subject = 'Contacts on the account: ' + contactCount));
}
private with sharing class AccountContactsProvider implements AfterInsert.RecordsProvider {
public List<SObject> query(TriggerTypes.InsertRecords records) {
return [SELECT Id, AccountId FROM Contact WHERE AccountId IN :records.getIdsOf(Contact.AccountId)];
}
public String keyOf(SObject row) {
return ((Contact) row).AccountId;
}
}
}RecordsProvider
Signature
apex
public interface RecordsProvider {
List<SObject> query(TriggerTypes.InsertRecords records);
String keyOf(SObject row);
}query(records): called once per provider, at the handler’s firstgetRelatedwith its name, with every record in the chunk. Returns the rows to index by key;nullcounts as no rows.keyOf(row): called once per row thatqueryreturned. Returns the key thatgetFirstWhereKeyEqualsandgetAllWhereKeyEqualsmatch;nullleaves the row out of the index.
Rules
- SOQL sees the new records. They are saved but not committed. Add
Id NOT IN :records.getIds()to leave them out. - Providers query on the first read. A provider queries when the handler first calls
getRelatedwith its name. A read in a predicate queries even when no record qualifies, so return an empty list fromquerywhen no record can qualify. - Keys are case-sensitive. Normalize text keys the same way in
keyOfand when you read. - Unknown names throw.
getRelatedwith a name the handler did not return throwsTriggerTypes.TriggerLibException, even with ContinueOnError.
WARNING
Set sharing on the provider. Its query runs under its own class's sharing keyword, and an inner class does not take its outer class's keyword.
