Salesforce基礎

public class MyService {
    public static List<Account> getAccounts() {
        return [SELECT Id, Name FROM Account LIMIT 10];
    }
}

trigger MyTrigger on MoveIn__c (before insert, after insert) {
    if (Trigger.isBefore && Trigger.isInsert) {
        // 保存前の処理
    }
    if (Trigger.isAfter && Trigger.isInsert) {
        // 保存後の処理
    }
}

SELECT Id, Name, MoveInDate__c
FROM MoveIn__c
WHERE Satus__c = '架電済み'
ORDER BY MoveInDate__c DESC
LIMIT 100

List<MoveIn__c> moveIns = [
    SELECT Id, Name
    FROM MoveIn__c
    WHERE Id = :targetId
];

List<MoveIn__c> moveIns = [
    SELECT Id, Name,
        (SELECT Id, type__c, AgencyStatus__c FROM ServiceGuides__r)
    FROM MoveIn__c
    WHERE Id = :targetId
];

AggregateResult[] results = [
    SELECT COUNT(Id) cnt, Satus__c
    FROM MoveIn__c
    GROUP BY Satus__c
];

// NG: ループ内でSOQLを実行するとガバナ制限に抵触
for (MoveIn__c mi : Trigger.new) {
    List<ServiceGuide__c> sgs = [
        SELECT Id FROM ServiceGuide__c WHERE MoveIn__c = :mi.Id
    ];
}

// OK: ループ外でまとめてSOQL
Set<Id> moveInIds = new Set<Id>();
for (MoveIn__c mi : Trigger.new) {
    moveInIds.add(mi.Id);
}
List<ServiceGuide__c> sgs = [
    SELECT Id, MoveIn__c
    FROM ServiceGuide__c
    WHERE MoveIn__c IN :moveInIds
];

global class MyBatch implements Database.Batchable<sObject>, Schedulable {

    // スケジュール実行用
    global void execute(SchedulableContext sc) {
        Database.executeBatch(new MyBatch(), 1);
    }

    // 処理対象のクエリを返す
    global Database.QueryLocator start(Database.BatchableContext bc) {
        return Database.getQueryLocator('SELECT Id FROM MoveIn__c');
    }

    // バッチサイズごとに実行
    global void execute(Database.BatchableContext bc, List<MoveIn__c> scope) {
        // 処理ロジック
    }

    // 完了時に1回実行
    global void finish(Database.BatchableContext bc) {
        // 後処理
    }
}