Can I convert this dynamic SOQL to static SOQL?

Question

String queryString =
            'SELECT Id,IsPersonAccount,RecordTypeId FROM Account WHERE LastModifiedDate < ' + 
            Ke.Job_Start_Date_Time__c.formatGmt('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'') +
                'AND RecordTypeID IN (\'' + PersonAccount + '\', \'' + BusinessAccount + '\')';

I am learning the difference between static and dynamic SOQL and I am interested to change this query from dynamic to static but I see I cannot do that since static SOQL does not provide INCLUDES. Please correct me if I am wrong

Answer 1

Yes, you can. You can continue to use the IN keyword but you need to present it slightly differently with bind variables. In fact, in this case, I actually think it makes life easier for you:

Set<Id> recordTypeIds = new Set<Id>{PersonAccount,BusinessAccount};
List<Account> accounts = [SELECT Id,IsPersonAccount,RecordTypeId FROM Account WHERE LastModifiedDate < :Job_Start_Date_Time__c AND RecordTypeId IN :recordTypesIds];